Time Diffrence in DB2

Hi
I am attaching the query i need to modify the query at the WHERE clause and get all the data for the last 15 minutes.
There is a column which stores the timestamp in hh:mm:ss format.
I am not finding any ways out to get all the data recorded in the table in the last 15 minutes

Thanks Senz
Select DATE ('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2)) as "Date",
TIME (substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2)) as "Time", 
"SAMPLES", "DBTMZDIFF", "SHIFTPERIOD", "VACATIONPERIOD", "TMZDIFF", 
DATE ('20' || substr("DBWRITETIME",2,2) || '-' ||substr("DBWRITETIME",4,2) || '-' || substr("DBWRITETIME",6,2)) as "DBWRITEDATE",
TIME (substr("DBWRITETIME",8,2) || '.' || substr("DBWRITETIME",10,2) || '.' || substr ("DBWRITETIME",12,2)) as "DBWRITETIME", 
DATE ('20' || substr("WRITETIME",2,2) || '-' ||substr("WRITETIME",4,2) || '-' || substr("WRITETIME",6,2)) as "WRITEDATE",
TIME (substr("WRITETIME",8,2) || '.' || substr("WRITETIME",10,2) || '.' || substr ("WRITETIME",12,2)) as "WRITETIME", 
"LAT_User_Name", "LAT_Operating_System_Type", "LAT_Operating_System_Version", 
"LAT_Network_Address", "LAT_Number_of_Processors", "LAT_Processor_Type", "LAT_Page_Size",
"MIN_%_Total_Privileged_Time", "MAX_%_Total_Privileged_Time", "SUM_%_Total_Privileged_Time",
"AVG_%_Total_Privileged_Time", "MIN_%_Total_Processor_Time", "MAX_%_Total_Processor_Time",
"SUM_%_Total_Processor_Time", "AVG_%_Total_Processor_Time", "MIN_%_Total_User_Time", 
"MAX_%_Total_User_Time", "SUM_%_Total_User_Time", "AVG_%_Total_User_Time", 
"MIN_Context_Switches/Sec", "MAX_Context_Switches/Sec", "SUM_Context_Switches/Sec",
"AVG_Context_Switches/Sec", "MIN_File_Control_Bytes/Sec", "MAX_File_Control_Bytes/Sec", 
"SUM_File_Control_Bytes/Sec", "AVG_File_Control_Bytes/Sec", "MIN_FLECTLOP", "MAX_FLECTLOP",
"SUM_FLECTLOP", "AVG_FLECTLOP", "MIN_File_Data_Operations/Sec", "MAX_File_Data_Operations/Sec",
"SUM_File_Data_Operations/Sec", "AVG_File_Data_Operations/Sec", "MIN_File_Read_Bytes/Sec",
"MAX_File_Read_Bytes/Sec", "SUM_File_Read_Bytes/Sec", "AVG_File_Read_Bytes/Sec", 
"MIN_File_Read_Operations/Sec", "MAX_File_Read_Operations/Sec", "SUM_File_Read_Operations/Sec", 
"AVG_File_Read_Operations/Sec", "MIN_File_Write_Bytes/Sec", "MAX_File_Write_Bytes/Sec",
"SUM_File_Write_Bytes/Sec", "AVG_File_Write_Bytes/Sec", "MIN_File_Write_Operations/Sec",
"MAX_File_Write_Operations/Sec", "SUM_File_Write_Operations/Sec", "AVG_File_Write_Operations/Sec",
"MIN_Processor_Queue_Length", "MAX_Processor_Queue_Length", "SUM_Processor_Queue_Length",
"AVG_Processor_Queue_Length", "MIN_System_Calls/Sec", "MAX_System_Calls/Sec", 
"SUM_System_Calls/Sec", "AVG_System_Calls/Sec", "TOT_System_Up_Time", "HI_System_Up_Time",
"LOW_System_Up_Time", "LAT_System_Up_Time", "MIN_Total_Interrupts/Sec", "MAX_Total_Interrupts/Sec",
"SUM_Total_Interrupts/Sec", "AVG_Total_Interrupts/Sec", "MIN_Alignment_Fixups/sec", 
"MAX_Alignment_Fixups/sec", "SUM_Alignment_Fixups/sec", "AVG_Alignment_Fixups/sec",
"MIN_Exception_Dispatches/sec", "MAX_Exception_Dispatches/sec", "SUM_Exception_Dispatches/sec",
"AVG_Exception_Dispatches/sec", "MIN_Floating_Emulations/sec", "MAX_Floating_Emulations/sec",
"SUM_Floating_Emulations/sec", "AVG_Floating_Emulations/sec", "LAT_User_Name_U", 
"TOT_System_Up_Days", "HI_System_Up_Days", "LOW_System_Up_Days", "LAT_System_Up_Days",
"LAT_Total_Memory_Size", "MIN_Page_File_Size", "MAX_Page_File_Size", "SUM_Page_File_Size",
"AVG_Page_File_Size", "MIN_PRCQEX", "MAX_PRCQEX", "SUM_PRCQEX", "AVG_PRCQEX", 
"LAT_Network_Address_IPv6", "MIN_File_Control_Bytes/Sec_64", "MAX_File_Control_Bytes/Sec_64",
"SUM_File_Control_Bytes/Sec_64", "AVG_File_Control_Bytes/Sec_64", "MIN_File_Read_Bytes/Sec_64",
"MAX_File_Read_Bytes/Sec_64", "SUM_File_Read_Bytes/Sec_64", "AVG_File_Read_Bytes/Sec_64",
"MIN_File_Write_Bytes/Sec_64", "MAX_File_Write_Bytes/Sec_64", "SUM_File_Write_Bytes/Sec_64",
"AVG_File_Write_Bytes/Sec_64", "TOT_System_Up_Time_64", "HI_System_Up_Time_64", 
"LOW_System_Up_Time_64", "LAT_System_Up_Time_64", "Server_Name" 
From "NT_System_H"  
Where DATE ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) Between '2010-01-01' and '2010-01-02' 
Order By "Server_Name"

