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 IC90515 Status: Geschlossen

db2diag may give unexpected diagnostic log entry

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Sometimes, db2diag may give unexpected diagnostic log entry. 
For example: 
 
> db2diag -gi level=Error,eduname:="db2logmgr" -H 15m -readfile 
db2diag.log 
 
2012-10-18-06.00.15.263074-300 E6815346A15430     LEVEL: Warning 
PID     : 41418902             TID  : 53461       PROC : db2sysc 
0 
INSTANCE: xxxxx               NODE : 000         DB   : xxxxx 
APPHDL  : 0-29822              APPID: xxxxxxx 
AUTHID  : xxxxx 
EDUID   : xxxx                   EDUNAME: db2agent (xxxx) 0 
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:1 
MESSAGE : ADM5501I  DB2 is performing lock escalation. The 
affected application 
is named "ReportingServicesSer", and is associated with the 
workload 
name "SYSDEFAULTUSERWORKLOAD" and application ID 
"xxxxxxxxxxxxxx"  at member "0". The total 
number of 
locks currently held is "18", and the target number of locks to 
hold 
is "9". The current statement being executed is "WITH 
tempTractor_Details1 AS        (            SELECT 
Row_Number () 
over () AS ID,                    EDW.TRACTOR.PK_TRACTOR_NB, 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG, 
EDW.TRACTOR_HISTORY.TRACTOR_CURRENT_MANAGER_CD, 
EDW.TRACTOR_HISTORY.DRIVER_EMPLOYEE_NB, 
EDW.TRACTOR_HISTORY.TRACTOR_DRIVER2_NB, 
EDW.TRACTOR_HISTORY.TRACTOR_STATUS_CD,                    CASE 
WHEN EDW.TRACTOR.COMPANY_OWNED_UNIT_FG = 'Y' 
THEN 'C-Own'                        ELSE 'O-Op' 
END AS COMPANY_OWNED_UNIT_FG, 
EDW.TRACTOR.MAINTENANCE_EQUIPMENT_CD,                    DATE 
(EDW.TRACTOR_HISTORY.PK_TRACTOR_CHANGE_TS) AS 
PK_Tractor_Change_TS, 
EDW.TRACTOR_HISTORY.TRACTOR_HISTORY_TYPE_CD, 
EDW.TRACTOR.TRACTOR_TYPE_CD, 
EDW.TRACTOR_HISTORY.COST_DIVISION_CD, 
EDW.COST_DIVISION.PARENT_DIVISION_CD, 
EDW.TRACTOR.TRACTOR_MAKE_CD,                    CASE 
WHEN EDW.COST_DIVISION.PARENT_DIVISION_CD IN ('D', 'F', 'T') 
THEN 'Specialized'                        WHEN 
EDW.COST_DIVISION.PARENT_DIVISION_CD IN ('R', 'V') 
THEN 'Operations'                        ELSE 'Unassigned' 
END AS Reporting_VP,                    CASE 
WHEN EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG = '  ' 
THEN 'Blank'                        ELSE 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG                    END AS 
Team_Flag_Filter,                    CASE 
WHEN 
EDW.TRACTOR_HISTORY.TRACTOR_STATUS_CD IN ('IQ', 'TP') 
OR EDW.TRACTOR.MAINTENANCE_EQUIPMENT_CD = 'AA' 
THEN 'INVALID'                        ELSE 
CASE                                WHEN 
EDW.TRACTOR_HISTORY.TRACTOR_CURRENT_MANAGER_CD IN ('ZV', 'ZY', 
'ZW', 
'ZF')                                 OR ( 
EDW.TRACTOR_HISTORY.TRACTOR_CURRENT_MANAGER_CD NOT IN ('DC', 
'ZV', 
'ZY', 'ZW', 'ZF')                                AND 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG IN (' ', 'E', 'F', 'G', 'L', 
'N', 
'P', 'T', 'Z', '1', '2', '3', '4', '5', '6', '7', '8', 'Q', 'O', 
'J', 
'K', 'W', 'D', 'M', 'Y', 'X', 'A', 'B', 'C', 'H', 'I', 'R', 'S', 
'U', 
'V')                                AND 
EDW.TRACTOR_HISTORY.COST_DIVISION_CD = '  ') 
THEN                                    CASE 
WHEN EDW.TRACTOR_HISTORY.DRIVER_EMPLOYEE_NB <> 0 
THEN 'ZV W/DRV'                                        ELSE 'ZV 
No 
Drv'                                    END 
WHEN EDW.TRACTOR_HISTORY.TRACTOR_CURRENT_MANAGER_CD = 'DC' 
THEN                                    CASE 
WHEN EDW.TRACTOR.TRACTOR_TYPE_CD NOT IN ('YRD', 'OTH') 
THEN 'Other'                                        WHEN 
EDW.TRACTOR.TRACTOR_TYPE_CD IN ('YRD') 
THEN 'Other'                                        WHEN 
EDW.TRACTOR.TRACTOR_TYPE_CD IN ('OTH') 
THEN 'Other'                                    END 
ELSE                                    CASE 
WHEN EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG = 'W' 
THEN 'Team Werner'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG IN ('D', 'M', 'Y') 
THEN 'Solo'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG = 'X' 
THEN 'Team'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG = 'A' 
THEN 'Team'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG IN ('B', 'C', 'H') 
THEN 'Trainer'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG IN ('I', 'R', 'S', 'U', '8') 
THEN 'Trainer'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG IN (' ', 'E', 'F', 'G', 'L', 
'N', 
'P', 'T', 'Z', '1', '2', '3', '4', '5', '6', '7', 'Q', 'O', 'J', 
'K') 
AND EDW.TRACTOR_HISTORY.TRACTOR_DRIVER2_NB = 0 
THEN 'Solo'                                        WHEN 
EDW.TRACTOR_HISTORY.TWO_MAN_TEAM_FG IN (' ', 'E', 'F', 'G', 'L', 
'N', 
'P', 'T', 'Z', '1', '2', '3', '4', '5', '6', '7') 
AND EDW.TRACTOR_HISTORY.TRACTOR_DRIVER2_NB <> 0 
THEN 'Team'                                        ELSE 
'UNASSIGNED' 
END                            END                    END AS 
RptCategory,                    1 AS Day_Ct                FROM 
EDW.TRACTOR                    INNER JOIN EDW.TRACTOR_HISTORY 
ON  EDW.TRACTOR.PK_TRACTOR_NB = 
EDW.TRACTOR_HISTORY.PK_TRACTOR_NB 
LEFT JOIN EDW.COST_DIVISION                    ON 
EDW.TRACTOR_HISTORY.COST_DIVISION_CD = 
EDW.COST_DIVISION.PK_COST_DIVISION_CD                WHERE 
EDW.TRACTOR.PK_TRACTOR_NB < 79000                AND 
EDW.TRACTOR_HISTORY.TRACTOR_HISTORY_TYPE_CD = 'S' 
AND 
EDW.TRACTOR_HISTORY.RECORD_DELETE_FG = 'N'                AND 
EDW.TRACTOR_HISTORY.PK_TRACTOR_CHANGE_TS >= '2012-10-11 
00:00:00' 
AND EDW.TRACTOR_HISTORY.PK_TRACTOR_CHANGE_TS <= '2012-10-17 
23:59:59' 
)        ,        Super_Add AS        (            SELECT 
TD.ID, 
TD.TRACTOR_CURRENT_MANAGER_CD, 
FMA.PK_FLEET_MANAGER_CD AS Supervisor                FROM 
tempTractor_Details1 TD                    LEFT JOIN 
EDW.FLEET_TRACTOR_MANAGER_ASSIGNMENT FMA                    ON 
TD.TRACTOR_CURRENT_MANAGER_CD = FMA.PK_TRACTOR_MANAGER_CD 
AND DATE (PK_TRACTOR_CHANGE_TS) BETWEEN 
FMA.FLEET_MANAGER_START_DT 
AND FMA.FLEET_MANAGER_END_DT                WHERE 
TD.TRACTOR_CURRENT_MANAGER_CD <> ''        )        , 
TempTractor_Details AS        (            SELECT     TD.*, 
COALESCE (SA.Supervisor, 'Unk') AS Supervisor 
FROM 
tempTractor_Details1 TD                    LEFT JOIN Super_Add 
SA 
ON  TD.ID = SA.ID        )        ,        Active_1st_Seater AS 
(            SELECT DISTINCT TD.PK_TRACTOR_NB, 
TD.DRIVER_EMPLOYEE_NB,                    ER.stakeholder_nb 
FROM tempTractor_Details TD                    INNER JOIN 
EDW.Employee_Reference ER                    ON 
TD.DRIVER_EMPLOYEE_NB = ER.EMPLOYEE_NB                WHERE 
TD.DRIVER_EMPLOYEE_NB > 100                AND ER.stakeholder_nb 
> 1 
AND TD.PK_TRACTOR_NB > 1000        )        ,        Hires AS 
(            SELECT     STAKEHOLDER_NB, 
SUBSTR 
(EVENT_START_TX, 17, 2) AS Hired_As,                    CASE 
WHEN SUBSTR (EVENT_START_TX, 17, 2) = '80' 
THEN 1                        WHEN SUBSTR (EVENT_START_TX, 17, 
2) = 
'85'                        THEN 2                        WHEN 
SUBSTR 
(EVENT_START_TX, 17, 2) IN ('10', '40', '50') 
THEN 3                        ELSE 4                    END AS 
Hire_Rating,                    DATE (EVENT_START_TS) AS 
Start_Dt 
FROM EDW.Event                WHERE EVENT_STAR 
 
 
The above command is supposed to return nothing, because no 
entry in the specified db2diag.log is matching the filtering 
rules.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 9                        * 
****************************************************************
Local-Fix:
The problem may go away if user waits for some time and let the 
db2diag.log growing bigger
verfügbare FixPacks:
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

Lösung
N/A
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC97795 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.02.2013
19.11.2013
19.11.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList