QMF control tables and table spaces for TSO and CICS®
These are the control tables shipped with QMF.
If you installed QMF in a DB2® for iSeries database, these control tables are installed in collection Q instead of in these table spaces.
Important: To ensure that you can recover QMF operations to a specific point
in time if necessary, back up all of these tables at the same time.
| Control table name | Table space | Table space size (in 1 KB 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, procedures, folders, and analytic objects in the database. | Q.OBJECT_ DIRECTORYX |
| Q.OBJECT_ REMARKS | DSQTSCT2 | 200 primary, 20 secondary | Contains comments that were saved when queries, forms, procedures, and analytics objects were created or replaced. | Q.OBJECT_ REMARKSX |
| Q.OBJECT_DATA Q.OBJECT_DATA2 |
DSQTSCT3 | 5000 primary, 200 secondary | Contains queries, forms, procedures, folders, and analytic objects represented in a format that is internal to QMF. Q.OBJECT_DATA2 is for Db2® for Linux®, UNIX, and Windows databases only. | Q.OBJECT_ OBJDATAX |
| Q.COMMAND_ SYNONYMS | DSQTSSYN | 100 primary, 20 secondary | Contains information about QMF command synonyms. The Q.COMMAND_SYNONYMS table stores synonyms for English. | Q.COMMAND_ SYNONYMNSX |
|
Q.COMMAND_ SYNONYM_n |
DSQTSSYn | 100 primary, 20 secondary | Contains information about the QMF command synonyms. The Q.COMMAND_SYNONYMS table stores synonyms for English. There is a Q.COMMAND_SYNONYM_n table for each QMF NLF; replace the n with the 1-character identifier for the national language you are using. For older QMF installations, these tables may all be in the DSQTSSYN table space. | Q.COMMAND_ SYNONYMNX_n |
| 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 about system, resource, and unexpected errors. This information is more detailed than the information provided in error messages. | None |
| Q.DSQ_RESERVED | DSQTSRDO | 12 primary, 4 secondary | Contains information used by QMF during
installation. Important: Do not modify
this table.
|
None |
| Q.GLOBAL_VARS | DSQTSGLV | 110 primary, 20 secondary | Contains system and user-defined global and session variables. | Q.GLOBAL_VARSX |