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|
|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|
|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
Important: Do not modify this table.
|Q.GLOBAL_VARS||DSQTSGLV||110 primary, 20 secondary||Contains system and user-defined global and session variables.||Q.GLOBAL_VARSX|