Storage acquisition failed for RALSTB in statistics collection
search cancel

Storage acquisition failed for RALSTB in statistics collection

book

Article ID: 204008

calendar_today

Updated On:

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.