SAP DB2QW199 table - DB2 IFI 199 - Data sets statistics details in SAP


SAP DB2QW199 table summary

Object Name: DB2QW199
Dictionary Type: Structure
Description: DB2 IFI 199 - Data sets statistics


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

Details
DB2QW199-CLGUID table field -

Description:
Field Name: CLGUID
Data Element: DB2CLGUID
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: SMAPGUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLGUID

DB2QW199-USERID table field -

Description:
Field Name: USERID
Data Element: DB2USERID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERID

DB2QW199-DSSDATE table field - Field of type DATS

Description: Field of type DATS
Field Name: DSSDATE
Data Element: DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSDATE

DB2QW199-DSSTIME table field - Field of type TIMS

Description: Field of type TIMS
Field Name: DSSTIME
Data Element: TIMS
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSTIME

DB2QW199-DSSMSEC table field - Event time stamp (milliseconds)

Description: Event time stamp (milliseconds)
Field Name: DSSMSEC
Data Element: DB2EVTTMS
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR06
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSMSEC

DB2QW199-DSSDBNAME table field - Database name

Description: Database name
Field Name: DSSDBNAME
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSDBNAME

DB2QW199-DSSTSNAME table field - Name of the tablespace

Description: Name of the tablespace
Field Name: DSSTSNAME
Data Element: DB2TSNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSTSNAME

DB2QW199-QW0199DN table field - Partition or piece number

Description: Partition or piece number
Field Name: QW0199DN
Data Element: DB20199DN
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199DN

DB2QW199-DSSMEMB table field - DB2 member name in data sharing environment

Description: DB2 member name in data sharing environment
Field Name: DSSMEMB
Data Element: DB2MEMN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSMEMB

DB2QW199-DB2PSTYPE table field - Type of pageset

Description: Type of pageset
Field Name: DB2PSTYPE
Data Element: DB2PSTYPE
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR5
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2PSTYPE

DB2QW199-DB2GBPDEP table field - Group bufferpool dependence

Description: Group bufferpool dependence
Field Name: DB2GBPDEP
Data Element: DB2GBPDEP
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR03
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2GBPDEP

DB2QW199-DB2SYNCIO table field - Synchronous I/O per minute (pages)

Description: Synchronous I/O per minute (pages)
Field Name: DB2SYNCIO
Data Element: DB2SYNCIO
Data Type: DEC
length (Dec): 8(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC10_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2SYNCIO

DB2QW199-DB2APGAIO table field - Avg. number of pages read or written per asynchronous I/O

Description: Avg. number of pages read or written per asynchronous I/O
Field Name: DB2APGAIO
Data Element: DB2APGAIO
Data Type: DEC
length (Dec): 8(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC10_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2APGAIO

DB2QW199-DB2AIOMIN table field - Asyncronous I/Os per minute (pages)

Description: Asyncronous I/Os per minute (pages)
Field Name: DB2AIOMIN
Data Element: DB2AIOMIN
Data Type: DEC
length (Dec): 8(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC10_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2AIOMIN

DB2QW199-DB2CASHPG table field - Cached pages

Description: Cached pages
Field Name: DB2CASHPG
Data Element: DB2CASHPG
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DB2DECPCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2CASHPG

DB2QW199-DB2CHANPG table field - Changed pages

Description: Changed pages
Field Name: DB2CHANPG
Data Element: DB2CHANPG
Data Type: DEC
length (Dec): 5(2)
Check table:
Conversion Routine:
Domain Name: DB2DECPCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2CHANPG

DB2QW199-DB2HPCAPG table field - Percentage of buffers in the HP containing pages of the PS

Description: Percentage of buffers in the HP containing pages of the PS
Field Name: DB2HPCAPG
Data Element: DB2HPCAPG
Data Type: DEC
length (Dec): 4(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC4_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2HPCAPG

DB2QW199-DB2DBPNM table field - Name of buffer pool

Description: Name of buffer pool
Field Name: DB2DBPNM
Data Element: DB2DBPNM
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB2DBPNM

DB2QW199-QW0199TS table field - Start timestamp for collection of dataset values

Description: Start timestamp for collection of dataset values
Field Name: QW0199TS
Data Element: DB20199TS
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199TS

DB2QW199-QW0199DB table field - Database ID

Description: Database ID
Field Name: QW0199DB
Data Element: DB20199DB
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199DB

DB2QW199-QW0199OB table field - Pageset OBID

Description: Pageset OBID
Field Name: QW0199OB
Data Element: DB20199OB
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199OB

DB2QW199-QW0199BP table field - Buffer pool ID

Description: Buffer pool ID
Field Name: QW0199BP
Data Element: DB20199BP
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199BP

DB2QW199-QW0199DS table field - DSS Flags

Description: DSS Flags
Field Name: QW0199DS
Data Element: DB20199DS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR01
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199DS

DB2QW199-QW0199SV table field - Average synchronous I/O delay

Description: Average synchronous I/O delay
Field Name: QW0199SV
Data Element: DB20199SV
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199SV

DB2QW199-QW0199SX table field - Maximum synchronous I/O delay

Description: Maximum synchronous I/O delay
Field Name: QW0199SX
Data Element: DB20199SX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199SX

DB2QW199-QW0199SP table field - Total number of pages read or written synchronously

Description: Total number of pages read or written synchronously
Field Name: QW0199SP
Data Element: DB20199SP
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199SP

DB2QW199-QW0199AD table field - Average asynchronous I/O delay

Description: Average asynchronous I/O delay
Field Name: QW0199AD
Data Element: DB20199AD
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199AD

DB2QW199-QW0199AX table field - Maximum asynchronous I/O delay

Description: Maximum asynchronous I/O delay
Field Name: QW0199AX
Data Element: DB20199AX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199AX

DB2QW199-QW0199AP table field - Total number of pages read or written asynchronously

Description: Total number of pages read or written asynchronously
Field Name: QW0199AP
Data Element: DB20199AP
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199AP

DB2QW199-QW0199AC table field - Total number of asynchronous I/Os

Description: Total number of asynchronous I/Os
Field Name: QW0199AC
Data Element: DB20199AC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199AC

DB2QW199-QW0199VP table field - Number of pages cached in virtual pool

Description: Number of pages cached in virtual pool
Field Name: QW0199VP
Data Element: DB20199VP
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199VP

DB2QW199-QW0199VD table field - Number of changed pages cached in virtual pool

Description: Number of changed pages cached in virtual pool
Field Name: QW0199VD
Data Element: DB20199VD
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199VD

DB2QW199-QW0199HP table field - Number of pages cached in hiperpool

Description: Number of pages cached in hiperpool
Field Name: QW0199HP
Data Element: DB20199HP
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0199HP

DB2QW199-S199AP table field - Total asynchronous I/O minute (count)

Description: Total asynchronous I/O minute (count)
Field Name: S199AP
Data Element: DB2199AP
Data Type: DEC
length (Dec): 8(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC10_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field S199AP

DB2QW199-QWP1DTIM table field - Time Interval Before DB2 Resets Data Set Statistics (Min.)

Description: Time Interval Before DB2 Resets Data Set Statistics (Min.)
Field Name: QWP1DTIM
Data Element: DB2WP1DTIM
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QWP1DTIM


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table