Upgrade to CA DB2 R20.0, IQL EXCP0366

book

Article ID: 211026

calendar_today

Updated On:

Products

CA Sysview Performance Management Option for DB2 for z/OS

Issue/Introduction

Upgrade to CA SYSVIEW for DB2 Release 20.0. There was a daily Job working with IQL Request EXCP0366 that is run to review the incompatible changes to DB2. How does this Job have to be updated to work with the Release 20.0 version of IQL Request EXCP0366?. 

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

You have to copy the the IQL Request EXCP0366 from your R200.CDBATREQ library to the REQUEST library in your JLC. 
  
Double check you have the right DB2VER parameter in your JCL for the current DB2 Version, the R20.0 EXCP0366 Request works with this parameter. 
  
In the R20.0 EXCP0366 Request you have to update the output section to print the report to //EXCP0366  DD. 
  
After the TITLE = ('Pgms Affected by DB2 Rel Changes IQL Excp') statement add the PRINT (EXCP0366) statement. 
  
TITLE = ('Pgms Affected by DB2 Rel Changes IQL Excp')
PRINT (EXCP0366)
TERMINAL (help=DBGRAPE,nodata=DBGNTRA)