SAP DB2SWPARM table - Summary Structure for System-Wide Parameters details in SAP


SAP DB2SWPARM table summary

Object Name: DB2SWPARM
Dictionary Type: Structure
Description: Summary Structure for System-Wide Parameters


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

Details
DB2SWPARM-HDSUBSYSID table field - DB2 subsystem ID

Description: DB2 subsystem ID
Field Name: HDSUBSYSID
Data Element: DB2SWPSSID
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR04
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDSUBSYSID

DB2SWPARM-HDATDAT table field - Date when sampling is taken

Description: Date when sampling is taken
Field Name: HDATDAT
Data Element: DB2SWPATDT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDATDAT

DB2SWPARM-HDATTIM table field - Time when sampling is taken

Description: Time when sampling is taken
Field Name: HDATTIM
Data Element: DB2SWPATTM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDATTIM

DB2SWPARM-HDSINCEDAT table field - Field type date, YYYYMMDD

Description: Field type date, YYYYMMDD
Field Name: HDSINCEDAT
Data Element: DB2DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDSINCEDAT

DB2SWPARM-HDSINCETIM table field - Field type time, HHMMSS

Description: Field type time, HHMMSS
Field Name: HDSINCETIM
Data Element: DB2TIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDSINCETIM

DB2SWPARM-HDLRESTIME table field - Time of last reset

Description: Time of last reset
Field Name: HDLRESTIME
Data Element: DB2SWPLRTM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDLRESTIME

DB2SWPARM-BPACTPGNM table field - Buffer pool with maximum active pages

Description: Buffer pool with maximum active pages
Field Name: BPACTPGNM
Data Element: DB2SWPAPGN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPACTPGNM

DB2SWPARM-BPACTPG table field - Maximum active pages across all the active buffer pools

Description: Maximum active pages across all the active buffer pools
Field Name: BPACTPG
Data Element: DB2SWPAPG
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 BPACTPG

DB2SWPARM-BPHITRATNM table field - Buffer pool which has the minimum hit ratio

Description: Buffer pool which has the minimum hit ratio
Field Name: BPHITRATNM
Data Element: DB2SWPHRTN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPHITRATNM

DB2SWPARM-BPHITRAT table field - Random hit ratio

Description: Random hit ratio
Field Name: BPHITRAT
Data Element: DB2RNDHITR
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 BPHITRAT

DB2SWPARM-BPSHORTNM table field - Buffer pool which has a buffer pool shortage

Description: Buffer pool which has a buffer pool shortage
Field Name: BPSHORTNM
Data Element: DB2SWPSHTN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPSHORTNM

DB2SWPARM-BPSHORT table field - Buffer pool shortage in any of the active buffer pools

Description: Buffer pool shortage in any of the active buffer pools
Field Name: BPSHORT
Data Element: DB2SWPSHT
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPSHORT

DB2SWPARM-BPHPCONCNM table field - Buffer pool which has hiperpool concerns

Description: Buffer pool which has hiperpool concerns
Field Name: BPHPCONCNM
Data Element: DB2SWPHPCN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPHPCONCNM

DB2SWPARM-BPHPCONC table field - Hiper pool concerns for any of the active buffer pools

Description: Hiper pool concerns for any of the active buffer pools
Field Name: BPHPCONC
Data Element: DB2SWPHPC
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPHPCONC

DB2SWPARM-LKDEADLOCK table field - No. of deadlocks

Description: No. of deadlocks
Field Name: LKDEADLOCK
Data Element: DB2SWPDLCK
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 LKDEADLOCK

DB2SWPARM-LKTIMEOUT table field - Number of timeouts

Description: Number of timeouts
Field Name: LKTIMEOUT
Data Element: DB2SWPTIME
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 LKTIMEOUT

DB2SWPARM-LKSUSPENS table field - Number of suspensions of all kinds

Description: Number of suspensions of all kinds
Field Name: LKSUSPENS
Data Element: DB2SWPSUSP
Data Type: DEC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC10V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LKSUSPENS

DB2SWPARM-LGLOGREAD table field - The number of log reads which had to access archive log DSs

