cancel
Showing results for 
Search instead for 
Did you mean: 

monDeadLock: index or table ?

Former Member
0 Kudos

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#?

Former Member
0 Kudos


Is the indid hidden in other data of the monDeadlock table?

(if not)So what other options exist to get the indid in T-SQL code?

Does this seem like a forgotten piece of data?

Accepted Solutions (1)

Accepted Solutions (1)

kevin_sherlock
Contributor
0 Kudos

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

Answers (0)