By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
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 ;

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.