467,199 Members | 981 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

DB2 hangs...(7.2)

Hello,

How to resolve and log a database problem?

For instance I have the following "Lock" situation:
- if I connect to a db2 instance (e.g. database1)
"db2 connect to database1 user dbadmin using xxxx"
and query the database
"select * from table1"
nothing happens....

I can press ctrl-c and a result with 0 hits is diaplayed.
after running db2 force applications all,db2stop,db2start
everything looks fine...

BUT how can I get information what happend?
What log files and commands can i use to analyse this problem further?

Please help ! - Thanks in advance
Victor
Nov 12 '05 #1
  • viewed: 1828
Share:
1 Reply
Ian
news_account wrote:
Hello,

How to resolve and log a database problem?

For instance I have the following "Lock" situation:
- if I connect to a db2 instance (e.g. database1)
"db2 connect to database1 user dbadmin using xxxx"
and query the database
"select * from table1"
nothing happens....

I can press ctrl-c and a result with 0 hits is diaplayed.
after running db2 force applications all,db2stop,db2start
everything looks fine...

BUT how can I get information what happend?
What log files and commands can i use to analyse this problem further?


Chances are there's nothing in the logs. Lock-waits don't get logged,
you need to see them when they are happening to find out which
application is causing your lock-wait.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by John Ramsden | last post: by
11 posts views Thread by anuradha.k.r@sify.com | last post: by
5 posts views Thread by Richard Gutery | last post: by
10 posts views Thread by Tomas Vera | last post: by
6 posts views Thread by Alexander Widera | last post: by
reply views Thread by Arno Stienen | last post: by
2 posts views Thread by Patrick Finnegan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.