Default locking region information: 122 Last allocated locker ID 0x7fffffff Current maximum unused locker ID 9 Number of lock modes 1000 Maximum number of locks possible 1000 Maximum number of lockers possible 1000 Maximum number of lock objects possible 20 Number of lock object partitions 40 Number of current locks 113 Maximum number of locks at any one time 6 Maximum number of locks in any one bucket 0 Maximum number of locks stolen by for an empty partition 0 Maximum number of locks stolen for any one partition 97 Number of current lockers 103 Maximum number of lockers at any one time 40 Number of current lock objects 85 Maximum number of lock objects at any one time 3 Maximum number of lock objects in any one bucket 0 Maximum number of objects stolen by for an empty partition 0 Maximum number of objects stolen for any one partition 10M Total number of locks requested (10261454) 272669 Total number of locks released 0 Total number of locks upgraded 50 Total number of locks downgraded 518 Lock requests not available due to conflicts, for which we waited 9988729 Lock requests not available due to conflicts, for which we did not wait 0 Number of deadlocks 0 Lock timeout value 0 Number of locks that have timed out 0 Transaction timeout value 0 Number of transactions that have timed out 576KB The size of the lock region 1388 The number of partition locks that required waiting (0%) 423 The maximum number of times any partition lock was waited for (0%) 0 The number of object queue operations that required waiting (0%) 1 The number of locker allocations that required waiting (0%) 0 The number of region locks that required waiting (0%) 3 Maximum hash bucket length =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Lock REGINFO information: Lock Region type 5 Region ID g:\sas_new_201307\cache_dbv\!!!YA\env\__db.005 Region name 0xa40000 Region address 0xa400c8 Region primary address 0 Region maximum allocation 0 Region allocated Region allocations: 47 allocations, 0 failures, 0 frees, 1 longest Allocations by power-of-two sizes: 1KB 2 2KB 1 4KB 40 8KB 0 16KB 2 32KB 0 64KB 0 128KB 2 256KB 0 512KB 0 1024KB 0 REGION_JOIN_OK Region flags =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Lock region parameters: 30 Lock region region mutex [0/111806 0% 2784/4020] 1031 locker table size 1031 object table size 752 obj_off 101104 locker_off 1 need_dd =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Lock conflict matrix: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Locks grouped by lockers: Locker Mode Count Status ----------------- Object --------------- 8 dd= 0 locks held 2 write locks 0 pid/thread 2304/204 priority 100 8 READ 1 HELD z16\19\9\77.39.sdbv: handle 2 8 READ 1 HELD z16\19\9\77.39.sdbv: handle 0 9 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 a dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 b dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 c dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 d dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 e dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 14 dd= 0 locks held 2 write locks 0 pid/thread 2304/2852 priority 100 14 READ 1 HELD z15\9\4\38.19.sdbv: handle 2 14 READ 1 HELD z15\9\4\38.19.sdbv: handle 0 15 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 16 dd= 0 locks held 2 write locks 0 pid/thread 2304/204 priority 100 16 READ 1 HELD z14\4\2\19.9.sdbv: handle 2 16 READ 1 HELD z14\4\2\19.9.sdbv: handle 0 17 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 18 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 19 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 1a dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 1b dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 1c dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 1d dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 1e dd= 0 locks held 2 write locks 0 pid/thread 2304/3608 priority 100 1e READ 1 HELD z12\1\0\4.2.sdbv: handle 2 1e READ 1 HELD z12\1\0\4.2.sdbv: handle 0 1f dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 23 dd= 0 locks held 2 write locks 0 pid/thread 2304/204 priority 100 23 READ 1 HELD z6\0\0\0.0.sdbv: handle 2 23 READ 1 HELD z6\0\0\0.0.sdbv: handle 0 24 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 25 dd= 0 locks held 0 write locks 0 pid/thread 2304/3696 priority 100 26 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 27 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 28 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 29 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 2a dd= 0 locks held 2 write locks 0 pid/thread 2304/2852 priority 100 2a READ 1 HELD z13\2\1\9.4.sdbv: handle 2 2a READ 1 HELD z13\2\1\9.4.sdbv: handle 0 2b dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 2c dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 33 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 38 dd= 0 locks held 2 write locks 0 pid/thread 2304/880 priority 100 38 READ 1 HELD z16\19\9\76.39.sdbv: handle 2 38 READ 1 HELD z16\19\9\76.39.sdbv: handle 0 39 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 3a dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 3b dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 3c dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 3d dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 3e dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 3f dd= 0 locks held 2 write locks 0 pid/thread 2304/2852 priority 100 3f READ 1 HELD z17\38\19\153.79.sdbv: handle 2 3f READ 1 HELD z17\38\19\153.79.sdbv: handle 0 40 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 41 dd= 0 locks held 2 write locks 0 pid/thread 2304/3608 priority 100 41 READ 1 HELD z18\76\39\307.159.sdbv: handle 2 41 READ 1 HELD z18\76\39\307.159.sdbv: handle 0 42 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 43 dd= 0 locks held 2 write locks 0 pid/thread 2304/880 priority 100 43 READ 1 HELD z19\153\79\614.318.sdbv: handle 2 43 READ 1 HELD z19\153\79\614.318.sdbv: handle 0 44 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 45 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 46 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 47 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 48 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 49 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 4a dd= 0 locks held 2 write locks 0 pid/thread 2304/204 priority 100 4a READ 1 HELD z17\38\19\154.79.sdbv: handle 2 4a READ 1 HELD z17\38\19\154.79.sdbv: handle 0 4b dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 4c dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 4d dd= 0 locks held 2 write locks 0 pid/thread 2304/2852 priority 100 4d READ 1 HELD z18\77\39\308.158.sdbv: handle 2 4d READ 1 HELD z18\77\39\308.158.sdbv: handle 0 4e dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 4f dd= 0 locks held 2 write locks 0 pid/thread 2304/3608 priority 100 4f READ 1 HELD z19\154\79\616.317.sdbv: handle 2 4f READ 1 HELD z19\154\79\616.317.sdbv: handle 0 50 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 51 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 52 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 53 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 54 dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 55 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 56 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 57 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 58 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 59 dd= 0 locks held 2 write locks 0 pid/thread 2304/3608 priority 100 59 READ 1 HELD z19\153\79\615.317.sdbv: handle 2 59 READ 1 HELD z19\153\79\615.317.sdbv: handle 0 5a dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 5b dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 5c dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 5d dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 5e dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 5f dd= 0 locks held 0 write locks 0 pid/thread 2304/3116 priority 100 60 dd= 0 locks held 2 write locks 0 pid/thread 2304/2852 priority 100 60 READ 1 HELD z18\76\39\307.158.sdbv: handle 2 60 READ 1 HELD z18\76\39\307.158.sdbv: handle 0 61 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 62 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 63 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 64 dd= 0 locks held 2 write locks 0 pid/thread 2304/204 priority 100 64 READ 1 HELD z17\38\19\154.78.sdbv: handle 2 64 READ 1 HELD z17\38\19\154.78.sdbv: handle 0 65 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 66 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 67 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 68 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 69 dd= 0 locks held 2 write locks 0 pid/thread 2304/880 priority 100 69 READ 1 HELD z18\77\39\308.157.sdbv: handle 2 69 READ 1 HELD z18\77\39\308.157.sdbv: handle 0 6a dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 6b dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 6c dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 6d dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 6e dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 6f dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 70 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 71 dd= 0 locks held 2 write locks 0 pid/thread 2304/3608 priority 100 71 READ 1 HELD z19\154\79\616.316.sdbv: handle 2 71 READ 1 HELD z19\154\79\616.316.sdbv: handle 0 72 dd= 0 locks held 0 write locks 0 pid/thread 2304/3608 priority 100 73 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 74 dd= 0 locks held 2 write locks 0 pid/thread 2304/3696 priority 100 74 READ 1 HELD z5\0\0\0.0.sdbv: handle 2 74 READ 1 HELD z5\0\0\0.0.sdbv: handle 0 75 dd= 0 locks held 0 write locks 0 pid/thread 2304/3696 priority 100 76 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 77 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 78 dd= 0 locks held 2 write locks 0 pid/thread 2304/3608 priority 100 78 READ 1 HELD z13\2\1\9.5.sdbv: handle 2 78 READ 1 HELD z13\2\1\9.5.sdbv: handle 0 79 dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 7a dd= 0 locks held 0 write locks 0 pid/thread 2304/2108 priority 100 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Locks grouped by object: Locker Mode Count Status ----------------- Object --------------- 64 READ 1 HELD z17\38\19\154.78.sdbv: handle 2 41 READ 1 HELD z18\76\39\307.159.sdbv: handle 2 64 READ 1 HELD z17\38\19\154.78.sdbv: handle 0 41 READ 1 HELD z18\76\39\307.159.sdbv: handle 0 59 READ 1 HELD z19\153\79\615.317.sdbv: handle 2 59 READ 1 HELD z19\153\79\615.317.sdbv: handle 0 1e READ 1 HELD z12\1\0\4.2.sdbv: handle 0 1e READ 1 HELD z12\1\0\4.2.sdbv: handle 2 3f READ 1 HELD z17\38\19\153.79.sdbv: handle 0 3f READ 1 HELD z17\38\19\153.79.sdbv: handle 2 71 READ 1 HELD z19\154\79\616.316.sdbv: handle 2 71 READ 1 HELD z19\154\79\616.316.sdbv: handle 0 4d READ 1 HELD z18\77\39\308.158.sdbv: handle 0 4d READ 1 HELD z18\77\39\308.158.sdbv: handle 2 69 READ 1 HELD z18\77\39\308.157.sdbv: handle 2 69 READ 1 HELD z18\77\39\308.157.sdbv: handle 0 60 READ 1 HELD z18\76\39\307.158.sdbv: handle 2 60 READ 1 HELD z18\76\39\307.158.sdbv: handle 0 2a READ 1 HELD z13\2\1\9.4.sdbv: handle 0 2a READ 1 HELD z13\2\1\9.4.sdbv: handle 2 4f READ 1 HELD z19\154\79\616.317.sdbv: handle 2 4f READ 1 HELD z19\154\79\616.317.sdbv: handle 0 14 READ 1 HELD z15\9\4\38.19.sdbv: handle 0 16 READ 1 HELD z14\4\2\19.9.sdbv: handle 0 14 READ 1 HELD z15\9\4\38.19.sdbv: ; handle 2 16 READ 1 HELD z14\4\2\19.9.sdbv: handle 2 4a READ 1 HELD z17\38\19\154.79.sdbv: handle 0 4a READ 1 HELD z17\38\19\154.79.sdbv: handle 2 74 READ 1 HELD z5\0\0\0.0.sdbv: handle 0 74 READ 1 HELD z5\0\0\0.0.sdbv: handle 2 23 READ 1 HELD z6\0\0\0.0.sdbv: handle 0 23 READ 1 HELD z6\0\0\0.0.sdbv: handle 2 8 READ 1 HELD z16\19\9\77.39.sdbv: handle 2 8 READ 1 HELD z16\19\9\77.39.sdbv: handle 0 43 READ 1 HELD z19\153\79\614.318.sdbv: handle 0 78 READ 1 HELD z13\2\1\9.5.sdbv: handle 0 43 READ 1 HELD z19\153\79\614.318.sdbv: handle 2 78 READ 1 HELD z13\2\1\9.5.sdbv: handle 2 38 READ 1 HELD z16\19\9\76.39.sdbv: handle 2 38 READ 1 HELD z16\19\9\76.39.sdbv: handle 0