DB2 LOAD libraries



IBM's flagship relational database management system

DB2 LOAD libraries

Postby p19689 » Wed Jul 13, 2011 4:22 pm

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 ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 LOAD libraries

 

Re: DB2 LOAD libraries

Postby Robert Sample » Wed Jul 13, 2011 5:34 pm

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.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: DB2 LOAD libraries

Postby p19689 » Wed Jul 13, 2011 6:29 pm

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 ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 LOAD libraries

Postby Robert Sample » Wed Jul 13, 2011 8:49 pm

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.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: DB2 LOAD libraries

Postby p19689 » Thu Jul 14, 2011 1:28 pm

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 ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 LOAD libraries

Postby dick scherrer » Thu Jul 14, 2011 11:55 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post