DB2/UDB Load Issues

[cnguyen]

Our environment:

DataStage 7.5 on AIX
DB2 Connect Version 8
DB2 Database V7 on Z/OS

The DB2/UDB Load stage does not work. The error message returned was "SQL1325N The remote database environment does not support the command or one of the command options."

The DB2/UDB Load Stage documentation said that this stage is used to load data into a UDB table.

Does this mean this stage does not work for DB2 database on a mainframe? Can someone verify?

Thanks

[ray.wurlod]

Or does it mean that DB Connect v8 can not send correct commands to DB2/390 v7 (version mismatch), or does it mean that DB2/390 and DB2/UDB are different beasts?

[ArndW]

Does that mean that the other methods do work and that load is the only one with this error?

[Klaus Schaefer]

It's true, you cannot use UDBLoad for mainframe target, UDBLoad only works for for UDB on UNIX/Windows.

For mainframe you can create the load file and place it on the host. You would then have to run a mainframe JCL to run the DB2 load utility.

Another alternative would be to use the DSEE MVS component, which generates COBOL and JCL for the mainframe and indeed directly could load into UDB/mainframe.

Best regards

Klaus

[cnguyen]

Klaus,

Thanks for confirming this. Not what I wanted to hear but oh well. It looks like DB2/UDB API is the only stage that is working for DB2 on a mainframe.