Page 1 of 1

DB2 LOAD libraries

PostPosted: Wed Jul 13, 2011 4:22 pm
by p19689
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 ?

Re: DB2 LOAD libraries

PostPosted: Wed Jul 13, 2011 5:34 pm
by Robert Sample
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.

Re: DB2 LOAD libraries

PostPosted: Wed Jul 13, 2011 6:29 pm
by p19689
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 ?

Re: DB2 LOAD libraries

PostPosted: Wed Jul 13, 2011 8:49 pm
by Robert Sample
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:
SYSPARM (XY,L)
PARMLIB SYS1.PROD.PARMLIB
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
PROG=XY
or
PROG=(XY,00)
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.

Re: DB2 LOAD libraries

PostPosted: Thu Jul 14, 2011 1:28 pm
by p19689
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 ?

Re: DB2 LOAD libraries

PostPosted: Thu Jul 14, 2011 11:55 pm
by dick scherrer
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.