QMF views

The following table describes the views shipped with QMF.

Table 98. Views shipped with QMF
View Name	Table Viewed	Operating System
Q.DSQEC_ALIASES	SYSIBM.SYSTABLES	OS/390
	SYSCAT.TABLES	workstation
	QSYS2.SYSTABLES	iSeries
Q.DSQEC_COLS_LDB2	SYSIBM.SYSCOLUMNS	OS/390
	SYSIBM.SYSTABAUTH	OS/390
	SYSCAT.COLUMNS	workstation
	SYSCAT.TABAUTH	workstation
	QSYS2.SYSCOLUMNS	iSeries
Q.DSQEC_COLS_RDB2	SYSIBM.SYSCOLUMNS	OS/390
	SYSIBM.SYSTABAUTH	OS/390
Q.DSQEC_COLS_SQL	SYSTEM.SYSCOLUMNS	VM
	SYSTEM.SYSTABAUTH	VM
Q.DSQEC_QMFOBJS	Q.OBJECT-DIRECTORY	All operating systems
	Q.OBJECT_REMARKS	All operating systems
Q.DSQEC_TABS_LDB2	SYSIBM.SYSTABAUTH	OS/390
	SYSIBM.SYSTABLES	OS/390
	SYSCAT.TABAUTH	workstation
	SYSCAT.TABLES	workstation
	QSYS2.SYSTABLES	iSeries
Q.DSQEC_TABS_RDB2	SYSIBM.SYSTABAUTH	OS/390
	SYSIBM.SYSTABLES	OS/390
Q.DSQEC_TABS_SQL	SYSTEM.SYSCATALOG	VM
	SYSTEM.SYSTABAUTH	VM
Q.RESOURCE_VIEW	Q.RESOURCE_TABLE	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 VM or OS/390:

On VM, run job DSQ2BVW EXEC.
On MVS, run job DSQ1BVW JCL.

These jobs will DROP and CREATE all QMF control table views and GRANT necessary authorities.

On OS/390, if you want to enable QMF control table views for DB2 secondary authorization IDs, you must run one of these jobs to refresh the QMF views for that DB2 database.

[ Previous Page | Next Page | Contents | Index ]