Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to check the DB2 logs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Thu Jun 14, 2007 12:17 pm    Post subject: How to check the DB2 logs
Reply with quote

Hi,

I would like to check the DB2 logs. If you have any ideas please share.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Thu Jun 14, 2007 12:33 pm    Post subject: Re: How to check the DB2 logs
Reply with quote

Could You be a little more specific, please,
it would help to select the ideas to share.

regards

e.s
Back to top
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Thu Jun 14, 2007 12:39 pm    Post subject: Re: How to check the DB2 logs
Reply with quote

Hi,

In production few records are facing -911 issue so that i have noticed that which DB2 tables are facing this problem. To anlyze this i have to verify the DB2 logs..!!!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Thu Jun 14, 2007 12:44 pm    Post subject: Re: How to check the DB2 logs
Reply with quote

why check the the logs when db2 provides You, by simpler means, the needed info ??

regards

e.s
Back to top
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Thu Jun 14, 2007 12:48 pm    Post subject: Re: How to check the DB2 logs
Reply with quote

Needed if is , to find the which program is hold (using ) that table in that time. (This is my dbout not sure this is possible or not)
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Thu Jun 14, 2007 12:54 pm    Post subject: Re: How to check the DB2 logs
Reply with quote

if You checked all Your posts You would find the answers to your needs...
I answered Your other post with the solution to Your problem;

activating the DB2 tracing, at least for deadlocks, is common practice at any decent DB2 installation

regards

e.s
Back to top
View user's profile Send private message
TG Murphy

Active User


Joined: 23 Mar 2007
Posts: 149
Location: Ottawa Canada

PostPosted: Thu Jun 14, 2007 11:39 pm    Post subject:
Reply with quote

Dev's - you are on the right track. You need to find out how to view your DB2 logs. The logs contain valuable diagnostic info that cannot be be found anywhere else.

Your DB2 subsystem has a name. Let's pretend yours is called DB2P. Check to see if you can find a batch job that is currently running called DB2PMSTR. If you see this batch job then you have found the logs.

Your DBAs should be able to point you in the right direction.
Back to top
View user's profile Send private message
ricardoslee

New User


Joined: 14 Jun 2007
Posts: 2
Location: Sao Paulo

PostPosted: Fri Jun 15, 2007 12:04 am    Post subject:
Reply with quote

DB2 master logs have everything, just look there.
Back to top
View user's profile Send private message
Dev's

New User


Joined: 12 Mar 2007
Posts: 14
Location: Hyderabad

PostPosted: Fri Jun 15, 2007 9:55 am    Post subject: Re: How to check the DB2 logs
Reply with quote

Thanks Murphy, it helps me lot...!!!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts 24x7 online logs using DSN1LOGP (simi... SRICOBSAS DB2 3 Thu Aug 18, 2016 11:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us