The following table describes the 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.