ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

In R20 of IDB2, what variable replaces AUTHFAIL-OBJECT?

book

Article ID: 200101

calendar_today

Updated On:

Products

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 Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

In IDB2 R20, the AUTHFAIL-OBJECT variable is no longer available.  What IQL variable replaces it?

Environment

Release : 20.0

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

Resolution

In R20 of IDB2 (Sysview for DB2) the IQL variable OBJECT-TYPE replaces AUTHFAIL-OBJECT.

Additional Information

OBJECT-TYPE was changed from an external to internal DECLARE field because the "OBJECT-TYPE" field exists in more than one IFCID. Since IFCIDs 361 and 404 had the OBJECT-TYPE field being translated from a one-character value to a meaningful word/phrase, it made sense to remove the DECLARE for IFCID 140 AUDIT-FAILURES and use the same internal table that is used for IFCID 361 and IFCID 404. That ensures that the two tables don't become out-of-sync or outdated.
ObjectTypes DC ((C'Z'-C'A')+1)CL16' '
ObjectDef A,'ACEE '
ObjectDef B,'Bufferpool '
ObjectDef C,'Collection '
ObjectDef D,'Database '
ObjectDef E,'Distinct type '
ObjectDef F,'Function '
ObjectDef G,'Session variable'
ObjectDef H,'Global variable '
ObjectDef J,'Jar '
ObjectDef K,'Package '
ObjectDef L,'Role '
ObjectDef M,'Schema '
ObjectDef N,'Trusted context '
ObjectDef O,'Procedure '
ObjectDef P,'Application plan'
ObjectDef Q,'Sequence '
ObjectDef R,'Tablespace '
ObjectDef S,'Storage group '
ObjectDef T,'Table or view '
ObjectDef U,'User auth '
ObjectDef W,'Row '
ObjectDef Z,'zParm '
ORG ,