Fellow Moose and Ranchers:
I have a 2-tier, client (PC win) - Server (z/OS MVS DB2) environment that I'm trying to write an application (it compiles cleanly, so I'm not asking for someone to code this from scratch, I've done that, however, to give fair warning, I'm a newbie at it.) that is a
JAVA application using
JDBC to do a simple query against a server database.
I'm looking for:
1) a definitive set of definitions for the PC (DB2 Connect) that will properly get me to the mainframe. I believe that I have them, however, I get so many conflicting answers from other sources.
2) a definitive set of definitions within the program for the two critical pieces of: url and connection parameters. I believe that I have them, however, I get so many conflicting answers from other souces on various combinations of these.
I've tried the different options such as .app. and .net. in the driver parm. The .app. says it cannot find the driver, at least the .net. is knocking on the door.
I'm quite certain it's the DB2 connect definition setup, that even the IBM documentation is clearly unclear, yet they have what appears to be a great 'cheat sheet' document and I've followed it.
Side question: Does anyone know about FixPak 4, for DB2 UDB Version 8.1? There was a reference on the IBM site to that FP, but looking for it, I cannot find it, has anyone else?
Regards,
Gary J
COLO SPGS