Table 95 shows the control tables shipped with QMF. For more information about the control tables, see the Installing and Managing QMF for OS/390 manual.
Note: iSeries requires a Collection "Q" be created before these QMF DB storage structures can be created. There are no nodegroups, tablespaces or dbspaces in iSeries. On VM, DBSPACEs are acquired using DSQ2DBSP EXEC.
Control table name | Table space | Table space size (in 1K units) | Table content | Index |
---|---|---|---|---|
Q.PROFILES | DSQTSPRO | 100 primary, 20 secondary | Contains QMF profiles that hold information about individual users' access to resources and data during a QMF session. | Q.PROFILEX |
Q.OBJECT_
DIRECTORY |
DSQTSCT1 | 200 primary, 20 secondary | Contains general information about all QMF queries, forms, and procedures in the database. | Q.OBJECT_
DIRECTORY |
Q.OBJECT_DATA | DSQTSCT3 | 5000 primary, 200 secondary | Contains queries, forms, and procedures represented in an internal QMF format. | Q.OBJECT_
DATAX |
Q.OBJECT_
REMARKS |
DSQTSCT2 | 200 primary, 20 secondary | Contains comments that were saved when queries, forms, and procedures were created or replaced. | Q.OBJECT_
REMARKS |
Q.COMMAND_
SYNONYMS |
DSQTSSYN | 100 primary, 20 secondary | Contains information on the command synonyms. | Q.COMMAND_
SYNONYMNSX |
Q.RESOURCE_
TABLE |
DSQTSGOV | 100 primary, 20 secondary | Contains resource control information passed to the governor exit routine. | Q.RESOURCE_
INDEX |
Q.ERROR_LOG | DSQTSLOG | 100 primary, 20 secondary | Contains information on system, resource, and "unexpected condition" errors. This information is more detailed than that found in error messages. | none |
Q.DSQ.
RESERVED |
DSQTSRDO | 100 primary, 20 secondary | Contains information on used by QMF during installation. IMPORTANT: DO NOT MODIFY THIS TABLE | none |