Use the authorization-identifier.index-identifier format to specify the index to which the index global buffer is allocated in the pdbuffer operand's -i option in the system common definition.
For a cluster key, HiRDB determines the index identifier. Therefore, after you have defined the table that specifies the cluster key, search the INDEX_NAME column of the SQL_INDEXES table (a dictionary table) to confirm the index identifier. The cluster key's index identifier is displayed as follows.
(CLUSTER table-number)
For details about dictionary table retrieval and the SQL_INDEXES table, see the HiRDB Version 9 UAP Development Guide.
When an index global buffer is allocated to the defined index, terminate HiRDB normally, and then specify the pdbuffer operand to allocate the index global buffer. If you omit this task, the defined index will use the data global buffer allocated to the index storage RDAREA.
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 |