|
Problem IC93406
|
Status: Geschlossen |
DB2PD -LOGS AND MON_GET_TRANSACTION_LOG() DO NOT RETURN RIGHT LOG CHAIN ID |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
Starting with 10.1 db2pd -log and mon_get_transaction_log()
always return 0 for log chain id instead of returning the right
log chain number.
Example:
$ db2 "select log_chain_id from
table(mon_get_transaction_log(-1))"
LOG_CHAIN_ID
--------------------
0
1 record(s) selected.
$ db2pd -db <dbname> -logs
Database Member 0 -- Database DBNAME -- Active -- Up 0 days
00:05:45 -- Date 2013-06-12-12.09.52.672927
Logs:
Current Log Number 8
Pages Written 60
Cur Commit Disk Log Reads 0
Cur Commit Total Log Reads 0
Method 1 Archive Status n/a
Method 1 Next Log to Archive 8
Method 1 First Failure n/a
Method 2 Archive Status n/a
Method 2 Next Log to Archive n/a
Method 2 First Failure n/a
Log Chain ID 0 <-------
Current LSO 74396511
Current LSN 0x000000000003C5C2 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 2 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 Version 10.5 Fix Pack 2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.06.2013
16.12.2013
16.12.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.2
|
 |
| 10.5.0.3
|
|
| 10.5.0.3
|
|
