SAP DB4WTSTS_P table - iSeries: Wait Statistics per Process (Database Jobs) details in SAP

SAP DB4WTSTS_P table summary

Object Name: DB4WTSTS_P
Dictionary Type: Structure
Description: iSeries: Wait Statistics per Process (Database Jobs)

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

Details

DB4WTSTS_P-INSTANCE_P table field - Application Server Instance ▼

Description: Application Server Instance
Field Name: INSTANCE_P
Data Element: MSNAME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSNAME
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCE_P

DB4WTSTS_P-PID table field - Process Identification ▼

Description: Process Identification
Field Name: PID
Data Element: WPPID
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 PID

DB4WTSTS_P-JOBNUM table field - iSeries: Job Number (Database Monitor) ▼

Description: iSeries: Job Number (Database Monitor)
Field Name: JOBNUM
Data Element: QQJNUM
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: QQJNUM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBNUM

DB4WTSTS_P-WDB table field - Number of times a process had to wait to obtain a DB lock ▼

Description: Number of times a process had to wait to obtain a DB lock
Field Name: WDB
Data Element: DB_WAITS
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 WDB

DB4WTSTS_P-WNDB table field - Number of times a process had to wait to obtain a nonDB lock ▼

Description: Number of times a process had to wait to obtain a nonDB lock
Field Name: WNDB
Data Element: NDB_WAITS
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 WNDB

DB4WTSTS_P-WIM table field - No. of times a process had to wait to obtain an IM lock ▼

Description: No. of times a process had to wait to obtain an IM lock
Field Name: WIM
Data Element: IM_WAITS
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 WIM

DB4WTSTS_P-WDBT table field - Cumulative time (millisec.) spent on database lock waits ▼

Description: Cumulative time (millisec.) spent on database lock waits
Field Name: WDBT
Data Element: DB_W_TIME
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 WDBT

DB4WTSTS_P-WNDBT table field - Cumulative time (millisec.) spent on non-DB lock waits ▼

Description: Cumulative time (millisec.) spent on non-DB lock waits
Field Name: WNDBT
Data Element: NDB_W_TIME
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 WNDBT

DB4WTSTS_P-WIMT table field - Cumulative time (millisec.) spent on internal machine waits ▼

Description: Cumulative time (millisec.) spent on internal machine waits
Field Name: WIMT
Data Element: IM_W_TIME
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 WIMT

DB4WTSTS_P-WDBT_AVG table field - Average process database lock wait time (ms) ▼

Description: Average process database lock wait time (ms)
Field Name: WDBT_AVG
Data Element: WDBT_AVG
Data Type: DEC
length (Dec): 15(4)
Check table:
Conversion Routine:
Domain Name: DEC154_DB4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WDBT_AVG

DB4WTSTS_P-WNDBT_AVG table field - Average process non-database lock wait time (ms) ▼

Description: Average process non-database lock wait time (ms)
Field Name: WNDBT_AVG
Data Element: WNDBT_AVG
Data Type: DEC
length (Dec): 15(4)
Check table:
Conversion Routine:
Domain Name: DEC154_DB4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WNDBT_AVG

DB4WTSTS_P-WIMT_AVG table field - Average process internal machine lock wait time (ms) ▼

Description: Average process internal machine lock wait time (ms)
Field Name: WIMT_AVG
Data Element: WIMT_AVG
Data Type: DEC
length (Dec): 15(4)
Check table:
Conversion Routine:
Domain Name: DEC154_DB4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WIMT_AVG

View list of all SAP tables(S4H/ECC)

Select data from SAP table