Getting error messages from CA Fast Load PFL0081E and CA Rapid Reorg PRR0181E on DB2 Catalog update

Document ID : KB000072840
Last Modified Date : 09/03/2018
Show Technical Document Details
Issue:
CA Fast Load and CA Rapid Reorg got the following error messages from Database Analyzer Services.
 
Database Analyzer Services 18.0                                   
Catalog Update processing - Started  - SYSID DB2S                 
DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION                     
DSNT416I SQLERRD    = 0  0  1  -1  0  0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000001'       
         X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC     
         INFORMATION                                              
SYSTABLEPART  - DSNDB04.TABLE1                   Catalog Updated  
Catalog Update processing - Complete - SYSID DB2S                 
Timestamp used to update DB2 catalog: 2018-03-06-14.53.04.730000  
PUT0350I - PDA Processing Complete                                
PUT0019I - Elapsed Time: 00:00:09  -  06 MAR 2018 14:53:04        
                                                                  
PFL0081E - Updating Catalog Statistics failed                     
           NO RESTART for this function                             
 
Additionally there is the following error message.
 
PDA: Error detected inserting into PTLOG_CTSTATS_1105 log table during Catalog Update (SLS)
  
Resolution:
When CA Fast Load or CA Rapid Reorg is executed with UPDATE-CATSTATS ALL and a site has a license for CA Database Analyzer (PDA) rows are inserted into table PTI.PTLOG_CTSTATS_1105. Based on the message returned it appears that the inserts into table PTI.PTLOG_CTSTATS_1105
are failing. Table PTI.PTLOG_CTSTATS_1105 is in table space PTDB.PTRALGT7.

Please check table space PTDB.PTRALGT7 is in RW status or there is any kind of problem with space.

If you do not like to insert rows into PTLOG_CTSTATS_1105 table then you can work UPDATE-CATSTATS RSD option to call RUNSTATS to update the DB2 Catalog statistics.

You can read the details for this option in the following link:
 
UPDATE-CATSTATS—Update the DB2 System Catalog

https://docops.ca.com/ca-fast-load-for-db2-for-z-os/18-0/en/reference/product-syntax/keyword-descriptions/update-catstatsupdate-the-db2-system-catalog