unload data on DB2 Z/OS to DB2 UDB on Windows

I have some tables on DB2 Z/OS 7.1 with SMALLINT, DECIMAL, TIMESTAMP,
DATE and CHAR datatypes.

I already have unload utilities crafted so I would just like to unload
some data on Z/OS for about 10 tables and then load them on the Windows
Server which runs DB2 UDB 8.2 .

My issue of course is with the NON-CHAR conversion.

Will using ASCII operand on Z/OS unload utility and then FTP'ing to
windows in Binary mode be the panecea?

Should I try to unload everything in basic CHAR format and FTP over in
ASCII and then do the load?

Suggestions?

re: unload data on DB2 Z/OS to DB2 UDB on Windows

JAW wrote:[color=blue]
> I have some tables on DB2 Z/OS 7.1 with SMALLINT, DECIMAL, TIMESTAMP,
> DATE and CHAR datatypes.
>
> I already have unload utilities crafted so I would just like to unload
> some data on Z/OS for about 10 tables and then load them on the Windows
> Server which runs DB2 UDB 8.2 .
>
> My issue of course is with the NON-CHAR conversion.
>
> Will using ASCII operand on Z/OS unload utility and then FTP'ing to
> windows in Binary mode be the panecea?
>
> Should I try to unload everything in basic CHAR format and FTP over in
> ASCII and then do the load?
>
> Suggestions?
>[/color]

Connect to database on z/OS from Windows Db2 client - use export --> import/load
method with .IXF format of export/import file.

Jan M. Nelken

re: unload data on DB2 Z/OS to DB2 UDB on Windows

Sounds like a good idea!

I would like to use the UNLOAD format since the data is going offsite
and not network time since the tables are large.

DB2 Unload in 7.1 does not appear to have the options on Platinum's
FASTUNLOAD where you can specify EXTERNAL on OUTPUT-FORMAT

re: unload data on DB2 Z/OS to DB2 UDB on Windows

JAW wrote:[color=blue]
> Sounds like a good idea!
>
> I would like to use the UNLOAD format since the data is going offsite
> and not network time since the tables are large.
>
> DB2 Unload in 7.1 does not appear to have the options on Platinum's
> FASTUNLOAD where you can specify EXTERNAL on OUTPUT-FORMAT
>[/color]

ZIP works fine.

There is also separate product called DB2 High Performance Unload. Key is to use
..IXF format - so you can laod data to DB2 for Windows.

If you use Db2 client to connect to DB2 for z/OS in order to export data in IXF
- code page conversion is done for you. If you use IXF format - you do not need
to create tables on DB2 for Windows.

Jan M. Nelken

re: unload data on DB2 Z/OS to DB2 UDB on Windows

Jan,

Thanks!

I used the db2 -f command to export all of the Z/OS tables under a
certain user. I had to create a wrapper and server to point to the Z/OS
machine and then I created synonyms. It works great! The other way
worked also but it requires more work in crafting the load utility.

export to ab_pct_tbl.ixf of ixf messages msgs.txt select * from
db2admin.ab_pct_tbl ;
export to acs_tbl.ixf of ixf messages msgs.txt select * from
db2admin.acs_tbl ;
export to addresses.ixf of ixf messages msgs.txt select * from
db2admin.addresses ;
export to aims_cntl_tran.ixf of ixf messages msgs.txt select * from
db2admin.aims_cntl_tran ;