Creating database objects for the QMF catalog

The second step to enabling QMF catalog functionality is to review and run the SQL that is used to create the database objects for the QMF catalog.

About this task

This step of the process is necessary only if catalog objects were created on the data source or the existing catalog objects need to be updated.

To modify the SQL statements that will be used to create or update the required database objects:

Procedure

  1. If you chose to create or update catalog tables, the Choose object listing option page of the QMF Catalog Wizard opens.
  2. Select an object listing option from the radio group:
    • Include all objects - This option includes the QMF objects, such as Visual Query and Procedures, which are saved in the database, regardless of a user's ability to access them.
    • Include QMF objects accessible by either the user's primary or current authorization ID
    • Include QMF objects accessible by any of the user's primary or current authorization ID
  3. Click Next.
    The Creating objects page of the QMF Catalog Wizard opens.
  4. Specify a table space option.

    The Table Space option is enabled or disabled depending upon the target database of export destination. This option is enabled only if the target data source is Db2 for z/OS and non-UTS. The datasource is UTS or non-UTS is determined by the user selection while creating relational data source.

  5. The SQL that will be used to create or update the tables is displayed in the field. Type any changes that you want to make to the SQL statements directly in the field. You can modify any of the SQL statements to customize any parameters. You can not change the name of any of the objects. You must use a semi-colon(;) to separate multiple statements. Unless absolutely necessary, it is recommended that you run the SQL as it is displayed.
    Note: You can switch the RDBI.PROFILE_VIEW to use RDBI.PROFILES or Q.PROFILES tables by specifying them in SQL. When you switch the table, you must specify correct values for the ENVIRONMENT column for each CREATOR.
    • In the existing table row for a particular CREATOR, specify <NULL> to make the creator available for both QMF for TSO and CICS and QMF for Workstation.
    • Copy the existing table row for a particular creator and replace TSO or CICS with WINDOWS. The creator is available for both QMF for TSO and CICS and QMF for Workstation.
  6. Click Next. A QMF catalog named Default will be created when this step is run. The Protect QMF Catalog tables page of the wizard opens.