Db2 for z/OS & Db2ZAI

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi Charles. If you have been able to connect you must have a driver or a version of the Db2 client software installed on your local machine. I'm not familiar with the CMOD product so perhaps it comes with it.

A remote Db2 Connect client requires a license in order to connect to Db2 on z, so unless the CMOD software comes with a runtime copy of the license like Data Studio does, you need a Db2 Connect license on your machine (unless server-based licensing is enabled). According to your description you have not been restricted from connecting, but instead get an error on sql execution.

The error message is definitely saying that a required cli package is not created at the z/OS Db2 location you are connecting to. 

If you have a Db2 client, you most likely have the necessary pieces to execute the bind. The files will be in the bnd folder under SQLLIB.  A resource (generally on MF) with BIND authority will have to execute the bind so the packages get created and granted execute to PUBLIC. In some shops the DBA performs these while others have a System Admin perform binds for database "tools".

If you only have the driver package, then you will not have the necessary files and would need to get the client from the IBM site for installation on a client machine before the above bind is performed. 

If there are other Db2 on z subsystems at your company that support remote access, these packages must be in place. Perhaps the support area that performed the bind in these can be determined and then can simply perform the new BIND in your CMOD system. They may have the components and process available to perform for you.

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!

Hi Charles,

I believe we create those packages in our shop by running the "JCC Binder" job, referenced here: https://www.ibm.com/docs/en/db2-for-zos/12?topic=installation-db2binder-utility

Here is some sample JCL.  You'll need to customize it for your libraries, JAVA directories, etc.

//*******************************************************
//DB2BNDR  EXEC PGM=AOPBATCH,PARM='sh -L'                
//*******************************************************
//SYSTSPRT DD SYSOUT=*                                   
//SYSPRINT DD SYSOUT=*                                   
//SYSUDUMP DD SYSOUT=*                                   
//STDERR   DD SYSOUT=*                                   
//STDOUT   DD SYSOUT=*                                   
//STDIN    DD *                                          
export JAVA_HOME=/Root/java/J8.0_sr2fp10_bit64/     
export JCC_HOME=/Root/db2/v12/RSU2206A/jdbc/        
export LD_LIBRARY_PATH=$JCC_HOME/lib                     
PATH=$JAVA_HOME:$JAVA_HOME/bin:$PATH                     
PATH=$JCC_HOME/bin:$PATH                                 
export PATH=$JZOS_HOME:$PATH                             
LIBPATH=$JCC_HOME/lib:$LIBPATH                                           
LIBPATH=$JAVA_HOME/bin/classic:$JAVA_HOME/bin:$LIBPATH                   
export LIBPATH=$JZOS_HOME:$LIBPATH                                       
CLASSPATH=$CLASSPATH:${JCC_HOME}/classes/db2jcc4.jar                     
CLASSPATH=$CLASSPATH:${JCC_HOME}/classes/db2jcc_javax.jar                
CLASSPATH=$CLASSPATH:${JCC_HOME}/classes/db2jcc_license_cisuz.jar        
CLASSPATH=$CLASSPATH:${JCC_HOME}/classes/sqlj4.zip                       
export CLASSPATH=$CLASSPATH                                              
java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://1.2.3.4:5555/LOCATION \  
   -user USERNAME -password XXXXXXXX   \              
         -action replace                                                 

------------------------------
Steve Johnson

Original Message:
Sent: Fri May 24, 2024 11:50 AM
From: Charles Renaud
Subject: -805/51002 error connecting to z/OS from LUW tools

Hi, all,

First, disclaimer that I am primarily a LUW guy with very limited mainframe experience.  That said, I'm working on a project that's mainframe-heavy and am trying to come up to speed quickly.

I'm working with IBM Content Manager OnDemand for z/OS.  When I have worked with CMOD (distributed) in the past, I've used a lot of scripts that just hit DB2 directly.  I'm trying to do the same thing here.

When I try to connect to DB2 z/OS from my laptop, I'm always getting the same -805/51002 error.  Doesn't matter if I'm using DBeaver, DbVisualizer, VS Code Extension, or Data Studio.

After talking to the DBA, he told me the following:

"The issue is that the tools are attempting to use this package to connect to DB2: "...NULLID.SYSLH200....".  That package does not exist in the CMOD databases.  You would need to install DB2 Connect on your laptop, connect to the DB2, and then you will be able to connect to CMOD with your tools."

I consider myself competent with DB2 LUW, but this sounds foreign to me.  Can someone explain like I'm 5?  I understand what DB2 Connect is/does, but not in this context.  Am happy to provide more detail if needed.

Thanks in advance!