My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and CLOB, LOB and BLOB work to share his or her experience with me as I embark on my DB29 adventure. My first question are this:
(a) Wha are the size limit, if any, for CLOB, LOB BLOB column in DB29 LUW and DB28 for z/OS if archiving and rollforward is enabled?
(b) Is incremental backup possible with CLOB, LOB and BLOB tables? If so, can backups be merged?
(c) Can I go in and alter partitions dynamically?
(d) What can anyone talk about CLOB, LOB, BLOB forward recovery and Full archive logging?
(e) How long and what does it take to convert a non-partitioned table to a partition table?
Don't woirry, I will be doing some serious reading of my own but I love to read what all the Gurus and masters and imperial wizards have to say!! Believe it or not, it always makes my day, when I read your post!!!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!