CLOB data on 390

Tim Curley

CLOB data on 390
Our customer wants to add a column to the middle of a
table that has a CLOB of 32k at the end of it.

To do this they want to unload and reload the CLOB data.
When they run an unload(using IBM unload) they get an error stating
that there is a 32k flat file restriction. How can they convert the
table to a new table without truncating the clob data? What if the
clob was 2gig? Is there a utility that handles this?

Any help would be appreciated. They are running on DB2 V7 os/390.

Thanks,

Tim

_________________________________________________________________
Expand your wine savvy — and get some great new recipes — at MSN Wine.
http://wine.msn.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roland Schiradin

AW: CLOB data on 390
(in response to Tim Curley)
We deal with several large LOB's > 100MB LOG YES.

To do a reorg to release extents and also to add new columns we do as follow
1. Create a shadow-table-space
2. Create a the table using the new columns
3. INSERT INTO shadow-table SELECT * FROM origin-table
4. Drop origin table/table-space and repeat step 1-3

We still dealing with lob corruptions (we do Updates!!) with IBM.
Latest problem results in Hiper-APAR PQ82032 and still working with
IBM to fix a timing window (difficult) and received serveral usermods to
find the causer. Among other APAR's

I remember there is a requirement for the reorg. Hopefully DB2 V8 will handle
this

Regards Roland



-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Timothy Curley
Gesendet: Montag, 5. Januar 2004 23:31
An: [login to unmask email]
Betreff: CLOB data on 390


Our customer wants to add a column to the middle of a
table that has a CLOB of 32k at the end of it.

To do this they want to unload and reload the CLOB data.
When they run an unload(using IBM unload) they get an error stating
that there is a 32k flat file restriction. How can they convert the
table to a new table without truncating the clob data? What if the
clob was 2gig? Is there a utility that handles this?

Any help would be appreciated. They are running on DB2 V7 os/390.

Thanks,

Tim

_________________________________________________________________
Expand your wine savvy - and get some great new recipes - at MSN Wine. http://wine.msn.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Glenn Shelton

Re: CLOB data on 390
(in response to Roland Schiradin)
Tim,

BMC Software's Database Administration for DB2 solution release 7.3.02, due
to GA at the end of January 2004 is specifically aimed at handling the type
of situation you are facing. The 7.3.02 release will include support for
LOB data up to 32MB.
There may be other vendor products as well. If you would like more
information, please contact me off list.

Glenn Shelton
Sr. Product Line Manager, Change Manager for DB2
BMC Software INc.
[login to unmask email]

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm