Accessing the data
The data you will use to create BI content exists on your
enterprise information systems, in databases. So, before you begin
to develop BI content (reports, visual dashboards, queries etc.) you
must access the data that serves as the "raw material" for what you
will create.
Creating personal repositories
QMF users can create their own personal repositories. Personal repositories are local to the individual user and are generally only used by that individual. Administrators can also create personal repositories on behalf of a user.
Connecting to a repository
In order to access a repository and run repository objects using QMF you must be connected to a repository.
Specifying user information
You can use the Set User Information dialog to change the user ID and Password that a query will use when connecting to a data source.
Changing user interface configuration information
The QMF for Workstation user application interface configuration information consists of the JDBC driver information and repository connection settings that are used to connect to shared repositories and data sources.
Importing Settings from QMF for Windows
You can import QMF for Windows settings and preferences.
Correct format for identifiers
The maximum length of table owner, table name, object owner, object name, as well as column name identifiers depends on the version and platform of Db2.
Matching patterns
When entering query, form and table names for searching, you can use the percent (%) and underscore (_) characters to match patterns.
Creating new objects or repository items
QMF supplies numerous wizards to help you create new objects.
Creating web links to data objects
Use the Web Link wizard to create web links to QMF objects. You can use these links to open the objects directly in web browsers.
Saving objects
You can save the objects that you create to a repository, to a QMF catalog, or to a file. In order to facilitate saving objects, QMF offers several save commands and save wizards.
Opening saved objects
The information that you must specify in order to open a saved object varies depending on where the object was saved.
Migrating catalog objects
Typically, the QMF objects are stored in the catalog. You can enable the QMF catalog functionality for Db2 for z/OS, Db2 for LUW, and Db2 for iSeries. If you want to move QMF objects from one Db2 database to another Db2 database, you can migrate the QMF objects from an existing QMF catalog to the repository workspace or the catalog of another database, and then use these objects in the new database.