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 |