This article provides steps that are required to allow Ignite 8.3 to monitor DB2 10.5. Due to the removal of some snapshot table functions in DB2 10.5, Ignite cannot currently monitor this DB2 version. Scripts have been created that allow monitoring by recreating those table functions that were removed. the table functions "wrap" other table functions that are still available in 10.5 to retrieve data.
1. Upgrade Ignite to 8.3.407 or higher. Only required if Ignite is not at one of these versions. You can verify the version of Ignite in any of the following ways:
2. Contact support to obtain Hotfix AT83DB2. After receiving the hotfix, continue on to step 3.
3. Patch the Ignite Install. The patch is included as a zip file (ignite_db2_patch.zip) in the patch subdirectory of the hotfix bundle provided. Follow the instructions in the readme.txt (from the hotfix zip) to apply the patch.
4. Create New User and Schema. In each DB2 10.5 instance to be monitored, a new user and schema should be created. If Ignite already has a dedicated user/schema, these can be used. The scripts that grant privileges to this user and create the wrapper functions assume the user and schema names are "ignite". You can update the scripts if this is not the case.
5. Run Scripts on Monitored Instance. Run the following two scripts (from the hotfix zip) against all DB2 10.5 instances to be monitored:
The scripts assume the user and schema names are ignite. If this is not the case, update the scripts prior to execution.
6. Test Permissions. Run the script testscriptsforgrants.txt (from the hotfix zip). If permissions have been configured properly, then all of these SQL statements must return a value without any errors.
This needs a slight change as in 8.3.407 the navigation is different than in 9.0 and above.
7. Configure Ignite for Single Database Monitoring. The wrapper functions created in the previous step only allow for single database monitoring. For this reason, Ignite should be configured, if not already, to monitor only a single database (i.e. not instance-wide).
In Ignite, make the following (7a and 7b) configuration changes via the Advanced Options page:
a. Options link > Administration tab > Advanced Options button (Ignite must be started to access this page).
7a. Configure Single Database Monitoring for Instances Registered in the Future:
a. Check Support Options box.
b. Under the Repository Options section:
1. Edit the DB2_MONITOR_SINGLE_DB_DEFAULT option:
a. Set the option's value to True and save (i.e. update).
7b. Configure Existing Registrations to Monitor Single Database:
a. Go to Monitored Database Instance Options section.
b. For each DB2 10.5 instance:
1. Select the instance from the drop-down list.
2. Edit the DB2_MONITOR_SINGLE_DB option:
a. Set the option's value to 'True' and save (i.e. update).
8. Update EXPLAIN table to Allow for Plan Generation. One Explain table used by Ignite for generating explain plans was updated in DB 10.5. This update prevents Ignite from gathering plans. The following steps will create the EXPLAIN_OBJECT table to enable Ignite to collect plans from DB2 10.5:
Note: The Transaction Log Freespace alert does not work. A custom alert can be created as a workaround.