The CatalogOptions setting can be set to the better-performing option by specifying this option on an ODBC Connection string (e.g., CATALOGOPTIONS=3). This new option can also be used without changing the application program itself by using the cwbODBCreg utility to update the data source. Here are the steps for using the cwbODBCreg utility to change the CatalogOptions setting:
1. Go to a DOS prompt.
2. Change the directory to the Program FilesIBMClient Access directory.
3. Type cwbodbcreg MYDSNNAME CatalogOptions 3.
Kent Milligan is a DB2 UDB Technology Specialist on IBM's eServer Solutions Enablement team. He spent the first seven years at IBM as a member of the DB2 development team in Rochester. He can be reached at