Setting large log support preferences for DB2
Prerequisites
To configure Log and Trace Analyzer to use large log support
to load log resources, you need to set the preferences for large log support.
Follow these steps:
- Start Log and Trace Analyzer.
- From the menu, select Window > Preferences.
- In the Preferences window, expand the Profiling and Logging node.
- Select Large Resource Support.
- In the Large Resource Support pane, select the Enable large log support check box to enable the feature.
- Use the Browse button to specify the location of the JDBC driver that will be used.
The following is a list of supported databases and the corresponding JDBC drivers.
Database version |
JDBC driver location |
IBM(R) DB2(R) v8.1 |
Y:\IBM\SQLLIB\java\db2jcc.jar (where Y:\IBM is the location where you installed DB2) |
Where Y: is the drive where the database application is installed.
Once a JDBC driver location is specified, the other fields will be enabled for input.
- Select the database from the Database type list.
- If the Database location field is enabled, specify the database host and port number in the format <hostname>:<port_number>. For example for DB2 use localhost:50000 if you are connecting to your local machine using the DB2 default port 50000. Consult your database's documentation to find out which port it uses.
- If the Username and Password fields are enabled, specify the username and password used to access the database.
- Optional but recommended: click Test Connection to confirm that the preferences are set correctly. You should see a dialog appear saying that the connection was successful.
- Click Apply.
- Click OK.
Once the preferences are configured, all log resources will be loaded using large log support.
Note: For better performance of large log support, use DB2 (version 8.2.2, or later) instead of CloudscapeTM.
Related tasks
Importing a log file
Correlating log files
Configuring large log support
Related references
Guidelines for using large log support
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.