This statement specifies the number of simultaneously accessible spaces.
Definition
A lower-level DBH option of SYSTEM-LIMITS
Function
A space is a BS2000 file. Each database has one catalog space, which contains the metadata with the database schemas, and up to 999 user spaces, in which tables and indexes are stored.
You use the DBH option SPACES to specify the total number of spaces to be concurrently accessible during the DBH session. It does not matter whether or not the spaces really are accessed. If database A consists of 10 spaces, for example, you have to specify a value >= 10 for the SPACES option even if only 5 spaces are accessed concurrently in this case.
Note that the number of simultaneously accessible spaces affects the number of possible CREATE SPACE statements.
You can adjust the value of the option during the DBH session by means of the RECONFIGURE-DBH-SESSION administration statement (see "RECONFIGURE-DBH-SESSION").
SPACES |
= *STD / <integer 1..254000> |
Operands
SPACES = *STD / <integer 1..254000>
Specifies the maximum number of simultaneously accessible spaces during the DBH session. The default for SPACES depends on the maximum number of entries the SQL database catalog can contain (see the DBH option SQL-DATABASE-CATALOG on "SQL-DATABASE-CATALOG"). It is 10 * (DBH option SQL-DATABASE-CATALOG). The maximum value for SPACES is 1000 times the value of SQL-DATABASE-CATALOG, since a database can contain a maximum of 1000 spaces.If a value less than 2 * (DBH option SQL-DATABASE-CATALOG) is specified, it is corrected automatically to 2 * (DBH option SQL-DATABASE-CATALOG).
Information on the number of space accesses
You obtain information on the total number of space accesses during the DBH session from the “I/O” form of the SESAM/SQL monitor SESMON (see "DBH form I/O"). SESCOSP, which permits the evaluation of request logging (see "Evaluating request logging with SESCOSP"ff), also provides information on the number of times individual spaces are accessed.