After upgrading Sysview for Db2 to r20 both NATURAL-DB2 and AUTHFAIL-OBJECT are undefined
search cancel

After upgrading Sysview for Db2 to r20 both NATURAL-DB2 and AUTHFAIL-OBJECT are undefined

book

Article ID: 199953

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

After upgrading Sysview Performance Management Option for Db2 for z/OS (IDB2) both NATURAL-DB2 and AUTHFAIL-OBJECT are being flagged as undefined. 

The IDB2 data collector startup shows the following:

REQUEST xxxxxxxx FROM STARTUP      
UNDEFINED IQL VARIABLE NATURAL-DB2.

REQUEST xxxxxxxx FROM STARTUP                       
MISSPELLED RESERVED WORD OR LITERAL AUTHFAIL-OBJECT

Cause

Both NATURAL-DB2 and AUTHFAIL-OBJECT variables are no longer defined in IDB2 r20 and should not be referenced in user defined IQL.

Resolution

Both NATURAL-DB2 and AUTHFAIL-OBJECT variables are no longer used in r20.  It is important that after upgrading to r20 you ensure any
user IQL or sysparm member is derived from the r20 release.  In this particular case, recommendation was made to review the shipped IDB2 r20
AUTHFAILE and AUDCLAS6 from the IDB2 r20 hlq.CDBATREQ library and make the necessary adjustments to the correlating
custom IQL in the hlq.REQUESTS library.