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.
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
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