Table partitioning, CLOB and BLOBs in DB2 9 LUW?

15 pts.
Tags:
BLOB
CLOB
DB2
LOB
Table partitioning
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
ASKED: January 31, 2008  8:48 PM
UPDATED: January 31, 2008  9:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following