DB2 - Problem description
Problem IC89312 | Status: Closed |
"DB2CKLOG CHECK -M" FAILS WITH DBT7045E IN V10.1, WHEN THE CHECKED DATABASE IS ACTIVE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
"db2cklog CHECK -m" reports the following error, when run against an active database in DB2 V10.1: ________________________________________________________________ ____ _____ D B 2 C K L O G _____ DB2 Check Log File tool I B M The db2cklog tool is a utility can be used to test the integrity of an archive log file and to determine whether or not the log file can be used in the rollforward database command. ________________________________________________________________ ____ ________________________________________________________________ ________________ DBT7045E The db2cklog command failed because the db2cklog utility cannot open the current log file. Log file name: "SQLOGMIR.LFH". The following information is reported in the db2diag.log file: 2012-12-27-15.42.29.986340+060 E68399A1006 LEVEL: Error (OS) PID : 9175208 TID : 1 PROC : db2cklog INSTANCE: xxxxxx NODE : 000 HOSTNAME: yyyyyy EDUID: 1 FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation." DIA8519C A file sharing violation has occurred, filename was "". CALLED : OS, -, open OSERR : ETXTBSY (26) "Cannot open or remove a file containing a running progra m." DATA #1 : Codepath, 8 bytes 4:11:15:16:24:38:39:40 DATA #2 : File name, 12 bytes SQLOGMIR.LFH DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes SQLO_REVISE, SQLO_READWRITE, SQLO_SHAREREAD, SQLO_WRITETHRU DATA #4 : Hex integer, 4 bytes 0x00000180 DATA #5 : signed integer, 4 bytes 100 DATA #6 : Hex integer, 4 bytes 0x00000000 DATA #7 : String, 105 bytes Search for ossError*Analysis probe point after this log entry for further self-diagnosis of this problem. When the database is not active, db2cklog works as expected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 3. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 10.1 Fix Pack 3. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.12.2012 02.10.2013 02.10.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.3 | |
10.1.0.3 |