syslocks

Columns for syslocks

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

id

int

4

 

 

No

 

 

 

2

dbid

smallint

2

 

 

No

 

 

 

3

page

int

4

 

 

No

 

 

 

4

type

smallint

2

 

 

No

 

 

 

5

spid

smallint

2

 

 

No

 

 

 

6

class

varchar

30

 

 

Yes

 

 

 

7

fid

smallint

2

 

 

Yes

 

 

 

8

context

tinyint

1

 

 

Yes

 

 

 

9

row

smallint

2

 

 

Yes

 

 

 

10

loid

int

4

 

 

Yes

 

 

 

 

Outgoing sp_commonkeys from syslocks

1

sp_commonkey references table sysprocesses.
Column spid to sysprocesses.spid

 

Incoming sp_commonkeys coming into syslocks

1

sp_commonkey coming from table sysdatabases.
sysdatabases.dbid to column dbid

 

Permissions on syslocks

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo

 


Go to Sybase 12.5.2 Master Database List of Tables.


Updated: Sun Dec 26 14:50:04 2004