Description: The number of log reads which had to access archive log DSs
Field Name: LGLOGREAD
Data Element: DB2SWPLOGR
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGLOGREAD

DB2SWPARM-LGLOGWWAIT table field - Number of log write waits

Description: Number of log write waits
Field Name: LGLOGWWAIT
Data Element: DB2SWPLGWW
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGLOGWWAIT

DB2SWPARM-LGLOGWRAT table field - Number of bytes in KB written for active log per sec

Description: Number of bytes in KB written for active log per sec
Field Name: LGLOGWRAT
Data Element: DB2SWPLGWR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGLOGWRAT

DB2SWPARM-EPFULL table field - Total number of failures due to EDM pool being full

Description: Total number of failures due to EDM pool being full
Field Name: EPFULL
Data Element: DB2SWPEPFL
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 EPFULL

DB2SWPARM-EPPGINUSE table field - Percentage of EDM pool pages currently in use

Description: Percentage of EDM pool pages currently in use
Field Name: EPPGINUSE
Data Element: DB2SWPPGIU
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EPPGINUSE

DB2SWPARM-OCDEFCLOSE table field - Datasets closed because deferred close threshold is reached

Description: Datasets closed because deferred close threshold is reached
Field Name: OCDEFCLOSE
Data Element: DB2SWPDEFC
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCDEFCLOSE

DB2SWPARM-OCCUROPEDS table field - Percentage of currently open datasets

Description: Percentage of currently open datasets
Field Name: OCCUROPEDS
Data Element: DB2SWPCODS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCCUROPEDS

DB2SWPARM-SSCOMMIT table field - The number of commits

Description: The number of commits
Field Name: SSCOMMIT
Data Element: DB2SWPCOMM
Data Type: DEC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC10V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SSCOMMIT

DB2SWPARM-SSROLLBACK table field - Number of rollbacks

Description: Number of rollbacks
Field Name: SSROLLBACK
Data Element: DB2SWPROLL
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 SSROLLBACK

DB2SWPARM-SSCHECKPNT table field - No. of checkpoints

Description: No. of checkpoints
Field Name: SSCHECKPNT
Data Element: DB2SWPCPNT
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 SSCHECKPNT

DB2SWPARM-SATOTALDML table field - Total number of Data Manipulation Language statements

