Displays the current number of modified blocks of pages the database manager allows in data spaces before it writes them to DASD.
>>-SHOW SAVEINTV----------------------------------------------->< |
This command displays the database's current save interval. The save interval is measured in blocks of 4KB pages (32 pages in a block). The save interval is the upper limit on the number of modified blocks allowed in a data space at any one time. When the number of modified blocks in any one data space exceeds this limit, the database manager writes all the modified blocks in that data space to DASD. The default is 10 blocks (or 320 pages).
| Note: | For a block to be "modified" the database manager only needs to change one page in that block. The block will remain "modified" until it is written to DASD. |
| Note: | This command is not allowed when no storage pools are using data spaces. For example, when the storage pool specification file specifies BLK for all storage pools. This is true even if the directory is in a data space, or if unmapped data spaces are used for internal dbspaces (if SEPINTDB=Y is used), or both. |
+--------------------------------------------------------------------------------+ |show saveintv | |SAVEINTV = 10 | |ARI0065I Operator command processing is complete. | +--------------------------------------------------------------------------------+