User Guide

SAP AG November 2002
Size of a page: 8 KB
DEVNO_BIT_COUNT is set to 8
SAP DB can therefore manage 256 data volumes. Each data volume can have a
maximum size of 128 GB.
The value that was set for DEVNO_BIT_COUNT when the database instance
was installed should not be subsequently changed. If you change this database
parameter during database operation, you must then recover the database
instance to update the numbering of the data volumes.
Possible values for DEVNO_BIT_COUNT: 6 <= DEVNO_BIT_COUNT <= 12
The higher the value of the database parameter DEVNO_BIT_COUNT, the more data
volumes can be managed. However, a high number of data volumes means the capacity of
the individual data volumes is reduced.
INSTANCE_TYPE
The general database parameter [Page 79] INSTANCE_TYPE denotes the database instance
type [Page 132].
• OLTP: SAP DB OLTP [Page
149]
• LVC: liveCache [Page
140]
• BW: SAP DB OLAP [Page
149]
• CS: SAP DB Document Server [Page
147]
• EMERGE: SAP DB E-Catalog [Page
148]
JOIN_MAXTAB_LEVEL9
The special database parameter [Page 80] JOIN_MAXTAB_LEVEL9 denotes the maximum
number of tables allowed in a join when selecting the join sequence algorithm.
The default value is 4.
See also:
JOIN_SEARCH_LEVEL [Page
83]
JOIN_MAXTAB_LEVEL4
The special database parameter [Page 80] JOIN_MAXTAB_LEVEL4 denotes the maximum
number of tables allowed in a join when selecting the join sequence algorithm.
The default value is 16.
See also:
JOIN_SEARCH_LEVEL [Page
83]
User Manual: SAP DB 82