DB2 - Problembeschreibung
Problem IT08643 | Status: Geschlossen |
DB2UNCOMPRESSLOG REPORTS CORRUPTED LOG FILE ERROR WHEN DECOMPRESSING A LOG FILE WITH MORE THAN 1 COMPRESSED BLOCK | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When trying to decompress a compressed log file with the external tool db2UncompressLog, the tool incorrectly reports that the log file is corrupted. This problem only occurs when the log file has more than 1 compressed block. Each compressed block by default contains 32 pages of uncompressed log data. Although the tool reports that the log file is corrupted, the log file is actually valid. Example Error Scenario 1. You have a compressed log file S0000000.LOG (generated with enabling database configuration parameter LOGARCHCOMPR1/2) 2. You tried to decompress the log file using the db2UncompressLog tool: > db2UncompressLog -s0 DB2 LUW V10.1 -- Uncompress log files Version 1.0 The given log file(s) will be uncompressed to file(s) with the same log file name but with .EXP suffix, if -inplace option is specified, the expanded log file will be renamed to the original log file name. Multiple Files Specified : FALSE Start File Number : 0 End File Number : N/A Replace the original compressed log files: FALSE Quiet mode : FALSE Processing file S0000000.LOG... expanded block size is 131072 Log file S0000000.LOG corrupted offset 0x46cf7ee6 File S0000000.LOG done, 1 compressed blocks. db2UncompressLog exit with return code 3. 3. You run the db2cklog tool on the log file and verified that it is not corrupted. > db2cklog 0 ________________________________________________________________ ____ _____ 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. ________________________________________________________________ ____ ________________________________________________________________ ________________ ======================================================== "db2cklog": Processing log file header of "S0000000.LOG". "db2cklog": Processing log pages of "S0000000.LOG" (total log pages: "1000"). ==> page "1" ... "db2cklog": Finished processing log file "S0000000.LOG". Return code: "0". ======================================================== | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users using db2 log compression. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Updrade to latest fix pack * **************************************************************** | |
Local-Fix: | |
There is no local fix, except move up to V105FP6 to get the fix or to use older versions of db2UncompressLog if the log file is not encrypted. | |
Lösung | |
Problem was first fixed in DB2 UDB Version 10.5 fix pack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.04.2015 22.01.2016 22.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |