Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2016
    Posts
    4

    Unanswered: DB2 Lock Searching Utility

    Hi,

    Sorry in advance for what is likely a repeat post but I searched and couldn't seem to find anything.

    I'm working on an enterprise application that runs on DB2 and I'm not familiar with the db2 specific dba tables.

    Are there are any tables that explicitly show current table locks in the system?

    I'm also looking for some more information about the DB2 load utility.

    the version time stamp for from the SYS.IBMSYSVERSIONS table is 2009-01-30

    Thanks in advance.

    -Ian

  2. #2
    Join Date
    Feb 2004
    Posts
    18
    sysibmadm.snaplock

  3. #3
    Join Date
    Jun 2016
    Posts
    4
    I tried doing a select from that table but return an error, even if I try to select a count I return nothing.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,286
    Provided Answers: 5
    What DB2 version and OS are you using?

    Andy

  5. #5
    Join Date
    Jun 2016
    Posts
    4
    SELECT * FROM SYSIBMADM.ENV_INST_INFO

    inst_name is_inst_partitionable num_dbpartitions inst_ptr_size release_num service_level bld_level ptf fixpack_num
    --------- --------------------- ---------------- ------------- ----------- ------------- --------- -------- -----------
    db2inst1 1 1 64 08070107 DB2 v9.7.0.6 s120629 IP23414 6


    v9.7.0.6

    I'm running all of this from a CRT window on a Citrix Receiver box. I'm not sure about the exact OS

  6. #6
    Join Date
    Jan 2003
    Posts
    4,286
    Provided Answers: 5

  7. #7
    Join Date
    Jun 2016
    Posts
    4
    Thank you, this is very helpful.

Posting Permissions

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