The FLG.PARMS table does not contain metadata. It contains internal, global parameters for the Information Catalog Manager. The table is a global storage area for persistent Information Catalog Manager parameters such as version, logon message, and code page.
FLG.PARMS stores system parameters. The values in this table are set when you use the Information Catalog Manager Create Catalog Utility (see Information Catalog Manager Administration Guide). You can also use the Information Catalog Manager APIs (see the Information Catalog Manager Programming Guide and Reference) to change the values.
Table 69 provides information about each column found in the
FLG.PARMS table.
Table 69. FLG.PARMS table column properties
| Column name | Data type | Description | Nullable | NLS |
|---|---|---|---|---|
| VERSION | CHAR(20) | The version of the information catalog, for example, V1R0M0 or V1R1M0; which is populated at the installation or migration time. | Yes | SBCS |
| LOGONMSG | VARCHAR(254) | Information Catalog Manager logon message, for example, "Welcome to the Information Catalog Manager!" | Yes | Both SBCS and DBCS |
| CODEPAGE | CHAR(4) | Code page number of the information catalog. | Yes | SBCS |
| LANGUAGE | CHAR(4) | Language code, for example, ENU (US English). It is loaded from a string file. | Yes | SBCS |
| DTOKEN | CHAR(1) | The default token of the Information Catalog Manager environment used to
represent an unspecified data field. This not-applicable symbol is used
by the import and export functions.
This value is set during installation. | Yes | SBCS |
| ENVSIZE | SMALL INTEGER | Database server environment size.
This value is set during installation, and is used to specify the proper name length for Information Catalog Manager tables, columns, and indexes. This value can be 10 for DB2 UDB for AS/400, 18 for most other IBM relational databases, and up to a maximum of 30 bytes for non-IBM databases. | Yes | None |
| LASTYPID | INTEGER | The last system-generated ID for an object type. The ID is accessed and updated by the Create Registration IPI only. | Yes | None |
| LISTMAX | INTEGER | The maximum number of retrievable objects from a listing or search result. | Yes | None |
| ISTGROUP | CHAR(8) | The index storage group name for the DB2 for OS/390(R) database. | Yes | SBCS |
| TSTGROUP | CHAR(8) | The table storage group name for the DB2 for OS/390 database. | Yes | SBCS |
| MDBNAME | CHAR(8) | The DB2 for OS/390 database name. | Yes | SBCS |
| TBSPAC32 | CHAR(8) | The 32 KB table space name for the DB2 for OS/390 database. | Yes | SBCS |
| TBSPAC04 | CHAR(8) | The 4 KB table space name for DB2 for OS/390 database. | Yes | SBCS |
| PARMFLAG | INTEGER | A flag indicator.
| Yes | None |
| CMTSTAT | VARCHAR(800) | This column stores a list of comments status. Each status is 80 bytes. | Yes | Both SBCS and DBCS |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||