Open in new window

LVL 4
Senz79Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

momi_sabagCommented:
i did not go through all your sql because it is rather long,
but how about something like

from "NT_System_H"  where DATE ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) > current timestamp - 15 minutes
0
LowfatspreadCommented:
what is the data type of the timestamp column?

which version and db2 envurinment?
0
Senz79Author Commented:
Hi Momi
i get the below error

Error: SQL0401N The data types of the operands for the operation ">" are not compatible. SQLSTATE=42818
(State:42818, Native Code: FFFFFE6F)
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

momi_sabagCommented:
so try


from "NT_System_H"  where timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) > current timestamp - 15 minutes
0
Senz79Author Commented:
It worked but no data displayed as there is no data for last 15 minutes. can i some how change it to 15 minutes data from the last recorded time in the database. I have attached the date time snapshot
2010-03-10	02:45:30
2010-03-10	03:45:32
2010-03-10	04:45:31
2010-03-10	05:45:31
2010-03-10	06:45:30
2010-03-10	07:45:30
2010-03-10	08:45:30
2010-03-10	09:45:30
2010-03-10	10:45:30
2010-03-10	11:45:31
2010-03-10	12:45:32
2010-03-10	13:45:30
2010-03-10	14:45:31
2010-03-10	15:45:31
2010-03-10	16:45:31
2010-03-10	17:45:30
2010-03-10	18:45:30
2010-03-10	19:45:30
2010-03-10	20:45:30
2010-03-10	03:45:59
2010-03-10	04:46:01
2010-03-10	05:46:00
2010-03-10	06:46:02
2010-03-10	07:46:01
2010-03-10	08:46:00
2010-03-10	09:46:23

Open in new window

0
momi_sabagCommented:
try

from "NT_System_H"  where timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) > (select max timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) - 15 minutes from "NT_System_H" )
0
Senz79Author Commented:

Error: SQL0104N An unexpected token "(" was found following "select max timestamp". Expected tokens may include: ",". SQLSTATE=42601
(State:42601, Native Code: FFFFFF98)
Select DATE ('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2)) as "Date",TIME (substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2)) as "Time", "SAMPLES","DBTMZDIFF","SHIFTPERIOD","VACATIONPERIOD","TMZDIFF",
DATE ('20' || substr("DBWRITETIME",2,2) || '-' ||substr("DBWRITETIME",4,2) || '-' || substr("DBWRITETIME",6,2)) as "DBWRITEDATE",
TIME (substr("DBWRITETIME",8,2) || '.' || substr("DBWRITETIME",10,2) || '.' || substr ("DBWRITETIME",12,2)) as "DBWRITETIME",
DATE ('20' || substr("WRITETIME",2,2) || '-' ||substr("WRITETIME",4,2) || '-' || substr("WRITETIME",6,2)) as "WRITEDATE",
TIME (substr("WRITETIME",8,2) || '.' || substr("WRITETIME",10,2) || '.' || substr ("WRITETIME",12,2)) as "WRITETIME", "LAT_User_Name","LAT_Operating_System_Type","LAT_Operating_System_Version","LAT_Network_Address","LAT_Number_of_Processors","LAT_Processor_Type","LAT_Page_Size","MIN_%_Total_Privileged_Time",
"MAX_%_Total_Privileged_Time","SUM_%_Total_Privileged_Time","AVG_%_Total_Privileged_Time","MIN_%_Total_Processor_Time","MAX_%_Total_Processor_Time","SUM_%_Total_Processor_Time","AVG_%_Total_Processor_Time","MIN_%_Total_User_Time","MAX_%_Total_User_Time","SUM_%_Total_User_Time","AVG_%_Total_User_Time","MIN_Context_Switches/Sec","MAX_Context_Switches/Sec",
"SUM_Context_Switches/Sec","AVG_Context_Switches/Sec","MIN_File_Control_Bytes/Sec","MAX_File_Control_Bytes/Sec","SUM_File_Control_Bytes/Sec","AVG_File_Control_Bytes/Sec","MIN_FLECTLOP","MAX_FLECTLOP","SUM_FLECTLOP","AVG_FLECTLOP","MIN_File_Data_Operations/Sec","MAX_File_Data_Operations/Sec","SUM_File_Data_Operations/Sec","AVG_File_Data_Operations/Sec","MIN_File_Read_Bytes/Sec","MAX_File_Read_Bytes/Sec","SUM_File_Read_Bytes/Sec","AVG_File_Read_Bytes/Sec",
"MIN_File_Read_Operations/Sec","MAX_File_Read_Operations/Sec","SUM_File_Read_Operations/Sec","AVG_File_Read_Operations/Sec","MIN_File_Write_Bytes/Sec","MAX_File_Write_Bytes/Sec","SUM_File_Write_Bytes/Sec","AVG_File_Write_Bytes/Sec","MIN_File_Write_Operations/Sec","MAX_File_Write_Operations/Sec","SUM_File_Write_Operations/Sec","AVG_File_Write_Operations/Sec","MIN_Processor_Queue_Length","MAX_Processor_Queue_Length","SUM_Processor_Queue_Length","AVG_Processor_Queue_Length","MIN_System_Calls/Sec","MAX_System_Calls/Sec","SUM_System_Calls/Sec","AVG_System_Calls/Sec","TOT_System_Up_Time","HI_System_Up_Time","LOW_System_Up_Time","LAT_System_Up_Time","MIN_Total_Interrupts/Sec","MAX_Total_Interrupts/Sec","SUM_Total_Interrupts/Sec","AVG_Total_Interrupts/Sec","MIN_Alignment_Fixups/sec","MAX_Alignment_Fixups/sec","SUM_Alignment_Fixups/sec","AVG_Alignment_Fixups/sec","MIN_Exception_Dispatches/sec","MAX_Exception_Dispatches/sec","SUM_Exception_Dispatches/sec","AVG_Exception_Dispatches/sec","MIN_Floating_Emulations/sec","MAX_Floating_Emulations/sec","SUM_Floating_Emulations/sec","AVG_Floating_Emulations/sec","LAT_User_Name_U","TOT_System_Up_Days","HI_System_Up_Days","LOW_System_Up_Days","LAT_System_Up_Days","LAT_Total_Memory_Size","MIN_Page_File_Size","MAX_Page_File_Size","SUM_Page_File_Size","AVG_Page_File_Size","MIN_PRCQEX","MAX_PRCQEX","SUM_PRCQEX","AVG_PRCQEX","LAT_Network_Address_IPv6","MIN_File_Control_Bytes/Sec_64","MAX_File_Control_Bytes/Sec_64","SUM_File_Control_Bytes/Sec_64","AVG_File_Control_Bytes/Sec_64","MIN_File_Read_Bytes/Sec_64","MAX_File_Read_Bytes/Sec_64","SUM_File_Read_Bytes/Sec_64","AVG_File_Read_Bytes/Sec_64","MIN_File_Write_Bytes/Sec_64","MAX_File_Write_Bytes/Sec_64","SUM_File_Write_Bytes/Sec_64","AVG_File_Write_Bytes/Sec_64","TOT_System_Up_Time_64","HI_System_Up_Time_64","LOW_System_Up_Time_64","LAT_System_Up_Time_64","Server_Name"
from "NT_System_H"  where timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) > (select max timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) - 15 minutes from "NT_System_H" )

