search cancel

How to find parameter values set in previous release

book

Article ID: 16168

calendar_today

Updated On:

Products

PanAudit Plus Easytrieve Report Generator PAN/SQL

Issue/Introduction

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

Environment

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

Resolution

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