SAP MSSDBLOCKS_SNAP table - DB Locks snapshot - includes handles details in SAP


SAP MSSDBLOCKS_SNAP table summary

Object Name: MSSDBLOCKS_SNAP
Dictionary Type: Structure
Description: DB Locks snapshot - includes handles


Field list for MSSDBLOCKS_SNAP table on an S/4 SAP system

Details
MSSDBLOCKS_SNAP-ACTFLAG table field -

Description:
Field Name: ACTFLAG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTFLAG

MSSDBLOCKS_SNAP-FIRSTOCCUR table field -

Description:
Field Name: FIRSTOCCUR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTOCCUR

MSSDBLOCKS_SNAP-REQSPID table field - MS SQL Server process ID

Description: MS SQL Server process ID
Field Name: REQSPID
Data Element: MSSREQSPID
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 REQSPID

MSSDBLOCKS_SNAP-HOLDSPID table field - MS SQL Server process ID (blocking)

Description: MS SQL Server process ID (blocking)
Field Name: HOLDSPID
Data Element: MSSBLKSPID
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 HOLDSPID

MSSDBLOCKS_SNAP-REQPID table field - MS SQL-Server host process id (= OS work process ID)

Description: MS SQL-Server host process id (= OS work process ID)
Field Name: REQPID
Data Element: MSSHOSTPID
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: WPPID
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQPID

MSSDBLOCKS_SNAP-OPEN_TRAN table field - Number of open transactions for the SQL Server process

Description: Number of open transactions for the SQL Server process
Field Name: OPEN_TRAN
Data Element: MSSOPENTRAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_TRAN

MSSDBLOCKS_SNAP-PROCSTAT table field - MS SQL-Server process status

Description: MS SQL-Server process status
Field Name: PROCSTAT
Data Element: MSSSTATUS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCSTAT

MSSDBLOCKS_SNAP-USERNAME table field - MS SQL Server user name

Description: MS SQL Server user name
Field Name: USERNAME
Data Element: MSSUNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

MSSDBLOCKS_SNAP-HOSTNAME table field - Hostname of the application server logged into SQL Server

Description: Hostname of the application server logged into SQL Server
Field Name: HOSTNAME
Data Element: MSSHOSTNM_
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSSDBLOCKS_SNAP-PROGNAME table field - Name of the application program which owns the connection

Description: Name of the application program which owns the connection
Field Name: PROGNAME
Data Element: MSSPRGNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNAME

MSSDBLOCKS_SNAP-COMMAND table field - MS SQL Server command

Description: MS SQL Server command
Field Name: COMMAND
Data Element: MSSCOMMAND
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

MSSDBLOCKS_SNAP-INPUTBUFF table field - Output from DBCC INPUTBUFFER for lock display

Description: Output from DBCC INPUTBUFFER for lock display
Field Name: INPUTBUFF
Data Element: MSSINPUTBUFF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INPUTBUFF

MSSDBLOCKS_SNAP-WAITTIME table field - Current wait time of the process in milliseconds

Description: Current wait time of the process in milliseconds
Field Name: WAITTIME
Data Element: MSSWAITTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITTIME

MSSDBLOCKS_SNAP-WAITRSC table field - Wait Resource as seen in sysprocesses

Description: Wait Resource as seen in sysprocesses
Field Name: WAITRSC
Data Element: MSSWAITRSC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITRSC

MSSDBLOCKS_SNAP-LASTWTYPE table field - Last Wait Type as seen in sysprocesses

Description: Last Wait Type as seen in sysprocesses
Field Name: LASTWTYPE
Data Element: MSSLASTWTYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTWTYPE

MSSDBLOCKS_SNAP-DBNAME table field - MS SQL Server: Database name

Description: MS SQL Server: Database name
Field Name: DBNAME
Data Element: MSSLDBNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSSDBLOCKS_SNAP-OBJNAME table field - Table name

Description: Table name
Field Name: OBJNAME
Data Element: MSSTNAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJNAME

MSSDBLOCKS_SNAP-INDEXNAME table field - MS SQL Server object name

Description: MS SQL Server object name
Field Name: INDEXNAME
Data Element: MSSOBJNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXNAME

MSSDBLOCKS_SNAP-LOCKRSC table field - Textual description of a lock resource from syslockinfo

Description: Textual description of a lock resource from syslockinfo
Field Name: LOCKRSC
Data Element: MSSLOCKRSC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKRSC

MSSDBLOCKS_SNAP-LOCKTYPE table field - Char representation of rsc_type from syslockinfo

Description: Char representation of rsc_type from syslockinfo
Field Name: LOCKTYPE
Data Element: MSSCHARLOCKTYP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKTYPE

MSSDBLOCKS_SNAP-LOCKNAME table field - MS SQL Server lock description text

Description: MS SQL Server lock description text
Field Name: LOCKNAME
Data Element: MSSLOCKTXT
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKNAME

MSSDBLOCKS_SNAP-LOCKSTAT table field - req_mod from syslockinfo for blocking/blocked lock entry

Description: req_mod from syslockinfo for blocking/blocked lock entry
Field Name: LOCKSTAT
Data Element: MSSLOCKMODE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKSTAT

MSSDBLOCKS_SNAP-REQ_REFCNT table field - req_refcnt from syslockinfo for blocking/blocked lock entry

Description: req_refcnt from syslockinfo for blocking/blocked lock entry
Field Name: REQ_REFCNT
Data Element: MSSREQREFCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_REFCNT

MSSDBLOCKS_SNAP-REQ_OWNERTYPE table field - req_refcnt from syslockinfo for blocking/blocked lock entry

Description: req_refcnt from syslockinfo for blocking/blocked lock entry
Field Name: REQ_OWNERTYPE
Data Element: MSSREQOWNTYP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_OWNERTYPE

MSSDBLOCKS_SNAP-SQLHANDLE table field - handle pointing to sql statment or procedure

Description: handle pointing to sql statment or procedure
Field Name: SQLHANDLE
Data Element: MSSSQLHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLHANDLE

MSSDBLOCKS_SNAP-STMT_START_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_START_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_START_OFFSET

MSSDBLOCKS_SNAP-STMT_END_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_END_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_END_OFFSET

MSSDBLOCKS_SNAP-PLAN_HANDLE table field - handle pointing to plan used in execution of sql stmt/proc

Description: handle pointing to plan used in execution of sql stmt/proc
Field Name: PLAN_HANDLE
Data Element: MSSPLANHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_HANDLE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table