IBM Data Studio requires SYSLH200 (& SYSSTAT) in Db2Z. how to create?

Brian Laube

IBM Data Studio requires SYSLH200 (& SYSSTAT) in Db2Z. how to create?

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][108][10149]DB2Binder stopped: Failure to create connection for binding.

  SQLCODE: -4230

  SQLSTATE: 42968

  Message: [jcc][t4][10509][13454][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

 

 

 

Javier Estrada Benavides

RE: IBM Data Studio requires SYSLH200 (& SYSSTAT) in Db2Z. how to create?
(in response to Brian Laube)

Hey Brian 

   Probably I didn't run into this case with Data Studio as I originally created a lot of NULLID packages, but I've run across the same thing over peak DDF workloads. It's enough to just execute the JDBC binder again from USS with the option -action add, and use a big number for the -size param. Normally I'm fine with a -size 80 but you can try other number.

The syntax is right here:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/java/src/tpc/imjcc_r0023708.html

Cheers :)

 

Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

Javier Estrada Benavides

RE: IBM Data Studio requires SYSLH200 (& SYSSTAT) in Db2Z. how to create?
(in response to Javier Estrada Benavides)

Oh, I forgot the other part..

 If it fails (as it's failing for you), just make sure that you have all required jar files into the CLASSPATH environment variable before you run the binder utility, the commands for this are located right here:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/java/src/tpc/imjcc_jccenvironmentvars.html

Cheers

 

Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

Brian Laube

RE: IBM Data Studio requires SYSLH200 (& SYSSTAT) in Db2Z. how to create?
(in response to Javier Estrada Benavides)

Hi Javier,

Thanks for your input!  To be clear for anyone who might have cared... I have resolved my issue.  

As you suggested, I needed to update my (windows) CLASSPATH environment variable to include the Data Studio license file.  I updated the path to include the full directory and file name.

At first, I did not update the CLASSPATH at all.  The IBM knowledge center documentation is subjectively weak in telling me to update the CLASSPATH.  Then I updated CLASSPATH with the directory of the license file.. and the I updated the CLASSPATH with the full path and filename.  Then "java db2binder" worked and created all the SYS* packages for distributed connections.  and they work too.  Great.

 

regards,

Brian Laube