how to find parameter values set in previous release

Article Id: 16168

Status: Published

Updated On: 14-02-2018 07:51

Legacy Id: TEC1855674

Products:

CA PanAudit Plus , CA Easytrieve Report Generator , CA PAN/SQL

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

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

Environment:

Release: EDBMSU00200-11.5-Easytrieve-Report Generator-Option for DB2-MSU
Component:

Resolution:

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