Thema:

Kommentar:
: (4) Can there be many ODBC shadow catalogs on MVS, or just one? : With DB2 Connect, you can use an ODBC tools to create shadow system catalogs/directories on DB2 for OS/390 to enhance connection performance. Are you restricted to a single catalog per DB2 subsystem or can you have multiple? : Excerpt from DB2 FAQ by Leon Katsnelson, Toronto The DB2 ODBC Catalog Optimizer Tool solves performance degradation problems by creating alternative catalog tables that are optimized for ODBC access by a particular application. This utility helps database administrators to identify the subset of catalog information that is needed for a particular application, and it creates an ODBC optimized catalog that the application can use. As a result, fewer locks are placed on the base system catalog tables, and catalog query times can be reduced substantially, together with the amount of data returned as a result of such queries. : : The process of creating optimized catalog for use by ODBC, DB2 CLI and JDBC applications is composed of 2 steps: : 1. Create ODBC-optimized catalogs(s) on the host : *Note: This process needs to be repeated for each application that would : benefit from an ODBC-optimized catalog. : 2. Configure each workstation to point to the right ODBC-optimized catalog(s) : 3. Keep the ODBC-optimized catalog(s) current

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: