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
- From the QMF for Windows Administrator main window, check the Enable dynamic definition of ODBC servers check
box.
- Click the Properties button. The Parameters window
opens where you specify the configuration parameters for the model
ODBC server.
- 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.
- 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.
- 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.
- 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.
