on 01-14-2014 11:34 PM
Guys,
ASE 15.7 sp 60 or any recent version.
When I read the ASE error log, the last few lines of a deadlock message will report whether the deadlock was on a table or index.
I am not able to extrapolate that information from monDeadLock.
Am I overlooking something obvious, or is there a function that identifies the index from the DBID,ObjectID,page#?
use the pageinfo() builtin:
1> select pageinfo(1,1,'help')
2> go
List of options in Page_fields table:
0 : help
1 : next page
2 : previous page
3 : partition id
4 : index id
5 : free offset
6 : status word
7 : min row length
8 : next row number
9 : index level
10 : object id on extent
11 : index id on extent
12 : partition id on extent
13 : extent oam page
14 : lob compression level
15 : page allocated
16 : extent allocated
17 : allocated extents
18 : allocated objects
19 : allocated partitions
20 : number of alloc units
21 : allocated pages
select pageinfo(dbid,pageno,'4')
above will return the index id. That should get you where you want to go
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.