DB2 - Problem description
Problem IT16257 | Status: Closed |
MISSING INFORMATION IN OUTPUT OF CHANGE HISTORY EVENT MONITOR | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Among other missing information the change history event monitor does not differ between online and snapshot script backups. There is an issue in the change history event monitor processing in that it does not report "snapshot script" phrases: Snapshot backups are reported in the following way by the event monitor: db2 backup db sample online use snapshot script '/home/hotelaix15/jklauke/sqllib/samples/BARVendor/libacssc.sh' options '/home/hotelaix15/jklauke/rep/' db2 "select substr(utility_detail,1,64) from utilstart_evmon" 1 ---------------------------------------------------------------- BACKUP DATABASE SAMPLE ONLINE 1 record(s) selected. When running an ordinary backup without options you get the following result: db2 backup db sample online db2 "select substr(utility_detail,1,64) from utilstart_evmon" 1 ---------------------------------------------------------------- BACKUP DATABASE SAMPLE ONLINE BACKUP DATABASE SAMPLE ONLINE TO ... 2 record(s) selected. The only difference is that there is a "To ..." clause for the ordinary backup. This is not sufficient to differentiate. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.07.2016 29.09.2017 29.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |