Table 65 shows the control tables shipped with QMF.
Note: iSeries requires a Collection "Q" be created before these QMF DB storage structures can be created. There are no nodegroups, table spaces or dbspaces in iSeries.
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_
DIRECTORYX |
Q.OBJECT_DATA | DSQTSCT3 | 5000 primary, 200 secondary | Contains queries, forms, and procedures represented in an internal QMF format. | Q.OBJECT_
OBJDATAX |
Q.OBJECT_
REMARKS |
DSQTSCT2 | 200 primary, 20 secondary | Contains comments that were saved when queries, forms, and procedures were created or replaced. | Q.OBJECT_
REMARKSX |
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 | 12 primary, 4 secondary | Contains information on used by QMF during installation. IMPORTANT: DO NOT MODIFY THIS TABLE | none |