SAP MSQSAPSULK table - MS SQL server - list of locks from sap_summary_locks details in SAP

Description: Time the blocking lock was hold in minutes.
Field Name: DURATION
Data Element: MSQLCKDUR
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DURATION

Description: Time stamp when the blocking situation started.
Field Name: START_DATE
Data Element: MSQSTDATE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_DATE

Description: SQL Server process ID
Field Name: SPID
Data Element: MSQSERPRID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

Description: Object name as defined in system table sysobjects.
Field Name: TABLENAME
Data Element: MSQOBJNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLENAME

Description: Lock request mode translated from table sptvalue.
Field Name: LCKNAME
Data Element: MSQSPTNAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKNAME

Description: Windows operating system thread ID
Field Name: KPID
Data Element: MSQTHREDID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KPID

Description: SPID of blocking process.
Field Name: BLOKSPID
Data Element: MSQBLOPRID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOKSPID

Description: Textual description of a lock resource from syslockinfo.
Field Name: LCKRSC
Data Element: MSQRSCTXT
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKRSC

Description: Lock resource type as e. g. KEY or PAGE.
Field Name: LCKTYPE
Data Element: MSQLCKRSC
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKTYPE

Description: The name of the database in SQL Server instance.
Field Name: DBASENAME
Data Element: MSQDBNAME
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBASENAME

Description: Object name as defined in system table sysobjects.
Field Name: INDNAME
Data Element: MSQOBJNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDNAME

Description: Lock request mode translated from table sptvalue.
Field Name: LCKSTATUS
Data Element: MSQSPTNAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKSTATUS

Description: Hostname of the application server logged into SQL Server.
Field Name: HOSTNAME
Data Element: MSQHOSTNAM
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

Description: Name of the application program which owns the connection
Field Name: CONNECTTYP
Data Element: MSQSQLCONN
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTTYP

Description: Wait type of waiting process, reserved field of sysprocesses
Field Name: WAITTYPE
Data Element: MSQWAITTYP
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITTYPE

Description: Command currently being executed by the given process id
Field Name: COMMAND
Data Element: MSQEXECMD
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND