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

[JAW]

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?

[Jan M. Nelken]

JAW wrote:

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?

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

[JAW]

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

[Jan M. Nelken]

JAW wrote:

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

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

[JAW]

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 ;