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
DB2/UDB Load Issues
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Does that mean that the other methods do work and that load is the only one with this error?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact:
Re: DB2/UDB Load Issues
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
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
Re: DB2/UDB Load Issues
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.
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.