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