Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

resources_prim

The resources_prim table describes resources currently maintained by the locking system.  A resource describes the portion of the database which is locked.  One row is returned for each resource currently known to the locking system of each vnode in the current IMA management domain. 

 
Attribute Name Key Datatype Description
vnode 1 varchar(64) Ingres virtual node name
resource_id 2 integer4 Internal resource id for the current resource.
convert_mode_s 0 varchar(12) Convert lock mode for the resource.
convert_mode 0 integer4 Numeric grant mode for the resource.
grant_mode_s 0 varchar(12) Grant lock mode for the resource.
grant_mode 0 integer4 Numeric grant mode for the resource.
invalid 0 integer4 A non-zero value indicates the resource is not valid.
resource_name 0 varchar(64) Name of the locked resource.
name0 0 integer4 First element of unique resource identification.
name1 0 integer4 Second element of unique resource identification, for user locks this is the database id.
name2 0 integer4 Third element of unique resource identification, for user locks this is the reltid for the table.
name3 0 integer4 Fourth element of unique resource identification, for user locks this is the reltidx for the table.
name4 0 integer4 Fifth element of unique resource identification, for page mode user locks this is the page number in the table.
name5 0 integer4 Sixth element
name6 0 integer4 Sixth element of the unique resource identification.
value0 0 integer4 First part of the lock value block.
value1 0 integer4 Second part of the lock value block.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.