Getting error messages from CA Fast Load PFL0081E and CA Rapid Reorg PRR0181E on DB2 Catalog update
Article ID: 72840
Updated On:
Products
Database Analyzer for DB2 for z/OS
Fast Unload for DB2 for z/OS
Fast Check for DB2 for z/OS
Fast Index for DB2 for z/OS
Rapid Reorg for DB2 for z/OS
Issue/Introduction
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)
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)
Environment
Release:
Component: PUT
Component: PUT
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
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
Feedback
Yes
No
Powered by
