Scalable Database Server, HiRDB Version 8 Installation and Design Guide
This section describes the names of the following sample files:
Table 24-1 lists and explains the directories and files used with the sample database.
The sample files are provided in a Japanese version (containing single-byte Kana characters) and an English version. Unless Shift JIS is being used as the character encoding set, the English version of the sample files should be used.
Table 24-1 Directories and files used with sample database
| Name of directory or file | Contents | Remarks |
|---|---|---|
| tblecreate1 | Table definition statements (including schema definitions) | pddef input format |
| loadinf 2 | Control statements for pdload | Shell |
| loaddata | Input data for data loading | Directory |
| CONTROL_FILE | Control statements for data loading |
Table 24-2 lists the contents of the sample configuration.
This sample configuration uses values based on the minimum configuration in order to simplify the relationships among parameters; these are not the optimum values.
Table 24-2 Contents of sample configuration
| Classification | Contents | File name | ||
|---|---|---|---|---|
| HiRDB/Single Server | HiRDB/Parallel Server | |||
| System definitions | System common definition | pdsys | pdsys | |
| Unit control information definition | pdutsys | pdutsys1, pdutsys2 | ||
| Server common definition | pdsvrc | |||
| Single server definition | sds01 | |||
| Front-end server definition | fes1 | |||
| Back-end server definition | bes1, bes2 | |||
| Dictionary server definition | dic1 | |||
| Allocation/ initialization of HiRDB file system areas | Shell for allocating RDAREAs | fmkfile | fmkfile | |
| Shell for allocating system log, synchronization point dump, and status files | sysfmkfs | sysfmkfs1, sysfmkfs2 | ||
| Shell for initializing system log, synchronization point dump, and status files | sysfinit | sysfint | ||
| Log unloading | Shell for unloading system log files | logunld | feslogunld, bes1logunld, bes2logunld, diclogunld | |
| Database initialization utility | Shell for creating control statements | mkinit | mkinit | |
| Database initialization utility control statements | rdinit01* | rdinit01* | ||
| Execution of operation commands under aliases | Sample of shell script for executing operation commands under aliases | Bourne shell | aliascmdbsh | aliascmdbsh |
| C shell | aliascmdcsh | aliascmdcsh | ||
The UOC shown below is provided. Table 24-3 shows the contents of the sample UOC.
For details about UOCs, see the manual HiRDB Version 8 Command Reference.
Table 24-3 Contents of sample UOC
| File name | Contents |
|---|---|
| sample1.c | Example of UOC for entering DAT-format input files by the database load utility |
| sample2.c | Example of UOC for entering binary-format input files |
| sample4.c | Functions used by sample2.c |
| sampleA.c | Example of UOC that prevents output of unneeded data to an unload file |
| sampleB.c | Example of UOC that outputs a UOC data file |
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.