MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

We are exploring the ways the calls to the various SPs could be logged in a centralized place. The details to be logged are
a. Name of the SP
b. Start time of the SP
c. End-time of the Sp
d. Input parameters passed to the SP
e. Output parameters passed by the Sp

Please note that the WLMs/SPAs(Work load Mgr/SP Address Space) runs in different LPARs.

Is there any DB2 utility that will perform this function or any other way.

kolusu · Posted: Thu Oct 09, 2003 5:00 am Post subject:

vani,

Are the different LPARS inter-connected via DB2's Distributed Request Data Access architecture?? If they are then you can create a simple DB2 table in one of the LPARS and insert the data when ever the stored procedure is execueted.

check this topic which discusses about Accessing tables in different DB2 sub-systems
http://www.mvsforums.com/helpboards/viewtopic.php?t=67

If the LPARS are not inter-connected , then I don't think there is a way to accumulate the data in a centralized location

Hope this helps...

cheers

kolusu

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

SQL CALL failed due to SQLCODE = -991
rc1=000c
rc2=00F30006

Iam issuing a CONNECT before the CALL to the stored procedure but it is failing with the above error.

Please tell us how to compile, link-edit, bind and run the stored procedure.

Regards,
Vani

kolusu · Posted: Thu Oct 09, 2003 2:25 pm Post subject:

vani,

From the RC2=00F30006, it is evident that the 'Subsystem Name' was not found during connection processing. Make sure that you have the correct DB2 subsystem name.

Check this link for a detailed explanation on rc2 of 00F30006 http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/4.26.6?SHELF=&DT=20010718150520

Now for the sqlcode of -991

For stored procedures running in the WLM-established stored procedure address space the application must be link-edited with or dynamically allocate the RRS attachment language interface module (DSNRLI), not CAF.

Any way check this link for a detailed explanation of sql code -991

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.432?SHELF=&DT=20010718150520

Hope this helps...

cheers

kolusu