Statistics collection stage ends with warning message PUT0354W executing Rapid Reorg utility

Products

• Rapid Reorg for DB2 for z/OS
• Database Analyzer for DB2 for z/OS

Issue/Introduction

While the reorganization of the tablespace completes successfully, the statistics update of the DB2 catalog fails.
The job ends with a Return Code 10 / COND CODE 10. 

This message is also seen:
PUT0354W - PDA product has not been installed
DB2 Connection failed - SYSID xxxx return code 0106 reason code 00000000

 

Environment

Release: R19, R20
Component: PRR

Cause

The COLLECT-PDASTATS and STATS-LOCID parameters are only to be used if Database Analyzer for DB2 for z/OS (PDA) is also installed.

 

Resolution

Check for these parameters in the job SYSIN statement and remove the COLLECT-PDASTATS and STATS-LOCID keywords if PDA is not utilized or installed.

If these are not specified in the reorg statement then check the hlq.CDBAPARM UTIL member and change default to :

COLLECT-PDASTATS (NO)

(STATS-LOCID can be removed from the UTIL member if found)