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.