thanks guys - I have db2gov running for the very first time :)
I have to work around error "rshd: 0826-813 Permission is denied." by
putting
<hostname> <username> in this file $HOME/.rhosts
even though i'm running db2gov under the same local instance.
Cheers
Ray
PS. Ed - i'm bored of fighting fires so i'm trying to learn from all the
LazyDBA and let db2gov do my work :)
"Edwards Ed " <db2udbdba-ezmlmshield-x10845532.[Email address protected]
02/23/2007 12:59 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: db2gov config file
Suresh,
I love it!
Have a great day and Weekend! Hehe.
-----Original Message-----
From: Suresh
[mailto:db2udbdba-ezmlmshield-x58845645.[Email address protected]
Sent: Friday, February 23, 2007 3:22 PM
To: LazyDBA Discussion
Subject: RE: db2gov config file
Here is a sample gov.cfg file to focre out connections running more than
10 minutes...
{ desc force out queries having UOW running for one hour or more }
interval 60;
dbname DBNAME;
authid id1,id2
setlimit uowtime 600 action force;
:)
Ed,
Friiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiday!
Suresh G.
"Edwards Ed " <db2udbdba-ezmlmshield-x54910658.[Email address
protected]
02/23/2007 01:10 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: db2gov config file
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
---------------------------------------------------------------------
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
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's
reserves the right to retrieve and read any message created, sent and
received. Kohl's reserves the right to monitor messages to or from
authorized Kohl's Associates at any time
without any further consent.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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