Well, well, well!
It's ADO! Hehe. How have you been? The example below may be of
some help to you.

--Determining DB2 Current Log Files (DOE-TUDB01 Server - Windows 2003)

1. Go to Log Files directory

a. In the Command Editor, type: get db cfg

b. Search for "Path to log files" (H:\DB2\DEKM\DBLOGS)

c. Exit the Command Editor


2. Go the MS-DOS Command Prompt (cmd)

a. cd H:\DB2\DEKM\DBLOGS

b. Type: db2cmd

c. Type: db2 get db cfg for DEKM | findstr -i "first active log"
(Ex. S0031612)

d. Type: dir/w S*.LOG (Ex. Last .LOG file (Ex.S0031661)

e. Subtract ouptut (Step 2d - Step 2c) (Ex. 31661 - 31612 = 49)





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.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: ado
[mailto:db2udbdba-ezmlmshield-x75561898.[Email address protected]
Sent: Thursday, December 27, 2007 10:32 AM
To: LazyDBA Discussion
Subject: Check I/Os and Active Log

1. How do I check which file is the active log? (what command?)

2. How do I check I/Os, locking when having slow responses?

Thank you very much!
ADO



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