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?
Release : 20.0
Component : CA Database Analyzer for DB2 for z/OS
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.