Description: Total number of Data Manipulation Language statements
Field Name: SATOTALDML
Data Element: DB2SWPTDML
Data Type: DEC
length (Dec): 21(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC21V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SATOTALDML

DB2SWPARM-SATOTALDCL table field - Total number of Data Control Language statements

Description: Total number of Data Control Language statements
Field Name: SATOTALDCL
Data Element: DB2SWPTDCL
Data Type: DEC
length (Dec): 21(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC21V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SATOTALDCL

DB2SWPARM-SATOTALDDL table field - Total number of Data Definition Language statements

Description: Total number of Data Definition Language statements
Field Name: SATOTALDDL
Data Element: DB2SWPTDDL
Data Type: DEC
length (Dec): 21(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC21V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SATOTALDDL

DB2SWPARM-MCPARALRED table field - Degree of parallelism lower than planned

Description: Degree of parallelism lower than planned
Field Name: MCPARALRED
Data Element: DB2SWPPRED
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCPARALRED

DB2SWPARM-MCRIDLIST table field - Any of the RID list limits is reached

Description: Any of the RID list limits is reached
Field Name: MCRIDLIST
Data Element: DB2SWPRIDL
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCRIDLIST

DB2SWPARM-MCALTERCMD table field - Alter Bufferpool/Alter Group Bufferpool commands are issued

Description: Alter Bufferpool/Alter Group Bufferpool commands are issued
Field Name: MCALTERCMD
Data Element: DB2SWPACMD
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCALTERCMD

DB2SWPARM-MCSTARTTRC table field - Start Trace command was issued

Description: Start Trace command was issued
Field Name: MCSTARTTRC
Data Element: DB2SWPSTRC
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR05
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCSTARTTRC

DB2SWPARM-BPNAME table field - Selected buffer pool

Description: Selected buffer pool
Field Name: BPNAME
Data Element: DB2SWPBPNA
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BPNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPNAME

DB2SWPARM-LGBUFWRACT table field - Output log buffer writes per active log control interval

Description: Output log buffer writes per active log control interval
Field Name: LGBUFWRACT
Data Element: DB2SWPBWRA
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGBUFWRACT

DB2SWPARM-EPCTREQ table field - (CT requests - CT not in EDM pool) / CT requests

Description: (CT requests - CT not in EDM pool) / CT requests
Field Name: EPCTREQ
Data Element: DB2SWPCTR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EPCTREQ

DB2SWPARM-EPPTREQ table field - (PT requests - PT not in EDM pool) / PT requests

Description: (PT requests - PT not in EDM pool) / PT requests
Field Name: EPPTREQ
Data Element: DB2SWPPTR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EPPTREQ

DB2SWPARM-EPDBDREQ table field - (DBD requests - DBD not in EDM pool) / DBD requests

Description: (DBD requests - DBD not in EDM pool) / DBD requests
Field Name: EPDBDREQ
Data Element: DB2SWPDBDR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EPDBDREQ

DB2SWPARM-OCDSINUSE table field - Number of datasets currently in use

Description: Number of datasets currently in use
Field Name: OCDSINUSE
Data Element: DB2SWPDSIU
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCDSINUSE

DB2SWPARM-MAXKEEPEX table field - MAXKEEPD parameter exceeded

Description: MAXKEEPD parameter exceeded
Field Name: MAXKEEPEX
Data Element: DB2XSTDEXP
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXKEEPEX

DB2SWPARM-GCONTRATE table field - Global contention rate

Description: Global contention rate
Field Name: GCONTRATE
Data Element: DB2GCONRAT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GCONTRATE

DB2SWPARM-FCONTRATE table field - False contention rate

Description: False contention rate
Field Name: FCONTRATE
Data Element: DB2FCONRAT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FCONTRATE

DB2SWPARM-TLOPTRATE table field - Locking optimization rate

Description: Locking optimization rate
Field Name: TLOPTRATE
Data Element: DB2TLOPRAT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TLOPTRATE

DB2SWPARM-LGLOGSER table field - Number of log write I/O requests minus serial requests

Description: Number of log write I/O requests minus serial requests
Field Name: LGLOGSER
Data Element: DB2LOGSER
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGLOGSER

DB2SWPARM-LGARLOGWR table field - Number of control intervals offloaded to archive log(second)

Description: Number of control intervals offloaded to archive log(second)
Field Name: LGARLOGWR
Data Element: DB2ARLOGWR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGARLOGWR

DB2SWPARM-LGLOGLCR table field - Number of internal log latch contentions per second

Description: Number of internal log latch contentions per second
Field Name: LGLOGLCR
Data Element: DB2LOGLCR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGLOGLCR

DB2SWPARM-GBPREADMIS table field - Group buffer pool: # of pages returned on CF read request

Description: Group buffer pool: # of pages returned on CF read request
Field Name: GBPREADMIS
Data Element: DB2GBPREAD
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GBPREADMIS

DB2SWPARM-GBPWRITHIT table field - Group buffer pool: # of times a CF write request completed

Description: Group buffer pool: # of times a CF write request completed
Field Name: GBPWRITHIT
Data Element: DB2GBPWRIT
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GBPWRITHIT

DB2SWPARM-GBPSTOFAIL table field - GBP: Read/Write failures due to storage shortage

Description: GBP: Read/Write failures due to storage shortage
Field Name: GBPSTOFAIL
Data Element: DB2GBPFAIL
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2NUMC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GBPSTOFAIL

DB2SWPARM-LOCKESCAL table field - Total number of lock escalations

Description: Total number of lock escalations
Field Name: LOCKESCAL
Data Element: DB2LOCKESC
Data Type: DEC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DEC10V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKESCAL

DB2SWPARM-PAGEINS table field - Page-ins per pages read

Description: Page-ins per pages read
Field Name: PAGEINS
Data Element: DB2PAGEPR
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 PAGEINS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table