Storage acquisition failed for RALSTB in statistics collection

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

An extract procedure has failed when executing a scan when collecting column statistics.

Collection of TS - dbname.tsname           .partno - Started           

Storage acquisition failed processing   RALSTB                         

Collection of TS - dbname.tsname           .partno - RC0016           

How can this error be avoided?

Environment

Release : 20.0

Component : CA Database Analyzer for DB2 for z/OS

Resolution

We would recommend lowering the number of scans between 3 and 5.

This recommendation is important particulary for an Extract Procedure with 'Column stats: A' and if there is a large number of partitioned objects in the extract. When object selection contains many partitioned objects where the number of partitions is high then we can expect greater column contention.

PDA Parmlib parameter EXTRACT_SCANS was introduced for this purpose, to help control and automate the number of scans at execution time. To automate this you could set this to EXTRACT_SCANS (ZIIP) or perhaps EXTRACT_SCANS (ZIIP+1) to base the number of scans on the number of available online zIIPs at execution time.