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 | |
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 | |
9.7.0.9 |