You can display information on the current address spaces available for your database machine with the CP QUERY SPACES command. For example, the following command was issued at the operator console:
+--------------------------------------------------------------------------------+ |#cp query spaces | |CP QUERY SPACES | |ASIT STORAGE P/S SPACE IDENTIFICATION | |03EF750000000002 17M PRV SQLDBA:BASE | |03EF758000000004 29952K PRV SQLDBA:DIR0000000000 | |03EF75C000000003 87M PRV SQLDBA:MAP0000000000 | |03EF754000000005 200M PRV SQLDBA:UNM0000000000 | +--------------------------------------------------------------------------------+
The first address space, BASE, is the primary space for the database machine. DIR, MAP, and UNM identify data spaces for the directory, storage pools, and unmapped internal dbspaces respectively. (Remember that a data space is an address space that contains only data. You cannot run programs from a data space; they must first be loaded into a primary address space.)
If the database machine required an additional data space for its storage pools, it would be identified as MAP0000000001. The size of each address space is listed under STORAGE.
Do not be surprised if you do not see all the data spaces you expect. VMDSS creates spaces as it needs them. For example, a data space will only be created for unmapped internal dbspaces when you request a sort that cannot be contained in the local buffer pool.
For more information on this command refer to VM/ESA: CP Command and Utility Reference.