The index identifier of the index for which a global buffer is to be allocated is specified in the -i option of the pdbuffer operand in the system common definition. In the case of a cluster key index, the index identifier assigned by HiRDB is specified. Once a table with a cluster key has been defined, the index identifier for the cluster key can be obtained by retrieving from the dictionary tables the INDEX_NAME column of the SQL_INDEXES table. In this case, the index identifier for the cluster key is displayed as follows:
(CLUSTER table-number)
For details about dictionary table retrieval and the SQL_INDEXES table, see the manual HiRDB Version 8 UAP Development Guide.
The number of global buffer sectors should at least equal the number of index pages (value obtained as the index storage page count). It may be necessary to increase or decrease this number depending on the importance of the index. The number of index pages in use can be checked with the database condition analysis utility (pddbst).
The name of the RDAREA for which a global buffer is to be allocated is specified in the -r option of the pdbuffer operand in the system common definition.
To allocate a LOB global buffer, use the following procedure:
The following shows the organization of the RDAREAs:
Type of RDAREA | RDAREA name |
---|---|
Master directory RDAREA | RDMAST |
Data directory RDAREA | RDDIR |
Data dictionary RDAREA | RDDIC |
User RDAREAs | USER01, USER02, USER03 |
User LOB RDAREA | ULOB03 |
Data dictionary LOB RDAREAs | DICLOB01, DICLOB02 |
List RDAREA | LIST01 |
The following shows an example of global buffer definition:
pdbuffer -a DGB1 -n 1000 -r RDMAST,RDDIR,RDDIC 1 |