S878 abend during IBM Db2 REORG utility execution within RC/Migrator performing multi-table UTS conversion

Products

• RC/Migrator for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Batch Processor

Issue/Introduction

Using RC/Migrator for Db2 for z/OS (RCM) batch processing to convert multi-table tablespaces to Universal Table Spaces (UTS)
involving a large number of tables (e.g., ~250) encountering a S878 abend during the Db2 REORG utility execution.
This appears to occur during the allocation of image copy datasets required for REORG processing.

Symptoms:
SYSTEM COMPLETION CODE=878  REASON CODE=00000010 
ABEND=S878 U0000 REASON=00000010
DSNU016I UTILITY BATCH MEMORY EXECUTION ABENDED REASON=X'0878'  

Cause

The Db2 utility TEMPLATE default is BUFNO 30 allocating 30 buffers for each image copy dataset. In scenarios where a high volume
of table definitions are processed such as 250 tables, the combined memory requirement for all dataset allocations can exceed the
available region size, leading to the S878 storage abend.

Resolution

To mitigate the risk of this abend, specify a lower BUFNO value in the image copy dataset TEMPLATE. Reducing the buffer count
reduces the virtual storage requirement.

TEMPLATE PTICOPY  DSN 'hlq.&DB..&SN..Txxxx.S&PA..COPYxx'   
         SPACE CYL BUFNO 5 

Setting BUFNO to a smaller value (e.g., 5) significantly reduces memory usage while still allowing the utility to function effectively.

Additional Information

Adjust the TEMPLATE BUFNO value based on system available storage.