Migrating LOB data

Martin Flavell

Migrating LOB data
Hi all,

I have some tables on a DB2 for AIX system, that contain LOB data (up to
10Mb for each column, but average 12K). I need to move these tables to DB2
for z/OS, together with their data. Has anyone had to do this before, or
have any suggestions on how to proceed?

Thanking you in advance.

Regards,

Martin

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Edward Long

Re: Migrating LOB data
(in response to Martin Flavell)
I do this regularly.
Cross System Loader works great for non-lob dependent
tables. You better be very current on CSL and Db2
Connect maintenance however. FP 10A for Db2
Connect/UDB. If CSL didn't have the 32k limit on LOB
data this utility would be your answer...Jim!!.

SQL/SERVER DTS allegedly can copy the lob data.

Your best bet for the lobs is to write a program per
table that consists of a SELECT * Cursor with fetches
to unload the AIX version into load format. You create
a second dataset for the lob data with a matching key
to the primary unload dataset.

Then on the z/OS side you will need a program that
does inserts from the unloaded data.

3rd option, you can use the UDB Export/Import
utilities. The Import has the potentially severe
limitation that it will only do inserts onto z/OS. If
you have big lobs this could be painful from a logging
and locking perspective. This does work however.
Sounds like a StarTrek thing however; remember the
Ferengi and the 'you don't have the lobes for it
insult'.

To do this we always, even for the unload, alter the
lob tablespace to locksize tablespace and turn off
logging. Our insert program religiously issues
commits.

I have seen some traffic that BMC, among others now
provide a lob aware Unload and Load.

Good luck. Let us know how you handle this item.
--- [login to unmask email] wrote:
> Hi all,
>
> I have some tables on a DB2 for AIX system, that
> contain LOB data (up to
> 10Mb for each column, but average 12K). I need to
> move these tables to DB2
> for z/OS, together with their data. Has anyone had
> to do this before, or
> have any suggestions on how to proceed?
>
> Thanking you in advance.
>
> Regards,
>
> Martin
>
>
---------------------------------------------------------------------------------
> 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". The IDUG
> DB2-L FAQ is at http://www.idugdb2-l.org. 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


=====
Edward Long

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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