home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC72479 Status: Closed

SNAPSHOT FOR DCS APPLICATION AGENTID SHOW INCORRECT FORMATED ENTRY FOR
TRANSACTION ID (XID)

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
get snapshot for dcs application agentid xxxx 
 
 
 
and gets: 
 
 
 
UOW start timestamp                        = 10/05/2010 
13:06:57.170387 
UOW stop timestamp                         = 10/05/2010 
13:06:58.971606 
Elapsed time of last completed uow (sec.ms)= 1.801219 
 
Host execution elapsed time                = 28.382082 
 
Transaction ID (XID): 
 
47414241364133362E4745374520202020313234323339313536 
 
Statement                                  = Static Commit 
 
Section number                             = 0 
 
 
 
Values are separated by equal signs (=) from their names, except 
 
Transaction ID (XID), where it is a colon (:). This irritates 
scripts 
reading the output of get snapshot for ...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* db2 CLP users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Problem with the separator used while displaying the output  * 
* for transaction ID in snapshot for dcs applications          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97fp5 or later                                   * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem fixed.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.11.2010
02.01.2012
02.01.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList