home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT07996 Status: Geschlossen

DB2PD -ACTIVE CAN SHOW "ENTRYTIME" FOR A STATEMENT TO BE MUCH
SOONER THEN IT SHOULD BE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When using a command like this: 
 
db2pd -db <dbname> -apinfo -active 
 
... it is possible that the "EntryTime" for a statement is shown 
to happen before the "Connection Start Time".    This can cause 
the timing information to be inaccurate. 
 
For example: 
 
Database Partition 0 -- Database SAMPLE -- Active -- Up 221 days 
21:25:24 -- Date 2015-01-05-12.06.56.179853 
 
Application : 
  Address :                0x0780000000FB6E00 
  AppHandl [nod-index] :   9626     [000-09626] 
  TranHdl :                19 
  Application PID :        6619242 
  Application Node Name :  db2inst1 
 
  IP Address:              n/a 
 
  Connection Start Time :  (1420477540)Mon Jan  5 12:05:40 2015 
  Client User ID :         db2admin 
  System Auth ID :         DB2ADMIN 
  Coordinator EDU ID :     15986 
  Coordinator Partition :  0 
  Number of Agents :       1 
  Locks timeout value :    NotSet 
  Locks Escalation :       No 
  Workload ID :            1 
  Workload Occurrence ID : 76220 
  Trusted Context :        n/a 
  Connection Trust Type :  non trusted 
  Role Inherited :         n/a 
  Application Status :     UOW-Executing 
  Application Name :       db2bp 
  Application ID :         *LOCAL.db2inst1.150105170540 
 
  ClientUserID :           n/a 
  ClientWrkstnName :       n/a 
  ClientApplName :         n/a 
  ClientAccntng :          n/a 
 
Database Partition 0 -- Database SAMPLE -- Active -- Up 221 days 
21:25:24 -- Date 2015-01-05-12.06.56.189133 
 
Active Statement List: 
Address            AppHandl [nod-index] UOW-ID     StmtID 
AnchID StmtUID    EffISO      EffLockTOut EffDegree   EntryTime 
StartTime           LastRefTime 
0x070000004B2B44A0 9626     [000-09626] 1          1 
199    785        1           45          0           Mon Jan  5 
12:05:31 Mon Jan  5 12:05:31 Mon Jan  5 12:05:31 
 
 
The EntryTime (and StartTime) are showing 12:05:31, yet the 
connection start time for this application was 9 seconds later 
at 12:05:40.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5, Fix pack 7                      * 
****************************************************************
Local-Fix:
This problem is more likley to happen the longer the DB2 
instance has been up.   Recycling the DB2 instance 
(db2stop/db2start) on a regular basis (example every 30 days) 
would help alleviate this type of problem from occurring.
Lösung
First fixed in DB2 Version 10.5, Fix pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.03.2015
29.01.2016
29.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList