SAP Table DB4DBMACTP

iSeries: Database Monitor Activity per Process (DB Jobs)

DB4DBMACTP (iSeries: Database Monitor Activity per Process (DB Jobs)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DB4DBMACTP to other SAP tables.

Source: DB4DBMACTP (iSeries: Database Monitor Activity per Process (DB Jobs))

DB4DBMACTP table fields

Field Data element Checktable Datatype Length Decimals
INSTANCE Server Name MSNAME CHAR 20 0
JOBNUM iSeries: Job Number (Database Monitor) QQJNUM CHAR 6 0
JOBUSER iSeries: Job User (Database Monitor) QQUSER CHAR 10 0
JOBNAME iSeries: Job Name (Database Monitor) QQJOB CHAR 10 0
DBMONACT iSeries: Active Database Monitor for a Database Shadow Job QQDBMACT INT4 10 0
0 Job is not monitored
1 File based DB Monitor (STRDBMON/ENDDBMON) is active
2 Memory based DB Monitor is active
3 File based AND memory based DB Monitor active
DBMHANDLE iSeries: Memory Handle Used for Memory ResidnetnDBMonitor DBMHANDLE CHAR 6 0
STGUSED iSeries: Storage Used for Memory Based Database Monitor QQSTGUSE INT4 10 0
PARM_SHM iSeries: Value of Profile Parameter as4/dbmon/enable DB4DBM_EN CHAR 25 0
PARM_IFS iSeries: Value of Profile Parameter as4/dbmon/enable DB4DBM_EN CHAR 25 0