CA RC/Query FREEPACK command PP189E error occurred CSECT PPA$DB2I STATEMENT 273

Products

• RC Compare for DB2 for z/OS
• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

From the CA RC/Query for DB2 for z/OS (RCQ) Collection Package Inquiry panel attempting to issue a FREEPACK command next to a package which returns the following error:

COMMAND ===> FREEPACK 
PP189E: Error occurred in CSECT PPA$DB2I, statement 273 

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "SYSADM". SOME SYMBOLS 
THAT MIGHT BE LEGAL ARE: <END-OF-STATEMENT> 
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE 
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR 
DSNT416I SQLERRD = 3 0 0 -1 23 502 SQL DIAGNOSTIC INFORMATION 
DSNT416I SQLERRD = X'00000003' X'00000000' X'00000000' 
X'FFFFFFFF' X'00000017' X'000001F6' SQL DIAGNOSTIC 
INFORMATION

Environment

Release:
Component: RCQ

Resolution

It was discovered that the cause of the error was related to the following setting on the CA Database Management Solutions for DB2 for z/OS main panel:

SQLID ==> 'SYSADM

Once the SQLID value was correct the problem was resolved.