I have a mainframe Db2 in the corner of my data center which never had a requirement for DDF. DDF was never enabled in the past.
I decided to enable DDF on this lonely Db2 so I can look into this mainframe DB2 using Data Studio (instead of SPUFI or other ISPF tools.. or batch jobs)
Data Studio uses a java type 4 driver for connecting to mainframe Db2 (Data Studio does not require IBM Data server client installed… Data Studio uses a simple driver)
IBM Data Studio apparently includes a license to allow it to connect to any Db2 Z
We enabled DDF on this lonely mainframe Db2.
I was able to connect to this Db2 via Data Studio. Cool.
I then ran my first ad-hoc SQL via Data Studio against this Db2 and Data Studio had an error because of a missing package
DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=HSTDB2GW.NULLID.SYSLH200.5359534C564C3031;DISTSERV;04, DRIVER=4.24.92
Is there a way to BIND the required packages for Data Studio? Data Studio should have a way to bind the required packages!
- Reviewing the accounting trace package history for Data Studio on my other Db2… I see Data Studio using packages of SYSLH200 and SYSSTAT
This SYSLH200 package is something that I would normally create or BIND from IBM (Db2) Data Server client
But I cannot use IBM (db2) data server client with this mainframe Db2 because the client does not have a license for this Db2. Ok. Fine. That makes sense.
But does Data Studio have a method or tool to bind the required (minimum) packages that it needs?? How does one do that?
As a digression… I did find (via google) that an alternative to DB2 client command of BIND (from Db2 command window) is Java Db2binder. But my attempts to use this java functionality (from the same workstation as my Data Studio) fail with a permission error. (I probably don’t know what I am doing here)
Is java Db2Binder a good path to explore to bind the required packages? Or do you suggest something else?
C:\Users\laubebr\IBM\DS4.1.3\dsdev\jar>java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://<mainframeserver_name>:5025/HSTDB2GW -user dblaube -password xyzxyzxy -action replace -collection NULLID
[jcc]DB2Binder stopped: Failure to create connection for binding.
Message: [jcc][t4][3.72.52] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid
or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to
the data server and using DB2 Connect Unlimited Edition for System z, perform the
activation step by running the activation program in the license activation kit.
If you are using any other edition of DB2 Connect, obtain the license file,
db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation