DB2 graphic QMF Version 8

Navigating the tree

The QMF for WebSphere Report Center tree consists of three main branches:

Favorites

The Favorites branch lists reports and folders of reports that you have selected and placed in the folder. The reports and folders reside on your machine's local hard drive or on a network drive. The actual entry in your Favorites folders points to the object on the database server that is used to create the report. That object does not actually reside in your Favorites folder, it remains safely on the database server. The entry in your Favorites folder also contains the instructions as to how the report will be formatted.

DB2 UDB Servers

Each database server that has been configured in the server definition file (SDF) is by default displayed as a branch under the DB2 UDB servers branch. The SDF used is configured and distributed by your QMF for Windows Administrator.

Each database server branch lists the objects (could be contained in folders) that have been created and saved to that database server and a Public Favorites folder that is created when QMF for WebSphere Report Center and QMF for WebSphere are installed.

There is only one Public Favorites folder on a database server, however, it can contain many subfolders. The Public Favorites folders list the reports that have been saved to the database server by one or more users of QMF for WebSphere Report Center. Your view of the Public Favorites folders (what reports are listed and that you can access) is dictated by security permissions that are specified using the QMF resource limits and security permissions specified when the report was created. Reports that reside on the Public Favorites folders point to an object that is used to retrieve data from a database server to create a report.

Your access to the objects on a database server is dictated by the permissions granted to your user ID and password as well as security permissions that are specified by the QMF for Windows Administrator using the QMF resource limits. If you can access an object (query, table, procedure) from the Report Center tree based on the permissions granted to user ID, then you can run the object and obtain query results. The query results are formatted using default formatting. By directly running an object from a database server you are creating an "ad-hoc" report. In order to save those query results, you must save them as a report in either the personal Favorites or the Public Favorites (if you have permission) folders. Saved reports point to the objects that were used to create them, and the formatting that is to be applied to the query results.


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