|
|
|
Monitoring is used, for example, for physical tuning and buffer tuning. Use a periodic IDCAMS LISTCAT command to monitor the physical attributes of the NDB, including DASD space, number of extents, and CI splits.
An NDB itself does not need reorganization internally. VSAM, however, might need to reorganize to remove excessive CI and/or CA splits if a large amount of key addition, deletion, or value changing takes place. This can be accomplished by using standard IDCAMS services to backup, delete, redefine, and restore the data set.
Important! You must not change the VSAM key length or maximum record length during this reorganization. If you do, the NDB will not be usable.
If you need to increase the key length, the NDB must be logically unloaded, deleted, recreated, and logically reloaded.
The SHOW VSAM command allows you to determine whether the NDB performance would benefit from increased buffering, if not running from the LSR pool, or from increases or changes in the LSR pool definition. Standard VSAM tuning techniques should be followed.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |