The Partition List does not reflect the number of partitions in the tablespace and contains blank values for STOGROUP.

book

Article ID: 4792

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

When altering an Index from non-partitioned to partitioned using RC/Update, the Partition List on the CA - Index Alter screen does not display the expected results.

<Please see attached file for image>

Partition List.JPG

 

i. Only 10 partitions are listed

Using PF7/PF8 to scroll down through the list of partitions will show a maximum of 10 partitions.

Why does this not reflect the number of partitions in the Tablespace?

 

ii. The STOGROUP field is blank.

Why does RC/Update not populate the STOGROUP field with the STOGROUP defined for the non-partitioned index?

Cause

There are two reasons for these results:

- Automatic Partition Management is not enabled

- No Object Definition Defaults exist for this UserId

With Automatic Partition Management disabled, by default only 10 partitions are displayed, regardless of the number of partitions in the Tablespace. So in this instance, when the Index is altered to PARTITIONED then the CA - Index Alter screen displays a Partition List with only 10 partitions. It is then up to the User to manage the partitions manually.

 

If Automatic Partition Management is enabled, then the number of partitions listed will match the number of partitions in the Tablespace. Additionally, the partition fields will be populated with any defaults defined for this User.

Environment

Release:
Component: RCU

Resolution

i. To enable Automatic Partition Management on the CA- Alter Index screen: 

- set the PARTITIONED field to YES 
- enter command AUTOPARTS ON 
- enter command AUTOPARTS SAVE if you want to save this as your default setting 

The Partition List should now reflect the actual number of partitions in the tablespace. 



ii. Now for the partition fields to be populated we need Object Definition Defaults defined for this user. 

- enter command DEF or DEFaults 

The Object Definition Defaults for this User will be displayed.

- enter a default value for Stogroup either at the Global level or Index level. 
- enter S for Action to save this default definition 

For the new Object Definition Defaults to take affect, PF3 out and back into RC/Update.

 

Now with AUTOPARTS enabled and default values defined, when you alter PARTITIONED to YES for an index, you should now have a Partition List reflecting the number of partitions in the Tablespace and also any object default values defined for this User will be populated in the Partition List fields.

Attachments

1558699781423000004792_sktwi1f5rjvs16osl.jpeg get_app