IBM Mainframe Forum

Hi , I can not see SDSNLOAD and SDSNEXIT libraries(as STEPLIB/JOBLIB)) in the utility jobs that have been set up. for Example the quiesce job is set up with the job card AS BELOW:

//QUIESCE EXEC DSNUPROC,SYSTEM=DB2PROD,
//* LIB='DB2.DB2PROD.PRG',
// UID=' QUIESCE'


I have issued ISRDDN from TSO to see whether the above DB2 load libraries have been allocated via any other library. But can't locate any. I would like to understand how the process works if not inclde in STEPLIB/JOBLIB. Can someone shade some light on this please ?

They are probably in the linklist. Talk to your site support group to find out for sure, as they are the ones who would know.

Thanks Rob, There is no site support group as such. The guy who does is on holidays ! This is a small site and provide OS support via a third party, whic I have no direct access. Do you know how to check this by myself ?

Do you know how to check this by myself ?

If you have access -- many sites restrict access to the data sets mentioned below -- you can find out. First, there most likely will be SYSn.IPLPARM, which will be a PDS with multiple members (n may be anything from 0 to 9). One of them is the load parameter being used for the LPAR; you may have to check the IPL documentation to see where the data set is and which member is used. That member will have two relevant lines: for example. Look in the listed PARMLIB for member IEASYSXY (where XY comes from the SYSPARM line). In this member there usually is a line that looks like In the same PARMLIB, find the PROGXY member (or PROGXY and PROG00 members depending upon what is in the PROG= statement). The linklist will be defined in one of the PROGnn members. The DB2 libraries will be part of the linklist definitions.

Thanks Rob, you are correct and I don't have read access on those datasets.
I have issued 'TSO ISRDDN LINKLIST' and listed LINKLIST and LPALIB concatenations. But couldn't see any DB2 LIBs. Is there a way that I can work backward to find out DB2 LOAD LIBS based on my dataset allocations ?

Hello,

Only if there is some local naming convention that logically connects the 2. There is no required "link" between various datasets and loadlibs for various executables. . .

It is often helpful to be curious and look for "things" but be aware that on many systems, much/most of the "system stuff" is not accessable by the applicaton developers.

Is anyone called a "dba" on the system. They may be able to help you find what you want.