Log Analyzer DDL report fails with PFR0067E - ALLOCATE FAILED FOR ARCHIVE LOG DATA

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

Log Analyzer for Db2 for z/OS (PLA) DDL report fails with:

PFR0067E - ALLOCATE FAILED FOR ARCHIVE LOG DATASET
LAE0290I Image Copy merge processing completed with errors
LAE0031E Image Copy merge task error.

Cause

Data Captures Changes not enabled for Db2 catalog tables.

Resolution

It is now a requirement as of PLA release R16 for DDL reporting that requires full row images for the
following Db2 catalog tables. Its advisable to turn Data Capture Changes on for the following;  

SYSIBM.SYSAUXRELS 
SYSIBM.SYSCHECKDEP 
SYSIBM.SYSCHECKS 
SYSIBM.SYSCHECKS2 
SYSIBM.SYSCOLAUTH 
SYSIBM.SYSCOLUMNS 
SYSIBM.SYSCONTEXT 
SYSIBM.SYSCONTEXTAUTHIDS 
SYSIBM.SYSCTXTTRUSTATTRS 
SYSIBM.SYSDATABASE 
SYSIBM.SYSDATATYPES 
SYSIBM.SYSDBAUTH 
SYSIBM.SYSDBRM 
SYSIBM.SYSFIELDS 
SYSIBM.SYSFOREIGNKEYS 
SYSIBM.SYSINDEXES 
SYSIBM.SYSINDEXPART 
SYSIBM.SYSKEYCOLUSE 
SYSIBM.SYSKEYS 
SYSIBM.SYSKEYTARGETS 
SYSIBM.SYSPACKAGE 
SYSIBM.SYSPACKAUTH 
SYSIBM.SYSPACKDEP 
SYSIBM.SYSPACKLIST 
SYSIBM.SYSPACKSTMT 
SYSIBM.SYSPARMS 
SYSIBM.SYSPKSYSTEM 
SYSIBM.SYSPLAN 
SYSIBM.SYSPLANAUTH 
SYSIBM.SYSPLANDEP 
SYSIBM.SYSPLSYSTEM 
SYSIBM.SYSRELS 
SYSIBM.SYSRESAUTH 
SYSIBM.SYSROLES 
SYSIBM.SYSROUTINEAUTH 
SYSIBM.SYSROUTINES 
SYSIBM.SYSSCHEMAAUTH 
SYSIBM.SYSSEQUENCEAUTH 
SYSIBM.SYSSEQUENCES 
SYSIBM.SYSSEQUENCESDEP 
SYSIBM.SYSSTOGROUP 
SYSIBM.SYSSYNONYMS 
SYSIBM.SYSTABAUTH 
SYSIBM.SYSTABCONST 
SYSIBM.SYSTABLEPART 
SYSIBM.SYSTABLES 
SYSIBM.SYSTABLESPACE 
SYSIBM.SYSTRIGGERS 
SYSIBM.SYSUSERAUTH 
SYSIBM.SYSUSERAUTH 
SYSIBM.SYSVIEWDEP 
SYSIBM.SYSVIEWS 
SYSIBM.SYSVOLUMES 
SYSIBM.SYSXMLRELS 
SYSIBM.SYSXMLTYPMOD 
SYSIBM.SYSXMLTYPMSCHEMA 

If DATA CAPTURE CHANGES is not enabled for the above tables, Log Analyzer will read archive
logs back to the most recent image copy of the Db2 catalog tablespaces to obtain full row images.