Well, well, well!
It's RLam! Hehe. How have you been? I see you are as bored as I am!
Hehe. Well, it you use the code below against a table that has 5 - 10
million rows, you will achieve your goal! Hehe.


SELECT EMPNO, ROW# FROM DEDBADM.EMP TB1,
TABLE (SELECT COUNT(*) + 1 AS ROW#
FROM DEDBADM.EMP TB2
WHERE TB2.EMPNO < TB1.EMPNO) AS TEMP_TAB
WHERE ROW# between 1000 and 2000;


It's Fridayyyyyyyyyy! Partyyyyyyyyy!


Have a great Day and Weekend!





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: RLam
[mailto:db2udbdba-ezmlmshield-x98599847.[Email address protected]
Sent: Friday, February 23, 2007 1:48 PM
To: LazyDBA Discussion
Subject: db2gov config file

Does anyone have a sample file to force / capture long running queries
say
exceeding 10 minutes?

TGIF :)

Thanks
Ray


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page