Querying the status of ALTER processing for HALDBs

To determine whether alter processing is complete when altering the structure of an online HALDB database, you can use the IMS type-2 command QUERY OLREORG NAME(partname | *) STATUS(ALTER | ALTINPRG | ALTDONE).

You can issue the command for one, some, or all partitions in a HALDB database.

If you specify NAME(*) on the command with STATUS(ALTER), IMS returns the alter status of all of the partitions in the database. If you specify NAME(*) with either STATUS(ALTINPRG) or STATUS(ALTDONE), IMS returns only the partitions in the database with the specified status.

If you specify the name of one or more partitions, IMS returns the alter status of only the specified partitions.

A partition in a HALDB that is being altered can be in the following states:

ALTINPRG: Indicates that the partition is either currently being altered or is queued for altering.
ALTDONE: Indicates that alter processing is complete for the partition. The ALTER COMPLETE status of a partition remains in effect until Online Change is performed to activate the ACB members for the new database structure.
ALTINQUE: Indicates that alter processing has not yet started for the partition.

Procedure

To query the status of an alter operation on an online HALDB database, issue the type-2 command QUERY OLREORG NAME(partname | *) STATUS(ALTER | ALTINPRG | ALTDONE).