Results 1 to 10 of 10

Thread: Locks

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Unanswered: Locks

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

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    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/
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    Jun 2003
    Posts
    294
    Sure but http://chuzhoi_files.tripod.com/
    is not available, what can I do ???

    Originally posted by blom0344
    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/

  4. #4
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Originally posted by jortiz
    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....
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  5. #5
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    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....
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  6. #6
    Join Date
    Jun 2003
    Posts
    294
    Thank you so much !

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

    Bye !

    Originally posted by blom0344
    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....

  7. #7
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Originally posted by jortiz
    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
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  8. #8
    Join Date
    May 2002
    Posts
    30
    Thanks for the link ... very kind of you

    Soundh
    Originally posted by blom0344
    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....

  9. #9
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    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

  10. #10
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Originally posted by famudba
    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............
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •