DB2 graphic  QMF Version 8

Enable dynamic definition of ODBC servers

You must individually configure in the SDF every local ODBC data source that each or your users need to access. This can be a time consuming process. In order to avoid configuring each ODBC data source, you can use the Enable dynamic definition of ODBC servers option to dynamically configure in the SDF, every local ODBC data source for all QMF applications users. To dynamically define ODBC data sources, you first must configure a model ODBC database server in the SDF. When QMF for Windows runs on the local machine using this SDF, it dynamically creates an entry in the SDF for each ODBC data source known to the local machine's ODBC Data Source Manager. Each entry in the SDF uses the model ODBC database server's configuration parameters. The SDF entries for the local ODBC data sources are in effect for the length of the current QMF for Windows session. The next time QMF for Windows starts, the entries for the ODBC data sources in the SDF are rebuilt.

Procedure to dynamically define ODBC data sources

  1. From the QMF for Windows Administrator main window, check the Enable dynamic definition of ODBC servers check box.
  2. Click the Properties button. The Parameters window opens where you specify the configuration parameters for the model ODBC server.
  3. The process of configuration is the same as any other database server with a few exceptions. The Connections, Packages, Sample Tables, and Object Tracking pages of the Parameters window are not available when configuring the model ODBC database server. This is because the type of connectivity is assumed to be ODBC and you cannot create objects, bind packages, create sample tables or access object tracking tables on any ODBC database server.
  4. The name of the ODBC model database server, listed on the General page of the Parameters window, is automatically inserted as Dynamic ODBC Servers. You cannot change this name. When QMF for Windows dynamically configures each local ODBC data source it will use the local data source name as the dynamic entry database server name in the SDF. This ensures that each dynamic entry in the SDF has a unique name. QMF for Windows will not create a dynamic entry in the SDF for local data source names that exceed 64 characters. QMF for Windows will not create a dynamic entry in the SDF for any local data source name that already exists in the SDF. This ensures that any individual ODBC database server's parameters already configured in the SDF will not be overridden.
  5. You must specify whether the model ODBC database server and all the local ODBC data sources that are dynamically defined will use a QMF catalog. You use the Catalog page of the Parameters window to specify whether or not the model ODBC database server will use a QMF catalog.

    If you choose to specify that the model ODBC server will use a QMF catalog, then all of the datasources that are dynamically defined based on that model will use that QMF catalog. ODBC data sources cannot host a QMF catalog so you will have to select a QMF catalog that resides on a database server that hosts DB2 and is connected to using TCP/IP, SNA or CLI connectivity.

    If you choose to specify that the model ODBC server will not use a QMF catalog, then all of the datasources that are dynamically defined based on that model will not use a QMF catalog.

  6. You can optionally choose to set up governing using the Resource Limits and User Profiles page, specify security parameters using the Security page or set up QMF for WebSphere connectivity using the QMF for WebSphere page.


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