Professional Web Applications Themes

internal lock - IBM DB2

can someone explain to me what is internal p lock, internal s lock, internal v lock? when i have IS lock or IX lock , i always have these internal locks together for the application handle Application handle = 261 Application ID = AC100482.GD3A.00F85FE51898 Sequence number = 0006 Application name = db2jccmain Authorization ID = WCADMIN Application status = UOW Waiting Status change time = Not Collected Application code page = 1208 Locks held = 1 Total wait time (ms) = Not Collected List Of Locks Lock Name = 0x5359534C564C303153304E4441 Lock Attributes = 0x00000000 Release Flags = 0x40000000 Lock Count ...

  1. #1

    Default internal lock

    can someone explain to me what is internal p lock, internal s lock,
    internal v lock? when i have IS lock or IX lock , i always have these
    internal locks together for the application handle

    Application handle = 261
    Application ID =
    AC100482.GD3A.00F85FE51898
    Sequence number = 0006
    Application name = db2jccmain
    Authorization ID = WCADMIN
    Application status = UOW Waiting
    Status change time = Not Collected
    Application code page = 1208
    Locks held = 1
    Total wait time (ms) = Not Collected

    List Of Locks
    Lock Name = 0x5359534C564C303153304E4441
    Lock Attributes = 0x00000000
    Release Flags = 0x40000000
    Lock Count = 1
    Hold Count = 0
    Lock Object Name = 0
    Object Type = Internal P Lock
    Mode = S
    xixi Guest

  2. #2

    Default Re: internal lock

    They are used by IBM developer or support people. You don't need worry
    about them.

    xixi wrote:
     

    Fan Guest

  3. #3

    Default Re: internal lock

    Actually these locks are part of the general execution of DB2.

    A p-lock is a lock on the package cache:
    Any execution of SQL, whether static or dynamic, must be done while holding a 'package lock'. This ensures that no-one can drop the package that is being executed.

    A v-lock is a variation lock :
    Any execution of dynamic SQL is done via an entry in the SQL cache known as a variation. In order to ensure that the variation remains valid during the execution, V locks are acquired on behalf of the entry.

    An s-lock is a sequence lock:
    Not sure if I am allowed to tell you what it is used for :)

    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
    "Fan Ruo Xin" <net> wrote in message news:net...
    They are used by IBM developer or support people. You don't need worry
    about them.

    xixi wrote:
     

    Bob Guest

Similar Threads

  1. How to lock pdf's??
    By Specialty_Pub@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: November 10th, 08:52 PM
  2. To lock or not to lock?
    By BKBK in forum Macromedia ColdFusion
    Replies: 6
    Last Post: July 21st, 01:06 PM
  3. NUM LOCK
    By Larry in forum Windows XP/2000/ME
    Replies: 3
    Last Post: July 25th, 01:55 PM
  4. Lock out
    By luds in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 24th, 11:42 PM
  5. lock down xp
    By Jay Simmons in forum Windows Setup, Administration & Security
    Replies: 4
    Last Post: July 7th, 01:47 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139