Create the control statement file that is to be specified in the database structure modification utility's (pdmod) argument. You can create the control statement file at any location. This example creates a file under the following filename:
- Contents of the control statement file
create rdarea DICLOB01 for LOB used by HiRDB(SQL_ROUTINES) 1
extension use 1000 segments
file name "/rdarea05/diclob01"
initial 10000 segments;
create rdarea DICLOB02 for LOB used by HiRDB(SQL_ROUTINES) 2
extension use 1000 segments
file name "/rdarea05/diclob02"
initial 10000 segments; |
- Explanation:
- Definition of the data dictionary RDAREA (DICLOB01)
DICLOB01 is a data dictionary LOB RDAREA for storing a definition source. The system uses the first data dictionary LOB RDAREA defined for storing a definition source. This example creates a HiRDB file named diclob01 in the HiRDB file system area. This HiRDB file has 10000 segments.
The example uses the RDAREA automatic extension feature. The extension size is 1000 segments.
- Definition of the data dictionary RDAREA (DICLOB02)
DICLOB02 is a data dictionary LOB RDAREA for storing SQL objects. The system uses the second data dictionary LOB RDAREA defined for storing SQL definitions. This example creates a HiRDB file named diclob02 in the HiRDB file system area. This HiRDB file has 10000 segments.
The example uses the RDAREA automatic extension feature. The extension size is 1000 segments.