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

Document ID : KB000025248
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

When Altering an Index, and you want to modify the values for Primary and/or Secondary space, you would 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.

Question:

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

Answer:

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.