|
Field name
|
Field number
|
Data type
|
Description
|
|
_DbSvcMgr-Id
|
2
|
INT64
|
Id is ROWID of the _DBServiceManager record
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-CommunicationAreaSize
|
3
|
DECIMAL
|
Size of the pica queue in kilobytes
Format >>>>>>>>9.999
|
|
_DbSvcMgr-TotalMsgEntries
|
4
|
INT64
|
Total number of messages available in the pica queue
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-FreeMsgEntries
|
5
|
INT64
|
Number messages on the free list in the pica queue
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-UsedMsgEntries
|
6
|
INT64
|
Total number of messages on all queues
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-MessageHWM
|
7
|
INT64
|
High water mark of used messages
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-PicaFilled
|
8
|
INT64
|
Number of times the pica queue filled
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-LatchHolder
|
9
|
INTEGER
|
User number of last pica latch holder
Format ->>>>>>>>>9
|
|
_DbSvcMgr-AccessCount
|
10
|
INT64
|
Number of times locks were taken out
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-AccessCollisions
|
11
|
INT64
|
Number of times collisions occur when locks are held
Format ->>>>>>>>>>>>>>>>>>9
|
|
_DbSvcMgr-LockPID
|
12
|
INTEGER
|
PID of the pica queue lock holder (if the pica queue locked)
0 if no lock
Format >>>>>>>>9
|
|
_DbSvcMgr-LockUserType
|
13
|
CHARACTER
|
User type of the pica queue lock holder (if the pica queue locked)
"Not available" if the queue is not locked
Format X(32)
|
|
_DbSvcMgr-LockUserNumber
|
14
|
INT64
|
User number of the pica queue lock holder (if pica queue locked)
0 if no lock
Format ->>>>>>>>>>>>>>>>>>9
|