Table partitioning, CLOB and BLOBs in DB2 9 LUW?
Table partitioning, DB2, BLOB, CLOB, LOB
Hi all,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!!!
Thanks
Enuda
