Examples of selectively processing a range of partitions

For the following examples, the DB PCB usage is restricted to a range of three HALDB partitions: A, B, and C. The DFSHALDB statement specifies partition A and NUM=3.

The partitions contain the following root key ranges:

• Partition A contains the records with the root keys 201 through 400.
• Partition B contains the records with the root keys 401 through 600.
• Partition C contains the records with the root keys 601 through 800.

GU rootkey=110

The root key 110 is outside of the range of root keys in the partitions. IMS returns an FM status code.

GU rootkey=240 GN rootkey=110

The processing moves forward from root key 240 to find a key that is equal to 110. Because 110 is lower than 240, IMS returns a GE status code.

GU rootkey=240 GN rootkey>=110

The processing moves forward from root key 240 to find a key that is equal to or greater than 110. If a key is not found before reaching the end of the partition, IMS returns a GB status code.

GN rootkey>=110

The processing attempts to start the search at key 110. Because the key is outside of the root key range of the partitions, IMS returns an FM status code.

GU rootkey=810

The root key 810 is outside of the range of root keys for the range of partitions. IMS returns an FM status code.

GU rootkey=440 GN rootkey>=110

The processing moves forward from root key 440 to find a key that is equal to or greater than 110. If a key is not found before the end of the partition is reached, IMS returns a GB status code.