DB2 graphic  QMF Version 8

QMF views

The following table describes the views shipped with QMF.

Table 66. Views shipped with QMF
View name Table viewed Operating system
Q.DSQEC_ALIASESL SYSIBM.SYSTABLES z/OS
SYSCAT.TABLES workstation
QSYS2.SYSTABLES iSeries
Q.DSQEC_COLS_LDB2L SYSIBM.SYSCOLUMNS z/OS
SYSIBM.SYSTABAUTH z/OS
SYSCAT.COLUMNS workstation
SYSCAT.TABAUTH workstation
QSYS2.SYSCOLUMNS iSeries
Q.DSQEC_COLS_RDB2L SYSIBM.SYSCOLUMNS z/OS
SYSIBM.SYSTABAUTH z/OS
Q.DSQEC_QMFOBJSL Q.OBJECT-DIRECTORY All operating systems
Q.OBJECT_REMARKS All operating systems
Q.DSQEC_TABS_LDB2L SYSIBM.SYSTABAUTH z/OS
SYSIBM.SYSTABLES z/OS
SYSCAT.TABAUTH workstation
SYSCAT.TABLES workstation
QSYS2.SYSTABLES iSeries
Q.DSQEC_TABS_RDB2L SYSIBM.SYSTABAUTH z/OS
SYSIBM.SYSTABLES z/OS
Q.RESOURCE_VIEW Q.RESOURCE_TABLE All operating systems
Q,DSQ_RESERVED_DB SYSIBM.SYSCOLUMNS z/OS
QSYS2.SYSCOLUMNS iSeries
SYSCAT.COLUMNS workstation
Q.DSQ_RESERVED_OBJ Q.OBJECT_DIRECTORY All operating systems

Several of these views are based on DB2 system tables and are used by QMF for the LIST and DESCRIBE functions.

You can create/recreate all QMF control table views on any supported DB2 database from z/OS by running job DSQ1BVW JCL. This job will DROP and CREATE all QMF control table views and GRANT necessary authorities.

On z/OS, if you want to enable QMF control table views for DB2 secondary authorization IDs, you must run this job to refresh the QMF views for that DB2 database.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004