PDA generated SQL -305.

book

Article ID: 4568

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

SQL-305 detected in PDA program RAAUSUBP. Could also happen in RAACATB or RAAUBD8

 

There is no error message in the PDA job, however the SQL-305 is seen in e.g. CA Detector

Cause

This can happen during action processing when processing a LOB tablespace with Parmlib option SPACE_SYM_SOURCE(AUTO_PDA) or (PDA) when PDA stats have not been collected at least once.

Environment

Database Analyzer job

Resolution

This is NOT an error. PDA handles the SQL-305. It is an expected SQL code and PDA detects it.

 

If you do not want this SQL-305 to occur, consider changing SPACE_SYM_SOURCE to either (AUTO_RTS) or (RTS) to avoid accessing the PDA stats tables during action processing.   Another option would be to collect at least one set of PDA stats for the LOB objects but keep in mind with this option that over time the PDA stats may no longer accurately represent the current space utilization of the LOB unless PDA stats are recollected periodically.   

Additional Information

PDA parmlib description of the SPACE_SYM_SOURCE keyword:

/* Primary source for setting  */  

/* space-related symbolics.    */  

/* PDA = Use PDA stats tables  */  

/*   for both conditional and  */  

/*   unconditional actions.    */  

/* RTS = Use DB2 RTS tables    */  

/*   for both conditional and  */  

/*   unconditional actions.    */  

/*   Also consider using:      */  

/*   SHOW_PDA_ACT_CONDS (N)    */  

/* AUTO_PDA = Automatically    */  

/*   determined based on type  */  

/*   of condition(s) selected. */  

/*   Unconditional actions     */  

/*   will use PDA stats tables.*/  

/*   Default setting.          */  

/* AUTO_RTS = Same as AUTO_PDA */  

/*   except when unconditional */  

/*   actions RTS tables used.  */  

/*   Recommended for RTS users.*/  

/*   Also consider using:      */  

/*   SHOW_PDA_ACT_CONDS (N)    */  

/* When PDA or RTS stats not   */  

/* available for an object,    */  

/* DB2 catalog will be used.   */