Hello, I have had a problem for 2 days in my DB2 server

I always have worked with Oracle, and DB2 is totally new for me !!

I have a locked table for any process that I don't know, how do I kill the user and those processes, to unlock everything. (how do I see what is causing the problem ???)

Please I need your help step by step.


I have tried with db2 force application(), db2 force application all, db2stop force (and I got a bigger problem couse everything got locked and I had to re start the server).

I need documentation, to be able to know what i'm doing !!!

Thank you so much !!!

The Db2 command reference is a pdf file, about 1.7 Mb.

You can find it at the IBM site.

Better still is to get a freeware monitoring tool to avoid having to use command line stuff,

see www.db2click.com --> open source DB2 tools.

or: http://chuzhoi_files.tripod.com/

Sure but http://chuzhoi_files.tripod.com/
is not available, what can I do ???

using command line processor:

- connect to database user account using password
- list applications

you get a list of all applications

- force application (123)

where 123 is the one you want to force....

to get data on locks:

- get snapshot for locks on database


substitute the names for database,account and password....

We just had a nice resume on isolation level (DB2) on tek-tips:

http://www.tek-tips.com/viewthread.c...PID=178&page=1

you may need to dive into the concurrency model of DB2 which is admittingly more restricted and complex than ORACLE's....

Thank you so much !

If you have commands information or ways to do the same, please tell me !!!

Bye !

Okay, this is the direct link to download the command reference:

http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

Thanks for the link ... very kind of you

Soundh

If any lock , check is which applications lock the table

by using

db2 get snapshot for locks on DBname


you get more infor about application activity


Hope it may help


Lekharaju Ennam

I would suggest reading replies prior to adding a reply which is a duplicate of an earlier one............