Samples
The parts for System Parameters data are as follows.
Examples of CREATE TABLE, LOAD statements, SQL queries, and descriptions of these tables are in library RKO2SAMP. The description files are in a format that can be loaded into Db2 tables.
The CREATE TABLE examples can be used for building the Db2 tables into which the System Parameters File data sets can be loaded. The Db2 load utility control samples can be used for loading these File data sets into Db2 tables.
| Type of data | CREATE TABLE statements | Load control statements | Table description |
|---|---|---|---|
| System parameters | DGOWC106 | DGOWL106 | DGOWD106 |
| System facility parameters | DGOWCSFP | DGOWLSFP | DGOWDSFP |
| Alter buffer pool | DGOWC201 | DGOWL201 | DGOWD201 |
| Buffer pool attributes | DGOWC202 | DGOWL202 | DGOWD202 |
| Group buffer pool attributes | DGOWC230 | DGOWL230 | DGOWD230 |
| Alter group buffer pool | DGOWC256 | DGOWL256 | DGOWD256 |