Open in new window

0
Senz79Author Commented:
i Changed it to
where timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2)) > (select max(timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2))) - 15 minutes from "NT_System_H" )
 
but still no result
0
momi_sabagCommented:
what returns when you run

select max(timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2))) - 15 minutes from "NT_System_H"

 ?
0
LowfatspreadCommented:
what is the data type of the timestamp column?
which version/environment of db2 are you using?

can you show what
select timestamp ('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2))
from "NT_System_H"
fetch first 10 rows only

returns?

i am suspicous that ("timestamp",2,2)  isnt actually the correct starting location
0
Senz79Author Commented:
Its returning 0 rows
0
LowfatspreadCommented:
what error message does it return then?

what does
select * from  "NT_System_H"
fetch first 10 rows only

return
0
Senz79Author Commented:
.
SAMPLES	DBTMZDIFF	DBWRITETIME	SHIFTPERIOD	VACATIONPERIOD	TMZDIFF	WRITETIME	Server_Name	Timestamp	LAT_User_Name	LAT_Operating_System_Type	LAT_Operating_System_Version	LAT_Network_Address	LAT_Number_of_Processors	LAT_Processor_Type	LAT_Page_Size	MIN_%_Total_Privileged_Time	MAX_%_Total_Privileged_Time	SUM_%_Total_Privileged_Time	AVG_%_Total_Privileged_Time	MIN_%_Total_Processor_Time	MAX_%_Total_Processor_Time	SUM_%_Total_Processor_Time	AVG_%_Total_Processor_Time	MIN_%_Total_User_Time	MAX_%_Total_User_Time	SUM_%_Total_User_Time	AVG_%_Total_User_Time	MIN_Context_Switches/Sec	MAX_Context_Switches/Sec	SUM_Context_Switches/Sec	AVG_Context_Switches/Sec	MIN_File_Control_Bytes/Sec	MAX_File_Control_Bytes/Sec	SUM_File_Control_Bytes/Sec	AVG_File_Control_Bytes/Sec	MIN_FLECTLOP	MAX_FLECTLOP	SUM_FLECTLOP	AVG_FLECTLOP	MIN_File_Data_Operations/Sec	MAX_File_Data_Operations/Sec	SUM_File_Data_Operations/Sec	AVG_File_Data_Operations/Sec	MIN_File_Read_Bytes/Sec	MAX_File_Read_Bytes/Sec	SUM_File_Read_Bytes/Sec	AVG_File_Read_Bytes/Sec	MIN_File_Read_Operations/Sec	MAX_File_Read_Operations/Sec	SUM_File_Read_Operations/Sec	AVG_File_Read_Operations/Sec	MIN_File_Write_Bytes/Sec	MAX_File_Write_Bytes/Sec	SUM_File_Write_Bytes/Sec	AVG_File_Write_Bytes/Sec	MIN_File_Write_Operations/Sec	MAX_File_Write_Operations/Sec	SUM_File_Write_Operations/Sec	AVG_File_Write_Operations/Sec	MIN_Processor_Queue_Length	MAX_Processor_Queue_Length	SUM_Processor_Queue_Length	AVG_Processor_Queue_Length	MIN_System_Calls/Sec	MAX_System_Calls/Sec	SUM_System_Calls/Sec	AVG_System_Calls/Sec	TOT_System_Up_Time	HI_System_Up_Time	LOW_System_Up_Time	LAT_System_Up_Time	MIN_Total_Interrupts/Sec	MAX_Total_Interrupts/Sec	SUM_Total_Interrupts/Sec	AVG_Total_Interrupts/Sec	MIN_Alignment_Fixups/sec	MAX_Alignment_Fixups/sec	SUM_Alignment_Fixups/sec	AVG_Alignment_Fixups/sec	MIN_Exception_Dispatches/sec	MAX_Exception_Dispatches/sec	SUM_Exception_Dispatches/sec	AVG_Exception_Dispatches/sec	MIN_Floating_Emulations/sec	MAX_Floating_Emulations/sec	SUM_Floating_Emulations/sec	AVG_Floating_Emulations/sec	LAT_User_Name_U	TOT_System_Up_Days	HI_System_Up_Days	LOW_System_Up_Days	LAT_System_Up_Days	LAT_Total_Memory_Size	MIN_Page_File_Size	MAX_Page_File_Size	SUM_Page_File_Size	AVG_Page_File_Size	MIN_PRCQEX	MAX_PRCQEX	SUM_PRCQEX	AVG_PRCQEX	LAT_Network_Address_IPv6	MIN_File_Control_Bytes/Sec_64	MAX_File_Control_Bytes/Sec_64	SUM_File_Control_Bytes/Sec_64	AVG_File_Control_Bytes/Sec_64	MIN_File_Read_Bytes/Sec_64	MAX_File_Read_Bytes/Sec_64	SUM_File_Read_Bytes/Sec_64	AVG_File_Read_Bytes/Sec_64	MIN_File_Write_Bytes/Sec_64	MAX_File_Write_Bytes/Sec_64	SUM_File_Write_Bytes/Sec_64	AVG_File_Write_Bytes/Sec_64	TOT_System_Up_Time_64	HI_System_Up_Time_64	LOW_System_Up_Time_64	LAT_System_Up_Time_64
4	0	1100310152249531	-1	-1	-36000	1100310020000000	Primary:XXX.XXXQCSS1:NT	1100310024530691	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	0	0.00	0.00	0	1	1.00	0.25	0	0	0.00	0.00	296	2046	3086.00	771.50	1728	37540	50851.00	12712.75	61	227	485.00	121.25	3	31	45.00	11.25	85	33772	34200.00	8550.00	1	10	16.00	4.00	85	22066	23356.00	5839.00	1	20	27.00	6.75	0	0	0.00	0.00	598	3719	6013.00	1503.25	2699	901	899	272380	1107	1127	4454.00	1113.50	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	543	2162.00	540.50	0	0	0.00	0.00	NO_DNS_ENTRY	1728	37540	50851.00	12712.75	85	33772	34200.00	8550.00	85	22066	23356.00	5839.00	2699	901	899	272380 4	0	1100310152250800	-1	-1	-36000	1100310030000000	Primary:XXX.XXXQCSS1:NT	1100310034532527	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	1	1.00	0.25	0	2	2.00	0.50	0	1	1.00	0.25	293	1639	2662.00	665.50	1715	7871	17340.00	4335.00	60	174	426.00	106.50	3	31	50.00	12.50	85	46227	78576.00	19644.00	1	12	24.00	6.00	85	21466	22497.00	5624.25	0	21	23.00	5.75	0	0	0.00	0.00	595	6560	9407.00	2351.75	3602	902	898	275982	1107	1125	4468.00	1117.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	539	2153.00	538.25	0	0	0.00	0.00	NO_DNS_ENTRY	1715	7871	17340.00	4335.00	85	46227	78576.00	19644.00	85	21466	22497.00	5624.25	3602	902	898	275982 4	0	1100310152250801	-1	-1	-36000	1100310040000000	Primary:XXX.XXXQCSS1:NT	1100310044531847	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	1	1.00	0.25	0	2	3.00	0.75	0	1	1.00	0.25	291	1614	2931.00	732.75	1721	8542	22661.00	5665.25	61	218	580.00	145.00	1	35	54.00	13.50	0	94486	133654.00	33413.50	0	14	27.00	6.75	42	20904	47177.00	11794.25	0	21	26.00	6.50	0	0	0.00	0.00	602	6412	11623.00	2905.75	3599	901	898	279581	1112	1123	4475.00	1118.75	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	537	539	2152.00	538.00	0	0	0.00	0.00	NO_DNS_ENTRY	1721	8542	22661.00	5665.25	0	94486	133654.00	33413.50	42	20904	47177.00	11794.25	3599	901	898	279581 4	0	1100310152250802	-1	-1	-36000	1100310050000000	Primary:XXX.XXXQCSS1:NT	1100310054531245	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	300	430	1478.00	369.50	1734	7015	20046.00	5011.50	63	179	443.00	110.75	0	7	13.00	3.25	0	13488	13658.00	3414.50	0	5	7.00	1.75	85	861	1851.00	462.75	0	2	4.00	1.00	0	0	0.00	0.00	617	1797	4567.00	1141.75	3599	902	898	283180	1107	1125	4458.00	1114.50	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	546	2167.00	541.75	0	0	0.00	0.00	NO_DNS_ENTRY	1734	7015	20046.00	5011.50	0	13488	13658.00	3414.50	85	861	1851.00	462.75	3599	902	898	283180 4	0	1100310152250803	-1	-1	-36000	1100310060000000	Primary:XXX.XXXQCSS1:NT	1100310064530627	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	2	2.00	0.50	0	2	3.00	0.75	0	0	0.00	0.00	314	638	1756.00	439.00	1724	16727	30862.00	7715.50	63	237	586.00	146.50	3	173	198.00	49.50	85	94444	125806.00	31451.50	1	101	117.00	29.25	85	36996	72815.00	18203.75	1	72	78.00	19.50	0	0	0.00	0.00	609	3502	6663.00	1665.75	3600	901	899	286780	1118	1229	4603.00	1150.75	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	541	544	2170.00	542.50	0	0	0.00	0.00	NO_DNS_ENTRY	1724	16727	30862.00	7715.50	85	94444	125806.00	31451.50	85	36996	72815.00	18203.75	3600	901	899	286780 4	0	1100310152250804	-1	-1	-36000	1100310070000000	Primary:XXX.XXXQCSS1:NT	1100310074530437	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	1	1.00	0.25	0	2	2.00	0.50	0	0	0.00	0.00	327	986	2170.00	542.50	1964	11636	23009.00	5752.25	63	263	573.00	143.25	3	23	34.00	8.50	85	26090	29702.00	7425.50	1	11	16.00	4.00	85	8309	8666.00	2166.50	1	12	16.00	4.00	0	0	0.00	0.00	674	4601	11485.00	2871.25	3599	901	899	290379	1107	1124	4449.00	1112.25	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	542	2161.00	540.25	0	0	0.00	0.00	NO_DNS_ENTRY	1964	11636	23009.00	5752.25	85	26090	29702.00	7425.50	85	8309	8666.00	2166.50	3599	901	899	290379 4	0	1100310152250805	-1	-1	-36000	1100310080000000	Primary:XXX.XXXQCSS1:NT	1100310084530442	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	2	4.00	1.00	1	2	6.00	1.50	0	0	0.00	0.00	406	650	2025.00	506.25	2135	12794	26701.00	6675.25	63	282	631.00	157.75	17	50	110.00	27.50	470464	650788	2377639.00	594409.75	16	28	85.00	21.25	85	20732	21405.00	5351.25	1	21	24.00	6.00	0	0	0.00	0.00	662	2511	5570.00	1392.50	3600	902	898	293979	1362	1482	5718.00	1429.50	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	519	535	2096.00	524.00	0	0	0.00	0.00	NO_DNS_ENTRY	2135	12794	26701.00	6675.25	470464	650788	2377639.00	594409.75	85	20732	21405.00	5351.25	3600	902	898	293979 4	0	1100310152250806	-1	-1	-36000	1100310090000000	Primary:XXX.XXXQCSS1:NT	1100310094530825	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	10	11.00	2.75	1	12	16.00	4.00	0	1	1.00	0.25	438	696	2252.00	563.00	2413	608576	1047394.00	261848.50	71	283	725.00	181.25	7	40	87.00	21.75	144	533830	1321598.00	330399.50	1	19	56.00	14.00	187	20988	32993.00	8248.25	2	21	30.00	7.50	0	0	0.00	0.00	975	2507	6673.00	1668.25	3601	902	898	297580	1292	1757	5904.00	1476.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	519	526	2094.00	523.50	0	0	0.00	0.00	NO_DNS_ENTRY	2413	608576	1047394.00	261848.50	144	533830	1321598.00	330399.50	187	20988	32993.00	8248.25	3601	902	898	297580 4	0	1100310152250807	-1	-1	-36000	1100310100000000	Primary:XXX.XXXQCSS1:NT	1100310104530379	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	1	22	27.00	6.75	2	24	31.00	7.75	0	1	1.00	0.25	501	11640	13704.00	3426.00	6674	13864543	13903899.00	3475974.75	173	425	1083.00	270.75	17	580	1091.00	272.75	149339	1663325	2354149.00	588537.25	11	394	432.00	108.00	10762	4556253	4846674.00	1211668.50	5	565	656.00	164.00	0	1	1.00	0.25	1874	36375	43805.00	10951.25	3599	901	899	301179	1276	4349	8276.00	2069.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	527	545	2156.00	539.00	0	0	0.00	0.00	NO_DNS_ENTRY	6674	13864543	13903899.00	3475974.75	149339	1663325	2354149.00	588537.25	10762	4556253	4846674.00	1211668.50	3599	901	899	301179 4	0	1100310152250808	-1	-1	-36000	1100310110000000	Primary:XXX.XXXQCSS1:NT	1100310114531293

Open in new window

0
momi_sabagCommented:
it look like the timestamp column has some special format
can you provide details about it?
for example,
what is
1100310094530825      
0
Senz79Author Commented:
yes
This is in integer format and the time and date has been extracted as
Select DATE ('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2)) as "Date",TIME (substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2)) as "Time"
from "NT_System_H"
Timestamp
1100310024530691
1100310034532527
1100310044531847
1100310054531245
1100310064530627
1100310074530437
1100310084530442
1100310094530825
1100310104530379
1100310114531293

Date	Time
2010-03-10	02:45:30        
2010-03-10	03:45:32
2010-03-10	04:45:31
2010-03-10	05:45:31
2010-03-10	06:45:30
2010-03-10	07:45:30
2010-03-10	08:45:30
2010-03-10	09:45:30
2010-03-10	10:45:30
2010-03-10	11:45:31

Open in new window

0
LowfatspreadCommented:
TRY THIS AS THE WHERE CLAUSE...

where "timestamp" >= (SELECT   '1'||rePLACE(REPLACE(REPLACE(REPLACE(SUBSTR(CHAR(X),2,21),':'.''),'-',''),'.',''),' ','') FROM
 (select
timestamp('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2) || ' '||substr("Timestamp",8,2) || ':'|| substr("Timestamp",10,2)|| ':'|| substr("Timestamp",12,2)|| '.000000') - 15 minutes AS X
 FROM
(select max("timestamp") as "TIMESTAMP" from "NT_System_H") AS X ) AS Y)


IF IT DOESN'T WORK

show me what this produces
 SELECT   '1'||rePLACE(REPLACE(REPLACE(REPLACE(SUBSTR(CHAR(X),2,21),':'.''),'-',''),'.',''),' ','') FROM
 (select
timestamp('20' || substr("Timestamp",2,2) || '-' || substr("Timestamp",4,2) || '-'|| substr("Timestamp",6,2) || ' '||substr("Timestamp",8,2) || ':'|| substr("Timestamp",10,2)|| ':'|| substr("Timestamp",12,2)|| '.000000') - 15 minutes AS X
 FROM
(select max("timestamp") as "TIMESTAMP" from "NT_System_H") AS X ) AS y
 
0
Senz79Author Commented:
hi

Error: SQL0206N "timestamp" is not valid in the context where it is used. SQLSTATE=42703
(State:S0022, Native Code: FFFFFF32)
0
momi_sabagCommented:
ok,
so what is the result of

Select max(timestamp ('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2) || ' ' || substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2))) as "Timestamp"

from "NT_System_H"
0
Senz79Author Commented:
Hi Momi
No result 0 rows returned
0
momi_sabagCommented:
that can't be
your table is not empty
0
Senz79Author Commented:
no but i get 0 rows for that ... i am very sure
 
Select "Timestamp"
from "NT_System_H"
fetch first 10 rows only
Timestamp
1100310024530691
1100310034532527
1100310044531847
1100310054531245
1100310064530627
1100310074530437
1100310084530442
1100310094530825
1100310104530379
1100310114531293
0
Senz79Author Commented:
But Momi
i run the below query and get result
Select TIME (substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2)) as "Time"
from "NT_System_H"
fetch first 10 rows only
Time
02:45:30
03:45:32
04:45:31
05:45:31
06:45:30
07:45:30
08:45:30
09:45:30
10:45:30
11:45:31
0
LowfatspreadCommented:
ok try this

if this produces a valid result --- please show it
select xd - case when xt - 15 minutes < xt then 1 else 0 end days as xd
      ,xt - 15 minutes as xt  
  from (
select TIME(substr("xtim",8,2) || '.' || substr("xtim",10,2) || '.' || substr ("xtim",12,2)) as xt
      ,DATE ('20' || substr("xtim",2,2) || '-' ||substr("xtim",4,2) || '-' || substr("xtim",6,2)) as xd
from (select max(timestamp) as xtim from nt_system_h) as x
) as Y


then do
your
 
select  ......
with this as the from clause without a where clause
from from nt_system_h
Inner Join (select xd - case when xt - 15 minutes < xt then 1 else 0 end days as xd
      ,xt - 15 minutes as xt  
  from (
select TIME(substr("xtim",8,2) || '.' || substr("xtim",10,2) || '.' || substr ("xtim",12,2)) as xt
      ,DATE ('20' || substr("xtim",2,2) || '-' ||substr("xtim",4,2) || '-' || substr("xtim",6,2)) as xd
from (select max(timestamp) as xtim from nt_system_h) as x
) as Y
) as z
on  z.xd <= DATE('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2))
and z.xt <= TIME(substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2))
0
Senz79Author Commented:

Error: SQL0206N "TIMESTAMP" is not valid in the context where it is used. SQLSTATE=42703
(State:S0022, Native Code: FFFFFF32)
0
LowfatspreadCommented:
ok try this

if this produces a valid result --- please show it
select xd - case when xt - 15 minutes < xt then 1 else 0 end days as xd
      ,xt - 15 minutes as xt  
  from (
select TIME(substr("xtim",8,2) || '.' || substr("xtim",10,2) || '.' || substr ("xtim",12,2)) as xt
      ,DATE ('20' || substr("xtim",2,2) || '-' ||substr("xtim",4,2) || '-' || substr("xtim",6,2)) as xd
from (select max("timestamp") as xtim from nt_system_h) as x
) as Y


then do
your
 
select  ......
with this as the from clause without a where clause
from from nt_system_h
Inner Join (select xd - case when xt - 15 minutes < xt then 1 else 0 end days as xd
      ,xt - 15 minutes as xt  
  from (
select TIME(substr("xtim",8,2) || '.' || substr("xtim",10,2) || '.' || substr ("xtim",12,2)) as xt
      ,DATE ('20' || substr("xtim",2,2) || '-' ||substr("xtim",4,2) || '-' || substr("xtim",6,2)) as xd
from (select max("timestamp") as xtim from nt_system_h) as x
) as Y
) as z
on  z.xd <= DATE('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2))
and z.xt <= TIME(substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2))
0
Senz79Author Commented:

Error: SQL0206N "timestamp" is not valid in the context where it is used. SQLSTATE=42703
(State:S0022, Native Code: FFFFFF32)
0
momi_sabagCommented:
what is the result of

Select max(timestamp ('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2) || '-' || substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2))) as "Timestamp"

from "NT_System_H"

or

Select max(timestamp ('20' || substr("Timestamp",2,2) || '-' ||substr("Timestamp",4,2) || '-' || substr("Timestamp",6,2) || '.' || substr("Timestamp",8,2) || '.' || substr("Timestamp",10,2) || '.' || substr ("Timestamp",12,2))) as "Timestamp"

from "NT_System_H"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Senz79Author Commented:
The first query taking long time to execute i  hope its going to some infinite .... and the second query returne zero result
0
momi_sabagCommented:
did you get the result of the first query ?
0
Senz79Author Commented:
No i waited for 15 minutes but still the processing was on
0
momi_sabagCommented:
so how do you want us to solve this issue?
0
Senz79Author Commented:
I hope its a deadlock now , i will withdraw the question.
Thanks for all the help, it was precious.
0
Senz79Author Commented:
not solved but approach we good
0
Senz79Author Commented:
Kindly delete the data in the question on priority.Due to some security issue
0
Senz79Author Commented:
kindly replace the contents of the ID:30317061 with the below code
4	0	1100310152249531	-1	-1	-36000	1100310020000000	Primary:XXX.XXXQCSS1:NT	1100310024530691	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	0	0.00	0.00	0	1	1.00	0.25	0	0	0.00	0.00	296	2046	3086.00	771.50	1728	37540	50851.00	12712.75	61	227	485.00	121.25	3	31	45.00	11.25	85	33772	34200.00	8550.00	1	10	16.00	4.00	85	22066	23356.00	5839.00	1	20	27.00	6.75	0	0	0.00	0.00	598	3719	6013.00	1503.25	2699	901	899	272380	1107	1127	4454.00	1113.50	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	543	2162.00	540.50	0	0	0.00	0.00	NO_DNS_ENTRY	1728	37540	50851.00	12712.75	85	33772	34200.00	8550.00	85	22066	23356.00	5839.00	2699	901	899	272380
4	0	1100310152250800	-1	-1	-36000	1100310030000000	Primary:XXX.XXXQCSS1:NT	1100310034532527	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	1	1.00	0.25	0	2	2.00	0.50	0	1	1.00	0.25	293	1639	2662.00	665.50	1715	7871	17340.00	4335.00	60	174	426.00	106.50	3	31	50.00	12.50	85	46227	78576.00	19644.00	1	12	24.00	6.00	85	21466	22497.00	5624.25	0	21	23.00	5.75	0	0	0.00	0.00	595	6560	9407.00	2351.75	3602	902	898	275982	1107	1125	4468.00	1117.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	539	2153.00	538.25	0	0	0.00	0.00	NO_DNS_ENTRY	1715	7871	17340.00	4335.00	85	46227	78576.00	19644.00	85	21466	22497.00	5624.25	3602	902	898	275982
4	0	1100310152250801	-1	-1	-36000	1100310040000000	Primary:XXX.XXXQCSS1:NT	1100310044531847	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	1	1.00	0.25	0	2	3.00	0.75	0	1	1.00	0.25	291	1614	2931.00	732.75	1721	8542	22661.00	5665.25	61	218	580.00	145.00	1	35	54.00	13.50	0	94486	133654.00	33413.50	0	14	27.00	6.75	42	20904	47177.00	11794.25	0	21	26.00	6.50	0	0	0.00	0.00	602	6412	11623.00	2905.75	3599	901	898	279581	1112	1123	4475.00	1118.75	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	537	539	2152.00	538.00	0	0	0.00	0.00	NO_DNS_ENTRY	1721	8542	22661.00	5665.25	0	94486	133654.00	33413.50	42	20904	47177.00	11794.25	3599	901	898	279581
4	0	1100310152250802	-1	-1	-36000	1100310050000000	Primary:XXX.XXXQCSS1:NT	1100310054531245	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	300	430	1478.00	369.50	1734	7015	20046.00	5011.50	63	179	443.00	110.75	0	7	13.00	3.25	0	13488	13658.00	3414.50	0	5	7.00	1.75	85	861	1851.00	462.75	0	2	4.00	1.00	0	0	0.00	0.00	617	1797	4567.00	1141.75	3599	902	898	283180	1107	1125	4458.00	1114.50	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	546	2167.00	541.75	0	0	0.00	0.00	NO_DNS_ENTRY	1734	7015	20046.00	5011.50	0	13488	13658.00	3414.50	85	861	1851.00	462.75	3599	902	898	283180
4	0	1100310152250803	-1	-1	-36000	1100310060000000	Primary:XXX.XXXQCSS1:NT	1100310064530627	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	2	2.00	0.50	0	2	3.00	0.75	0	0	0.00	0.00	314	638	1756.00	439.00	1724	16727	30862.00	7715.50	63	237	586.00	146.50	3	173	198.00	49.50	85	94444	125806.00	31451.50	1	101	117.00	29.25	85	36996	72815.00	18203.75	1	72	78.00	19.50	0	0	0.00	0.00	609	3502	6663.00	1665.75	3600	901	899	286780	1118	1229	4603.00	1150.75	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	541	544	2170.00	542.50	0	0	0.00	0.00	NO_DNS_ENTRY	1724	16727	30862.00	7715.50	85	94444	125806.00	31451.50	85	36996	72815.00	18203.75	3600	901	899	286780
4	0	1100310152250804	-1	-1	-36000	1100310070000000	Primary:XXX.XXXQCSS1:NT	1100310074530437	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	1	1.00	0.25	0	2	2.00	0.50	0	0	0.00	0.00	327	986	2170.00	542.50	1964	11636	23009.00	5752.25	63	263	573.00	143.25	3	23	34.00	8.50	85	26090	29702.00	7425.50	1	11	16.00	4.00	85	8309	8666.00	2166.50	1	12	16.00	4.00	0	0	0.00	0.00	674	4601	11485.00	2871.25	3599	901	899	290379	1107	1124	4449.00	1112.25	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	538	542	2161.00	540.25	0	0	0.00	0.00	NO_DNS_ENTRY	1964	11636	23009.00	5752.25	85	26090	29702.00	7425.50	85	8309	8666.00	2166.50	3599	901	899	290379
4	0	1100310152250805	-1	-1	-36000	1100310080000000	Primary:XXX.XXXQCSS1:NT	1100310084530442	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	2	4.00	1.00	1	2	6.00	1.50	0	0	0.00	0.00	406	650	2025.00	506.25	2135	12794	26701.00	6675.25	63	282	631.00	157.75	17	50	110.00	27.50	470464	650788	2377639.00	594409.75	16	28	85.00	21.25	85	20732	21405.00	5351.25	1	21	24.00	6.00	0	0	0.00	0.00	662	2511	5570.00	1392.50	3600	902	898	293979	1362	1482	5718.00	1429.50	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	519	535	2096.00	524.00	0	0	0.00	0.00	NO_DNS_ENTRY	2135	12794	26701.00	6675.25	470464	650788	2377639.00	594409.75	85	20732	21405.00	5351.25	3600	902	898	293979
4	0	1100310152250806	-1	-1	-36000	1100310090000000	Primary:XXX.XXXQCSS1:NT	1100310094530825	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	0	10	11.00	2.75	1	12	16.00	4.00	0	1	1.00	0.25	438	696	2252.00	563.00	2413	608576	1047394.00	261848.50	71	283	725.00	181.25	7	40	87.00	21.75	144	533830	1321598.00	330399.50	1	19	56.00	14.00	187	20988	32993.00	8248.25	2	21	30.00	7.50	0	0	0.00	0.00	975	2507	6673.00	1668.25	3601	902	898	297580	1292	1757	5904.00	1476.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	519	526	2094.00	523.50	0	0	0.00	0.00	NO_DNS_ENTRY	2413	608576	1047394.00	261848.50	144	533830	1321598.00	330399.50	187	20988	32993.00	8248.25	3601	902	898	297580
4	0	1100310152250807	-1	-1	-36000	1100310100000000	Primary:XXX.XXXQCSS1:NT	1100310104530379	SYSTEM	Windows_Svr_2003	5.2     	10.18.42.141    	2	586	4096	1	22	27.00	6.75	2	24	31.00	7.75	0	1	1.00	0.25	501	11640	13704.00	3426.00	6674	13864543	13903899.00	3475974.75	173	425	1083.00	270.75	17	580	1091.00	272.75	149339	1663325	2354149.00	588537.25	11	394	432.00	108.00	10762	4556253	4846674.00	1211668.50	5	565	656.00	164.00	0	1	1.00	0.25	1874	36375	43805.00	10951.25	3599	901	899	301179	1276	4349	8276.00	2069.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	SYSTEM	0	0	0	3	2047	527	545	2156.00	539.00	0	0	0.00	0.00	NO_DNS_ENTRY	6674	13864543	13903899.00	3475974.75	149339	1663325	2354149.00	588537.25	10762	4556253	4846674.00	1211668.50	3599	901	899	301179
4	0	1100310152250808	-1	-1	-36000	1100310110000000	Primary:XXX.XXXQCSS1:NT	1100310114531293

Open in new window

0
Senz79Author Commented:
Please find the replacement data for ID:30317061

4       0       1100310152249531        -1      -1      -36000  1100310020000000        Primary:XXX.XXXQCSS1:NT 1100310024530691        SYSTEM  Windows_Svr_2003        5.2             10.18.42.141            2       586     4096    0       0       0.00    0.00    0       1       1.00    0.25    0       0       0.00    0.00    296     2046    3086.00 771.50  1728    37540   50851.00        12712.75        61      227     485.00  121.25  3       31      45.00   11.25   85      33772   34200.00        8550.00 1       10      16.00   4.00    85      22066   23356.00        5839.00 1       20      27.00   6.75    0       0       0.00    0.00    598     3719    6013.00 1503.25 2699    901     899     272380  1107    1127    4454.00 1113.50 0       0       0.00    0.00    0       0       0.00    0.00    0       0       0.00    0.00    SYSTEM  0       0       0       3       2047    538     543     2162.00 540.50  0       0       0.00    0.00    NO_DNS_ENTRY    1728    37540   50851.00        12712.75        85      33772   34200.00        8550.00 85      22066   23356.00        5839.00 2699    901     899     272380
4       0       1100310152250800        -1      -1      -36000  1100310030000000        Primary:XXX.XXXQCSS1:NT 1100310034532527        SYSTEM  Windows_Svr_2003        5.2             10.18.42.141            2       586     4096    0       1       1.00    0.25    0       2       2.00    0.50    0       1       1.00    0.25    293     1639    2662.00 665.50  1715    7871    17340.00        4335.00 60      174     426.00  106.50  3       31      50.00   12.50   85      46227   78576.00        19644.00        1       12      24.00   6.00    85      21466   22497.00        5624.25 0       21      23.00   5.75    0       0       0.00    0.00    595     6560    9407.00 2351.75 3602    902     898     275982  1107    1125    4468.00 1117.00 0       0       0.00    0.00    0       0       0.00    0.00    0       0       0.00    0.00    SYSTEM  0       0       0       3       2047    538     539     2153.00 538.25  0       0       0.00    0.00    NO_DNS_ENTRY    1715    7871    17340.00        4335.00 85      46227   78576.00        19644.00        85      21466   22497.00        5624.25 3602    902     898     275982
4       0       1100310152250801        -1      -1      -36000  1100310040000000        Primary:XXX.XXXQCSS1:NT 1100310044531847        SYSTEM  Windows_Svr_2003        5.2             10.18.42.141            2       586     4096    0       1       1.00    0.25    0       2       3.00    0.75    0       1       1.00    0.25    291     1614    2931.00 732.75  1721    8542    22661.00        5665.25 61      218     580.00  145.00  1       35      54.00   13.50   0       94486   133654.00       33413.50        0       14      27.00   6.75    42      20904   47177.00        11794.25        0       21      26.00   6.50    0       0       0.00    0.00    602     6412    11623.00        2905.75 3599    901     898     279581  1112    1123    4475.00 1118.75 0       0       0.00    0.00    0       0       0.00    0.00    0       0       0.00    0.00    SYSTEM  0       0       0       3       2047    537     539     2152.00 538.00  0       0       0.00    0.00    NO_DNS_ENTRY    1721    8542    22661.00        5665.25 0       94486   133654.00       33413.50        42      20904   47177.00        11794.25        3599    901     898     279581
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.