Step 11--Recreate QMF views (optional): DSQ2BVW

There may be times when it is necessary to recreate the QMF control tables views. This can be accomplished by running the job DSQ2BVW, which is on the QMF distribution disk. This job will DROP and CREATE al QMF control table views and perform the necessary GRANTs to any QMF supported DB2 server. The following prerequisites must be met before the job can be run:

• QMF Version 7.2 must be installed on the target server.
• You must be linked to the QMF VM distribution disk.
• You must be linked to the DB2 VM product disk, and the DB2 database machine must be active.
• DRDA connectivity to the target server must be configured.
• The CONNECT ID at the target server must have the following authorities:
  • DBA authority on DB2 VM and VSE
  • SYSADM authority on DB2 OS/390
  • SYSADM authority on DB2 workstation
  • *ALLOBJ authority on iSeries

On the CMS command line, enter:

DSQ2BVW dbn

where dbn is the name of the target DB2 database server that you want to recreate the QMF control table views on. For further details on the DSQ2BW job, see QMF views

Note: This job can be rerun from the beginning.