Pan/SQL has been reinstalled but the source for the previous version can't be found but only the load libraries are available.
How to make sure that the parameter values are set the same as previously in order 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, how to find the previous values for :
MAXCUR
MAXSTMT
DB2REL
MAXGRP
HLDCUR
Release: EDBMSU00200-11.5-Easytrieve-Report Generator-Option for DB2-MSU
Component: PAN/SQL
The offsets to determine the values of the parameters that are currently 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