how to find parameter values set in previous release

Document ID : KB000016168
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

I have reinstalled Pan/SQL but don't have the source for the previous version, just the load libraries and want to make sure that the parameter values are set the same as previously, to avoid batch failures with the newly installed version.

 

Question:

Is there any way of finding out what parameter values are set in Pan/SQL ?

In particular we want to know the values for : 

MAXCUR 

MAXSTMT 

DB2REL 

MAXGRP 

HLDCUR

 

 

 

 

 

 

 

 

 

Answer:

The offsets to determine the values of the parameters you currently have set in OMSMCMD2 can be found by opening any one of the following Pan/SQL loadlib members (for Browse). 

DQSPSCC 

DQSPSCF 

DQSPSCG

DQSPSCI 

DQSPSCS

DQSPSXC

DQSPSXI

DQSPSXS 

then do a Find on the planname (DQPS024 is default). 

The offsets for the parameters are: 

PLAN column 01 for 8 bytes 

MAXGRP column 13 for 4 bytes 

MAXSTMT column 17 for 4 bytes 

MAXCUR column 37 for 4 bytes 

HLDCUR column 65 for 4 bytes 

the parameter values are shown in hexadecimal. 

As an example :

DQPS024 ...\...........q...................{...............q...........{...q.... 

CDDEFFF4000E0000000000090002000000000000000C001100000000000900030000000C00290000 

4872024000200001000A001800180000001000060020001800000010001800200003002000180000 

PLAN=DQPS024 

MAXGRP=1, 

MAXSTMT=10, 

MAXCUR=6, 

HLDCUR=3