How to retain the primary and secondary quantities on the Index Alter screen without specifying the Estimated Data Rows on the Index Space Calculation screen

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

When Altering an Index via RC/Update for Db2 for z/OS (RCU) and want to modify the values for Primary and/or Secondary space, enter 'S' in the CMD field
next to the Vcat/Stogroup line. This will display the Index Space Calculation screen.  Changing the Estimated Data Rows value will recalculate the space
statistics for the PRIQTY and SECQTY fields. Pressing PF3 will then retain the new primary and secondary quantities on the RC/Update Index Alter screen.

How to retain the primary and secondary quantities on the Index Alter screen without specifying the Estimated Data Rows on the Index Space Calculation screen?

Resolution

On the Index Alter screen, if you change the PRIQTY and the SECQTY fields on the Stogroup line, leave the line CMD option blank, then press ENTER,
the new values will be retained.  Pressing PF3 then displays the RC/Update Alteration Confirmation screen, and the new values for PRIQTY and SECQTY
will be displayed.