MXDGSTS outfile (WRKDG command) - assure_mimix - 10.0

Assure MIMIX Administrator Reference
Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2024
First publish date
1999
Last updated
2024-08-27
Published on
2024-08-27T12:04:03.662993

The MXDGSTS outfile contains status information which corresponds to fields available on the Work with Data Groups (WRKDG) command.

The Work with Data Groups (WRKDG) command generates new outfiles based on the MXDGSTSF record format from the MXDGSTS model database file supplied with MIMIX. The content of the outfile is based on the criteria specified on the command. If there are no data groups that match the criteria specified, the file is empty.

Usage notes: 

  • When the value *UNKNOWN is returned for either the Data group source system status (DTASRCSTS) field or the Data group target system status (DTATGTSTS), status information is not available from the system that is remote relative to where the request was made. For example, if you requested the report from the target system and the value returned for DTASRCSTS is *UNKNOWN, the WRKDG request could not communicate with the source system. Fields which rely on data collected from the remote system will be blank.

  • If a data group is configured for only database or only object replication, any fields associated with processes not used by the configured type of replication will be blank.

  • See WRKDG outfile SELECT statement examples for examples of how to query the contents of this output file.

  • You can automate the process of gathering status. If you use MIMIX Monitor to create a synchronous interval monitor, the monitor can specify the command to generate the outfile. Through exit programs, you can program the monitor to take action based on the status returned in the outfile. For information about creating interval monitors, see the Using MIMIX Monitor book.

    MXDGSTS outfile (WRKDG command)

    Field

    Description

    Type, length

    Valid values

    Column headings

    ENTRYTSP

    Entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    TIME REQUEST PROCESSED

    DGDFN

    Data group definition name (Data group definition)

    CHAR(10)

    User-defined data group name

    DGDFN NAME

    DGSYS1

    System 1 (Data group definition)

    CHAR(8)

    User-defined system name

    DGDFN SYSTEM 1

    DGSYS2

    System 2 (Data group definition)

    CHAR(8)

    User-defined system name

    DGDFN SYSTEM 2

    STSTIME

    Elapsed time for data group status (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    ELAPSED TIME

    STSTIMF

    Elapsed time for data group status (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-9999999

    ELAPSED TIME (HHH:MM:SS)

    STSAVAIL

    Data group status retrieved from these systems

    CHAR(10)

    *ALL, *SOURCE, *TARGET, *NONE

    SYS STATUS RETRIEVED FROM

    DTASRC

    Data group source system

    CHAR(8)

    User-defined system name

    DG SOURCE SYSTEM

    DTASRCSTS

    Data group source system status

    CHAR(10)

    *ACTIVE, *UNKNOWN

    DG SOURCE STATUS

    DTATGT

    Data group target system

    CHAR(8)

    User-defined system name

    DG TARGET SYSTEM

    DTATGTSTS

    Data group target system status

    CHAR(10)

    *ACTIVE, *UNKNOWN

    DG TARGET STATUS

    SWTSTS1

    Switch mode status for system 1

    CHAR(10)

    *NONE, *SWITCH

    SYSTEM 1 SWITCH STATUS

    SWTSTS2

    Switch mode status for system 2

    CHAR(10)

    *NONE, *SWITCH

    SYSTEM 2 SWITCH STATUS

    DGSTS

    Data group status summary

    CHAR(10)

    BLANK, *ERROR, *WARNING, *DISABLED

    OVERALL DG STATUS

    DBCFG

    Data group configured for data base replication

    CHAR(10)

    *YES, *NO

    CONFIGURED FOR DB REPLICATION

    OBJCFG

    Data group configured for object replication

    CHAR(10)

    *YES, *NO

    CONFIGURED FOR OBJECT REPLICATION

    SRCSYSSTS

    Source system manager status summation (system manager

    CHAR(10)

    *ACTIVE, *INACTIVE, *PARTIAL, *UNKNOWN

    SOURCE MANAGER SUMMATION

    DBSNDSTS

    Database send process status summation (DBSNDPRC)

    CHAR(10)

    *ACTIVE, *INACTIVE, *UNKNOWN, *NONE, *THRESHOLD

    DB SEND STATUS

    OBJSNDSTS

    Object send process status summation (OBJSNDPRC)

    CHAR(10)

    *ACTIVE, *INACTIVE, *UNKNOWN, *NONE, *THRESHOLD

    OBJECT SEND STATUS

    DTAPOLLSTS

    Data area polling process status (DTAPOLLPRC)

    CHAR(10)

    *NONE

    DATA AREA POLLER STATUS

    TGTSYSSTS

    Target System manager status summation (system manager plus journal manager status)

    CHAR(10)

    *ACTIVE, *INACTIVE, *PARTIAL, *UNKNOWN

    TARGET MANAGER SUMMATION

    DBAPYSTS

    Database apply status summation (Apply sessions A-F)

    CHAR(10)

    *ACTIVE, *INACTIVE, *PARTIAL,*VRTSWTTST, *THRESHOLD, *UNKNOWN, *NONE

    Note: Note:Access path maintenance, if used, is considered part of the database apply status. The value *PARTIAL in this field can indicate that DBAPY jobs are running, but access path maintenance jobs are not running. Check the value returned in the APMNTSTS field.

    DB APPLY SUMMATION

    OBJAPYSTS

    Object apply status summation

    CHAR(10)

    *ACTIVE, *INACTIVE, *PARTIAL, *VRTSWTTST, *THRESHOLD, *UNKNOWN, *NONE

    OBJECT APPLY SUMMATION

    FECNT

    Total database file entries

    PACKED(5 0)

    0-99999

    TOTAL DB FILE ENTRIES

    FEACTIVE

    Active database file entries (FEACT)

    PACKED(5 0)

    0-99999

    ACTIVE DB FILE ENTRIES

    FENOTACT

    Inactive database file entries

    PACKED(5 0)

    0-99999

    INACTIVE DB FILE ENTRIES

    FENOTJRNS

    Database file entries not journaled on source

    PACKED(5 0)

    0-99999

    FILES NOT JOURNALED ON SOURCE

    FENOTJRNT

    Database file entries not journaled on target

    PACKED(5 0)

    0-99999

    FILES NOT JOURNALED ON TARGET

    FEHLDERR

    Database file entries held due to error

    PACKED(5 0)

    0-99999

    FILES HELD FOR ERRORS

    FEHLDOTHR

    Database file entries held for other reasons (FEHLD)

    PACKED(5 0)

    0-99999

    FILES HELD FOR OTHER

    OBJPENDSRC

    Objects in pending status, source system

    PACKED(5 0)

    0-99999

    OBJECTS PENDING ON SOURCE SYSTEM

    OBJPENDAPY

    Objects in pending status, target system

    PACKED(5 0)

    0-99999

    OBJECTS PENDING ON TARGET SYSTEM

    OBJDELAY

    Objects in delayed status

    PACKED(5 0)

    0-99999

    TOTAL OBJECTS DELAYED

    OBJERR

    Objects in error

    PACKED(5 0)

    0-99999

    TOTAL OBJECTS IN ERROR

    DLOCFGCHG

    DLO configuration changed

    CHAR(10)

    *YES, *NO

    DLO CONFIG CHANGED

    IFSCFGCHG

    IFS configuration changed

    CHAR(10)

    *YES, *NO

    IFS CONFIG CHANGED

    OBJCFGCHG

    Object configuration changed

    CHAR(10)

    *YES, *NO

    OBJECT CONFIG CHANGED

    PRITFRDFN

    Primary transfer definition

    CHAR(10)

    User-defined transfer definition name

    PRIMARY TFRDFN

    SECTFRDFN

    Secondary transfer definition

    CHAR(10)

    User-defined transfer definition name

    SECONDARY TFRDFN

    TFRDFN

    Current transfer definition

    CHAR(10)

    User-defined transfer definition name

    LAST USED TFRDFN

    TFRSTS

    Current transfer definition communications status

    CHAR(10)

    *ACTIVE, *INACTIVE

    LAST USED TFRDFN STATUS

    SRCMGRSTS

    Source system manager status

    CHAR(10)

    *ACTIVE, *INACTIVE, *UNKNOWN

    SOURCE SYS MANAGER STATUS

    SRCJRNSTS

    Source journal manager status

    CHAR(10)

    *ACTIVE, *INACTIVE, *INACTASP, *JRNRCVCNT, *RCYASP, *UNKNOWN

    SOURCE JRN MANAGER STATUS

    CNRSNDSTS

    Container send process status

    CHAR(10)

    *ACTIVE, *INACTIVE, *PARTIAL, *UNKNOWN, *NONE, *THRESHOLD

    CONTAINER SEND STATUS

    OBJRTVSTS

    Object retrieve process status

    CHAR(10)

    *ACTIVE, *INACTIVE, *PARTIAL, *UNKNOWN, *NONE, *THRESHOLD

    OBJECT RETRIEVE STATUS

    TGTMGRSTS

    Target system manager status

    CHAR(10)

    *ACTIVE, *INACTIVE, *UNKNOWN

    TARGET SYS MANAGER STATUS

    TGTJRNSTS

    Target journal manager status

    CHAR(10)

    *ACTIVE, *INACTIVE, *INACTASP, *JRNRCVCNT, *RCYASP, *UNKNOWN

    TARGET JRN MANAGER STATUS

    CURDBRCV

    Current database journal entry receiver name

    CHAR(10)

    User-defined value

    DB JRNRCV

    CURDBLIB

    Current database journal entry receiver library name

    CHAR(10)

    User-defined value

    DB JRNRCV LIBRARY

    CURDBCODE

    Current database journal code and entry type

    CHAR(3)

    Valid journal entry types and codes

    DB ENTRY TYPE AND CODE

    CURDBSEQ

    Current database journal entry sequence number

    PACKED(10 0)

    0-9999999999

    DB ENTRY SEQUENCE

    CURDBTSP

    Current database journal entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    DB ENTRY TIMESTAMP

    CURDBTPH

    Current database journal entry transactions per hour

    PACKED(15 0)

    Calculated, 0-9999999999999

    DB ARRIVAL RATE

    RDDBRCV

    Last read database journal entry receiver name (DBSNTRCV)

    CHAR(10)

    User-defined value

    DB READER JRNRCV

    RDDBLIB

    Last read database journal entry receiver library name

    CHAR(10)

    User-defined value

    DB READER JRNRCV LIBRARY

    RDDBCODE

    Last read database journal code and entry type

    CHAR(3)

    Valid journal entry types and codes

    DB READER TYPE AND ENTRY CODE

    RDDBSEQ

    Last read database journal entry sequence number (DBSNTSEQ)

    PACKED(10 0)

    0-9999999999

    DB READER ENTRY SEQUENCE

    RDDBTSP

    Last read database journal entry timestamp (DBSNTDATE, DBSNTTIME)

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    DB READER ENTRY TIMESTAMP

    RDDBTPH

    Last read database journal entry transactions per hour

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB READER READ RATE

    DBSNDBKLG

    Number of database entries not sent

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB SEND BACKLOG

    DBSNBKTIME

    Estimated time to process database entries not sent (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    DB SEND BACKLOG SECONDS

    DBSNBKTIMF

    Estimated time to process database entries not sent (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-999:99:99

    DB SEND BACKLOG HHH:MM:SS

    RCVDBRCV

    Last received database journal entry receiver name

    CHAR(10)

    User-defined value

    DB LAST RECEIVED JRNRCV

    RCVDBLIB

    Last received database journal entry receiver library name

    CHAR(10)

    User-defined value

    DB LAST RECEIVED JRNRCV LIB

    RCVDBCODE

    Last received database journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal and entry types

    DB LAST RCV TPE AND ENTRY

    RCVDBSEQ

    Last received database journal entry sequence number

    PACKED(10 0)

    0-9999999999

    DB LAST RECEIVED SEQUENCE

    RCVDBTSP

    Last received database journal entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    DB LAST RECEIVED TIMESTAMP

    RCVDBTPH

    Last received database journal entry transactions per hour

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB RECEIVE ARRIVAL RATE

    DBAPYREQ

    Number of database apply sessions requested

    PACKED(5 0)

    1-6

    REQUESTED DB APPLY SESSIONS

    DBAPYMAX

    Number of database apply sessions configured

    PACKED(5 0)

    1-6

    CONFIGURED DB APPLY SESSIONS

    DBAPYACT

    Number of database apply session currently active (DBAPYPRC)

    PACKED(5 0)

    1-6

    ACTIVE DB APPLY SESSIONS

    DBAPYBKLG

    Number of database entries not applied

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB APPLY BACKLOG

    DBAPBKTIME

    Estimated time to process database entries not applied (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    DB APPLY TIME SECONDS

    DBAPBKTIMF

    Estimated time to process database entries not applied (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-999:99:99

    DB APPLY TIME HHH:MM:SS

    DBAPYTPH

    Database apply total transactions per hour

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB APPLY PROCESSING RATE

    DBASTS

    Database apply session A status

    CHAR(10)

    *ACTIVE, *INACTIVE, *VRTSWTTST, *THRESHOLD, *UNKNOWN

    DB APPLY A STATUS

    DBARCVSEQ

    Database apply session A last received sequence number

    PACKED(10 0)

    0-9999999999

    DB APPLY A LAST RECEIVED

    DBAPRCSEQ

    Database apply session A last processed sequence number

    PACKED(10 0)

    0-9999999999

    DB APPLY A LAST PROCESSED

    DBABKLG

    Database apply session A number of unprocessed entries

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB APPLY A BACKLOG

    DBABKTIME

    Database apply session A estimated time to apply unprocessed transactions (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    DB APPLY A TIME SECONDS

    DBABKTIMF

    Database apply session A estimated time to apply unprocessed transactions (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-999:99:99

    DB APPLY A TIME HHH:MM:SS

    DBATPH

    Database apply session A number of transactions per hour

    PACKED(15 0)

    Calculated, 0-999999999999999

    DB APPLY A PROCESSING RATE

    DBAOPNCMT

    Database apply session A open commit indicator

    CHAR(10)

    *YES, *NO, *DLK

    DB APPLY A COMMIT INDICATOR

    DBACMTID

    Database apply session A oldest open commit ID

    CHAR(10)

    Journal-defined commit ID

    DB APPLY A CURRENT COMMIT ID

    DBAAPYCODE

    Database apply session A last applied journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal codes and entry types.

    DB APPLY A TYPE AND ENTRY

    DBAAPYSEQ

    Database apply session A last applied sequence number

    PACKED(10 0)

    0-9999999999

    DB APPLY A LAST APPLIED

    DBAAPYTSP

    Database apply session A last applied journal entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    DB APPLY A LAST TIMESTAMP

    DBAAPYOBJ

    Database apply session A object to which last transaction was applied

    CHAR(10)

    User-defined object name

    DB APPLY A OBJECT NAME

    DBAAPYLIB

    Database apply session A library of object to which last transaction was applied

    CHAR(10)

    User-defined object library name

    DB APPLY A LIBRARY NAME

    DBAAPYMBR

    Database apply session A member of object to which last transaction was applied.

    CHAR(10)

    User-defined object member name

    DB APPLY A MEMBER NAME

    DBAAPYTIME

    Database apply session A last applied journal entry clock time difference (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    DB APPLY A TIME DIFF SECONDS

    DBAAPYTIMF

    Database apply session A last applied journal entry clock time difference (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-999:99:99

    DB APPLY A TIME DIFF HHH:MM:SS

    DBAHLDSEQ

    Database apply session A hold MIMIX log sequence number

    PACKED(10 0)

    0-9999999999

    DB APPLY A HOLD SEQUENCE

    DBxSTS through DBxHLDSEQ, where x is  database apply session ‘B’ - ‘F’

    Reserved for up to 5 additional database apply sessions (‘B’ - ‘F’). Contains fields for each additional apply session which correspond to fields for apply session A (DBASTS through DBAHLDSEQ.

    885 bytes (5 x 177)

    All DBx field values match the DBA field values.

    All DBx headings match the DBA headings, with ‘x’

    CUROBJRCV

    Current object journal entry receiver name

    CHAR(10)

    User-defined value

    OBJECT JRNRCV

    CUROBJLIB

    Current object journal entry receiver library name

    CHAR(10)

    User-defined value

    OBJECT JRNRCV LIBRARY

    CUROBJCODE

    Current object journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal codes and entry types.

    OBJECT TYPE AND ENTRY CODES

    CUROBJSEQ

    Current object journal entry sequence number

    PACKED(10 0)

    0-9999999999

    OBJECT JOURNAL SEQUENCES

    CUROBJTSP

    Current object journal entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    OBJECT JRN ENTRY TIMESTAMP

    CUROBJTPH

    Current object journal entry transactions per hour

    PACKED(15 0)

    0-999999999999999

    OBJECT ARRIVAL PER HOUR

    RDOBJRCV

    Last read object journal entry receiver name (OBJSNTRCV)

    CHAR(10)

    User-defined value

    OBJRDRPRC JRNRCV

    RDOBJLIB

    Last read object journal entry receiver library name

    CHAR(10)

    User-defined value

    OBJRDRPRC JRNRCV LIBRARY

    RDOBJCODE

    Last read object journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal entry codes and entry types.

    OBJRDRPRC TYPE AND ENTRY CODE

    RDOBJSEQ

    Last read object journal entry sequence number (OBJSNTSEQ)

    PACKED(10 0)

    0-9999999999

    OBJRDRPRC JOURNAL SEQUENCE

    RDOBJTSP

    Last read object journal entry timestamp (OBJSNTDATE, OBJSNTTIME)

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    OBJRDRPRC JRN ENTRY TIMESTAMP

    RDOBJTPH

    Last read object journal entry transactions per hour

    PACKED(15 0)

    Calculated, 0-999999999999999

    OBJRDRPRC READ RATE

    OBJSNDBKLG

    Object entries not processed

    PACKED(15 0))

    Calculated, 0-999999999999999

    OBJSNDPRC BACKLOG

    OBJSNDNUM

    Number of object entries sent

    PACKED(15 0))

    Calculated, 0-999999999999999

    OBJSNDPRC SENT IN TIME SLICE

    OBJSBKTIME

    Estimated time to process object entries not sent (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    OBJSNDPRC BACKLOG SECONDS

    OBJSBKTIMF

    Estimated time to process entries not sent (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-999:99:99

    OBJSNDPRC BACKLOG HHH:MM:SS

    RCVOBJRCV

    Last received object journal entry receiver name

    CHAR(10)

    User-defined value

    OBJRCVPRC LAST RCVD JRNRCV

    RCVOBJLIB

    Last received object journal entry receiver library name

    CHAR(10)

    User-defined value

    OBJRCVPRC LAST RCVD JRNRCV LIB

    RCVOBJCODE

    Last received object journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal codes and entry types.

    OBJRCVPRC LAST TYPE AND ENTRY

    RCVOBJSEQ

    Last received object journal entry sequence number

    PACKED(10 0)

    0-9999999999

    OBJRCVPRC LAST ENTRY SEQUENCE

    RCVOBJTSP

    Last received object journal entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    OBJRCVPRC LAST ENTRY TIMESTAMP

    RCVOBJTPH

    Last received object journal entry transactions per hour

    PACKED(15 0)

    0-999999999999999

    OBJRCVPRC RECEIVE RATE

    OBJRTVMIN

    Minimum number of object retriever processes

    PACKED(3 0)

    1-99

    OBJRTVPRC MIN NUMBER OF JOBS

    OBJRTVACT

    Active number of object retriever processes (OBJRTVPRC)

    PACKED(3 0)

    1-99

    OBJRTVPRC NUMBER OF JOBS

    OBJRTVMAX

    Maximum number of object retriever processes

    PACKED(3 0)

    1-99

    OBJRTVPRC MAX NUMBER OF JOBS

    OBJRTVBKLG

    Number of object retriever entries not processed

    PACKED(15 0)

    0-999999999999999

    OBJRTVPRC BACKLOG

    OBJRTVCODE

    Last processed object retrieve journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal codes and entry types.

    OBJRTVPRC LAST TYPE AND ENTRY

    OBJRTVSEQ

    Last processed object retrieve journal sequence number

    PACKED(10 0)

    0-9999999999

    OBJRTVPRC LAST SEQUENCE

    OBJRTVTSP

    Last processed object retrieve journal entry timestamp (OBJRTVDATE, OBJRTVTIME)

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    OBJRTVPRC LAST TIMESTAMP

    OBJRTVTYPE

    Type of object last processed by object retrieve

    CHAR(10)

    Object type of user-defined object

    OBJRTVPRC LAST OBJ TYPE

    OBJRTVOBJ

    Qualified name of object last processed by object retrieve

    CHAR(1024)

    User-defined object name and path

    Note: Note:Variable length of 75.

    OBJRTVPRC LAST OBJ NAME

    CNRSNDMIN

    Minimum number of container send processes

    PACKED(3 0)

    1-99

    CNRSNDPRC MIN NUMBER OF JOBS

    CNRSNDACT

    Active number of container send processes (CNRSNDPRC)

    PACKED(3 0)

    1-99

    CNRSNDPRC NUMBER OF JOBS

    CNRSNDMAX

    Maximum number of container send processes

    PACKED(3 0)

    1-99

    CNRSNDPRC MAX NUMBER OF JOBS

    CNRSNDBKLG

    Number of container send entries not processed

    PACKED(15 0)

    0-999999999999999

    CNRSNDPRC BACKLOG

    CNRSNDNUM

    Number of containers sent

    PACKED(15 0)

    0-999999999999999

    CNRSNDPRC NUMBER SENT

    CNRSNDCPH

    Containers per hour

    PACKED(15 0)

    0-999999999999999

    CNRSNDPRC RATE

    CNRSNDCODE

    Last processed container send journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal codes and entry types.

    CNRSNDPRC LAST TYPE AND ENTRY

    CNRSNDSEQ

    Last processed container send journal sequence number (CNRSNTSEQ)

    PACKED(10 0)

    0-9999999999

    CNRSNDPRC LAST SEQUENCE

    CNRSNDTSP

    Last processed container send journal entry timestamp (CNRSNTDATE, CNTRSNTTIME)

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    CNRSNDPRC LAST TIMESTAMP

    CNRSNDTYPE

    Type of object last processed by container send

    CHAR(10)

    Object type of user-defined object

    CNRSNDPRC LAST OBJ TYPE

    CNRSNDOBJ

    Qualified name of object last processed by container send

    CHAR(1024)

    User-defined object name and path

    Note: Variable length of 75.

    CNRSNDPRC LAST OBJ NAME

    OBJAPYMIN

    Minimum number of object apply processes

    PACKED(3 0)

    1-99

    OBJAPYPRC MIN NUMBER OF JOBS

    OBJAPYACT

    Active number of object apply processes (OBJAPYPRC)

    PACKED(3 0)

    1-99

    OBJAPYPRC NUMBER OF JOBS

    OBJAPYMAX

    Maximum number of object apply processes

    PACKED(3 0)

    1-99

    OBJAPYPRC MAX NUMBER OF JOBS

    OBJAPYBKLG

    Number of object apply entries not processed

    PACKED(15 0)

    Calculated, 0-999999999999999

    OBJAPYPRC BACKLOG

    OBJAPYACTA

    Number of active objects

    PACKED(15 0)

    Calculated, 0-999999999999999

    OBJAPYPRC ACTIVE BACKLOG

    OBJAPYNUM

    Number of object entries applied

    PACKED(15 0)

    Calculated, 0-999999999999999

    OBJAPYPRC APPLIED IN TIME SLICE

    OBJABKTIME

    Estimated time to process object entries not applied (seconds)

    PACKED(10 0)

    Calculated, 0-9999999999

    OBJAPYPRC BACKLOG SECONDS

    OBJABKTIMF

    Estimated time to process object entries not applied (HHH:MM:SS)

    CHAR(10)

    Calculated, 0-999:99:99

    OBJAPYPRC BACKLOG HHH:MM:SS

    OBJAPYTPH

    Number of object entries applied per hour

    PACKED(15 0)

    Calculated, 0-999999999999999

    OBJAPYPRC RATE

    OBJAPYCODE

    Last applied object journal code and entry type

    CHAR(3)

    See the IBM OS/400 Backup and Recovery Guide for journal codes and entry types.

    OBJAPYPRC LAST TYPE AND ENTRY

    OBJAPYSEQ

    Last applied object journal sequence number (OBJAPYSEQ)

    PACKED(10 0)

    0-9999999999

    OBJAPYPRC LAST SEQUENCE

    OBJAPYTSP

    Last applied object journal entry timestamp (OBJAPYDATE, OBJAPYTIME)

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    OBJAPYPRC LAST TIMESTAMP

    OBJAPYTYPE

    Type of object last processed by object apply

    CHAR(10)

    Object type of user-defined object

    OBJAPYPRC LAST OBJ TYPE

    OBJAPYOBJ

    Qualified name of object last processed by object apply

    CHAR(1024)

    User-defined object name and path

    Note: Variable length of 75.

    OBJAPYPRC LAST OBJ NAME

    RJINUSE

    Remote journal (RJ) link used by data group

    CHAR(10)

    *YES, *NO

    RJ LINK USED BY DG

    RJSRCDFN

    RJ link source journal definition

    CHAR(10)

    User-defined journal definition name

    RJ LINK SOURCE JRNDFN

    RJSRCSYS

    RJ link source system

    CHAR(8)

    User-defined system name

    RJ LINK SOURCE JRNDFN

    RJTGTDFN

    RJ link target journal definition

    CHAR(10)

    User-defined journal definition name

    RJ LINK TARGET SYSTEM

    RJTGTSYS

    RJ link target system

    CHAR(8)

    User-defined system name

    RJ LINK TARGET JRNDFN

    RJPRIRDB

    RJ link primary RDB entry

    CHAR(18)

    User-defined or MIMIX generated RDB name

    RJ PRIMARY RDB ENTRY

    RJPRITFR

    RJ link primary transfer definition name

    CHAR(10)

    User-defined transfer definition name

    RJ PRIMARY TFRDFN

    RJSECRDB

    RJ link secondary RDB entry

    CHAR(18)

    User-defined or MIMIX generated RDB name

    RJ SECONDARY RDB ENTRY

    RJSECTFR

    RJ link secondary transfer definition name

    CHAR(10)

    User-defined transfer definition name

    RJ SECONDARY TFRDFN

    RJSTATE

    RJ link state

    CHAR(10)

    BLANK, *FAILED, *CTLINACT, *INACTPEND, *ASYNC, *SYNC, *ASYNPEND, *SYNCPEND, *NOTBUILT, *UNKNOWN

    RJ LINK STATE

    RJDLVRY

    RJ link delivery mode

    CHAR(10)

    *ASYNC, *SYNC, BLANK

    RJ LINK DELIVERY MODE

    RJSNDPTY

    RJ link send task priority

    PACKED(3 0)

    0-99 0=*SYSDFT

    RJ LINK SEND PRIORITY

    RJRDRSTS

    RJ reader task status

    CHAR(10)

    BLANK, *UNKNOWN, *ACTIVE, *INACTIVE, *THRESHOLD

    RJREADER STATUS

    RJSMONSTS

    RJ link source monitor status

    CHAR(10)

    BLANK, *UNKNOWN, *ACTIVE, *INACTIVE

    RJ SOURCE MONITOR

    RJTMONSTS

    RJ link target monitor status

    CHAR(10)

    BLANK, *UNKNOWN, *ACTIVE, *INACTIVE

    RJ TARGET MONITOR

    ITECNT

    Total IFS tracking entries

    PACKED(10 0)

    0-999999

    TOTAL IFS TRACKING ENTRIES

    ITEACTIVE

    Active IFS tracking entries

    PACKED(10 0)

    0-999999

    ACTIVE IFS TRACKING ENTRIES

    ITENOTACT

    Inactive IFS tracking entries

    PACKED(10 0)

    0-999999

    INACT IFS TRACKING ENTRIES

    ITENOTJRNS

    IFS tracking entries not journaled on source

    PACKED(10 0)

    0-999999

    IFS TE NOT JOURNALED ON SOURCE

    ITENOTJRNT

    IFS tracking entries not journaled on target

    PACKED(10 0)

    0-999999

    IFS TE NOT JOURNALED ON TARGET

    ITEHLDERR

    IFS tracking entries held due to error

    PACKED(10 0)

    0-999999

    IFS TE HELD FOR ERRORS

    ITEHLDOTHR

    IFS tracking entries held for other reasons

    PACKED(10 0)

    0-999999

    IFS TE HELD FOR OTHER

    OTECNT

    Total object tracking entries

    PACKED(10 0)

    0-999999

    TOTAL OBJ TRACKING ENTRIES

    OTEACTIVE

    Active object tracking entries

    PACKED(10 0)

    0-999999

    ACTIVE OBJ TRACKING ENTRIES

    OTENOTACT

    Inactive object tracking entries

    PACKED(10 0)

    0-999999

    INACT OBJ TRACKING ENTRIES

    OTENOTJRNS

    Object tracking entries not journaled on source

    PACKED(10 0)

    0-999999

    OBJ TE NOT JOURNALED ON SOURCE

    OTENOTJRNT

    Object tracking entries not journaled on target

    PACKED(10 0)

    0-999999

    OBJ TE NOT JOURNALED ON TARGET

    OTEHLDERR

    Object tracking entries held due to error

    PACKED(10 0)

    0-999999

    OBJ TE HELD FOR ERRORS

    OTEHLDOTHR

    Object tracking entries held for other reasons

    PACKED(10 0)

    0-999999

    OBJ TE HELD FOR OTHER

    JRNCACHETA

    Journal cache target

    CHAR(10)

    *YES, *NO, *UNKNOWN

    JOURNAL CACHE TARGET

    JRNCACHESA

    Journal cache source

    CHAR(10)

    *YES, *NO, *UNKNOWN

    JOURNAL CACHE SOURCE

    JRNSTATETA

    Journal state target

    CHAR(10)

    *ACTIVE, *STANDBY, *INACTIVE

    JOURNAL STATE TARGET

    JRNSTATESA

    Journal state source

    CHAR(10)

    *ACTIVE, *STANDBY, *INACTIVE

    JOURNAL STATE SOURCE

    JRNCACHETS

    Journal cache status - target

    CHAR(10)

    *ERROR, *NONE, *OK, *WARNING, *NOFEATURE, *UNKNOWN

    JRN CACHE TARGET STATUS

    JRNCACHESS

    Journal cache status - source

    CHAR(10)

    *ERROR, *NONE, *OK, *WARNING, *NOFEATURE, *UNKNOWN

    JRN CACHE SOURCE STATUS

    JRNSTATETS

    Journal state target status

    CHAR(10)

    *ERROR, *NONE, *OK, *WARNING, *NOFEATURE, *UNKNOWN

    JOURNAL STATE TARGET

    JRNSTATESS

    Journal state source status

    CHAR(10)

    *ERROR, *NONE, *OK, *WARNING, *NOFEATURE, *UNKNOWN

    JOURNAL STATE SOURCE

    RJTGTRCV

    Last RJ target journal entry receiver name

    CHAR(10)

    User-defined value

    RJ TGT JRNRCV

    RJTGTLIB

    Last RJ target journal entry receiver library name

    CHAR(10)

    User-defined value

    RJ TGT JRNRCV LIBRARY

    RJTGTCODE

    Last RJ target journal code and entry type

    CHAR(3)

    Valid journal entry types and codes

    RJTGT TYPE AND ENTRY CODE

    RJTGTSEQ

    Last RJ target journal entry sequence number

    PACKED(10 0)

    0-9999999999

    RJ TGT ENTRY SEQUENCE

    RJTGTTSP

    Last RJ target journal entry timestamp

    TIMESTAMP

    SAA format:  YYYY-MM-DD-hh.mm.ss.mmmuuu

    RJ TGT ENTRY TIMESTAMP

    OBJRTVUCS

    Qualified name of object last qualified by object retrieve - Unicode

    GRAPHIC(512) VARLEN(75) CCSID(13488)

    User-defined object name and path

    LAST OBJ RETRIEVED (UNICODE)

    CNRSNDUCS

    Qualified name of object last qualified by container send - Unicode

    GRAPHIC(512) VARLEN(75) CCSID(13488)

    User-defined object name and path

    LAST OBJ SENT (UNICODE)

    OBJAPYUCS

    Qualified name of object last qualified by object apply - Unicode

    GRAPHIC(512) VARLEN(75) CCSID(13488)

    User-defined object name and path

    LAST OBJ APPLIED (UNICODE)

    FECNT2

    Total database file entries

    PACKED(10 0)

    0-9999999999

    TOTALDB FILE ENTRIES2

    FEACTIVE2

    Active database file entries (FEACT)

    PACKED(10 0)

    0-9999999999

    ACTIVEDB FILE ENTRIES2

    FENOTACT2

    Inactive database file entries

    PACKED(10 0)

    0-9999999999

    INACTIVEDB FILE ENTRIES2

    FENOTJRNS2

    Database file entries not journaled on source

    PACKED(10 0)

    0-9999999999

    FILES NOT JOURNALED ON SOURCE2

    FENOTJRNT2

    Database file entries not journaled on target

    PACKED(10 0)

    0-9999999999

    FILES NOT JOURNALED ON TARGET2

    FEHLDERR2

    Database file entries held due to error

    PACKED(10 0)

    0-9999999999

    FILESHELD FOR ERRORS2

    FEHLDOTHR2

    Database file entries held for other reasons (FEHLD)

    PACKED(10 0)

    0-9999999999

    FILES HELD FOR OTHERS2

    FECMPRPR2

    Database file entries being repaired

    PACKED(10 0)

    0-9999999999

    FILESBEING REPAIRED2

    RJLNKTHLDM

    RJ Link Threshold Exceeded (Time in minutes)

    PACKED(4 0)

    0-9999

    RJLNK THRESHOLD (TIME IN MIN)

    RJLNKTHLDE

    RJ Link Threshold Exceeded (Number of journal entries)

    PACKED(7 0)

    0-9999999

    RJLNK THRESHOLD (NBR OF JRNE)

    DBRDRTHLDM

    DB Send/Reader Threshold Exceeded (Time in minutes)

    PACKED(4 0)

    0-9999

    DBSND/DBRDR THRESHOLD (TIME IN MIN)

    DBRDRTHLDE

    DB Send/Reader Threshold Exceeded (Number of journal entries)

    PACKED(7 0)

    0-9999999

    DBSND/DBRDR THRESHOLD (NBR OF JRNE)

    DBAPYATHLD

    DB Apply A Threshold Exceeded (Number of journal entries)

    PACKED(5 0)

    0-99999

    DB APPLY A THRESHOLD

    DBAPYBTHLD

    DB Apply B Threshold Exceeded (Number of journal entries)

    PACKED(5 0)

    0-99999

    DB APPLY B THRESHOLD

    DBAPYCTHLD

    DB Apply C Threshold Exceeded (Number of journal entries)

    PACKED(5 0)

    0-99999

    DB APPLY C THRESHOLD

    DBAPYDTHLD

    DB Apply D Threshold Exceeded (Number of journal entries)

    PACKED(5 0)

    0-99999

    DB APPLY D THRESHOLD

    DBAPYETHLD

    DB Apply E Threshold Exceeded (Number of journal entries)

    PACKED(5 0)

    0-99999

    DB APPLY E THRESHOLD

    DBAPYFTHLD

    DB Apply F Threshold Exceeded (Number of journal entries)

    PACKED(5 0)

    0-99999

    DB APPLY F THRESHOLD

    OBJSNDTHDM

    Object Send Threshold Exceeded (Time in minutes)

    PACKED(4 0)

    0-9999

    OBJSND THRESHOLD (TIME IN MIN)

    OBJSNDTHDE

    Object Send Threshold Exceeded (Number of journal entries)

    PACKED(7 0)

    0-9999999

    OBJSND THRESHOLD (NBR OF JRNE)

    OBJRTVTHDE

    Object Retrieve Threshold Exceeded (Number of activity entries)

    PACKED(5 0)

    0-99999

    OBJRTV THRESHOLD

    CNRSNDTHDE

    Container Send Threshold Exceeded (Number of activity entries)

    PACKED(5 0)

    0-99999

    CNRSND THRESHOLD

    OBJAPYTHDE

    Object Apply Threshold Exceeded (Number of activity entries)

    PACKED(5 0)

    0-99999

    OBJAPY THRESHOLD

    RJBKLG

    RJ Backlog

    PACKED(15 0)

    Calculated 0-999999999999

    RJ BACKLOG

    CURDBSEQ2

    Current database journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB ENTRY LARGE SEQUENCE

    RDDBSEQ2

    Last read database journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB READER ENTRY LARGE SEQUENCE

    RCVDBSEQ2

    Last received database journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB LAST RECEIVED LARGE SEQUENCE

    DBARCVSEQ2

    Database apply session A last received large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB APPLY A LAST RECEIVED LARGE SEQUENCE

    DBAPRCSEQ2

    Database apply session A last processed large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB APPLY A LAST PROCESSED LARGE SEQUENCE

    DBACMTID2

    Database apply session A oldest open large commit ID

    CHAR(20)

    0-99999999999999999999  (twenty 9s)

    DB APPLY A CURRENT LARGE COMMIT ID

    DBAAPYSEQ2

    Database apply session A last applied large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB APPLY A LAST APPLIED LARGE SEQUENCE

    DBAHLDSEQ2

    Database apply session A hold MIMIX log large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    DB APPLY A HOLD LARGE SEQUENCE

    DBxRCVSEQ2 through DBxHLDSEQ2 where x is  database apply session ‘B’ - ‘F’

    Reserved for up to 5 additional database apply sessions (‘B’ - ‘F’). Contains fields for each additional apply session which correspond to fields for apply session A DBARCVSEQ2 through DBAHLDSEQ2

    600 bytes (5 x 120)

    All DBx field values match the DBA field values.

    All DBx headings match the DBA headings, with ‘x’

    CUROBJSEQ2

    Current object journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    OBJECT JOURNAL LARGE SEQUENCE

    RDOBJSEQ2

    Last read object journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    OBJRDRPRC JOURNAL LARGE SEQUENCE

    RCVOBJSEQ2

    Last received object journal entry large  sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    OBJRCVPRC LAST ENTRY LARGE SEQUENCE

    OBJRTVSEQ2

    Last processed object retrieve journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    OBJRTVPRC LAST ENTRY LARGE SEQUENCE

    CNRSNDSEQ2

    Last processed container send journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    CNRSNDPRC LAST ENTRY LARGE SEQUENCE

    OBJAPYSEQ2

    Last applied object journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    OBJAPYPRC LAST ENTRY LARGE SEQUENCE

    RJTGTSEQ2

    Last RJ target journal entry large sequence number

    ZONED(20 0)

    0-99999999999999999999  (twenty 9s)

    RJ TARGET LAST ENTRY LARGE SEQUENCE

    PRLAPMNTST

    Parallel Access Path Maintenance Status

    CHAR(10)

    *NONE

    PARALLEL AP MAINT STATUS

    OBJSNDPFX

    Object send prefix

    CHAR(10)

    name, *DGDFN, *SHARED

    OBJECT SEND PREFIX

    APMNTSTS

    Access path maintenance job status

    CHAR(10)

    *NONE, *UNKNOWN, *ACTIVE, *INACTIVE, *VRTSWTTST

    AP MAINT STATUS

    APMNTERR

    Access path maintenance error count

    PACKED (5 0)

    0-99999

    AP MAINT ERROR COUNT

    FERCYCNT

    File entry recovery count (new/in-progress)

    PACKED(5 0)

    0-99999

    FILE ENTRY RCY COUNT

    ITERCYCNT

    IFS tracking entry recovery count (new/in-progress)

    PACKED(5 0)

    0-99999

    IFS TE RCY COUNT

    OTERCYCNT

    Object tracking entry recovery count (new/in-progress)

    PACKED(5 0)

    0-99999

    OBJ TE RCY COUNT

    CMTJOBNAME

    Job Name with open commit causing deadlock

    CHAR(10)

    job name, blanks if not deadlocked

    COMMIT JOB NAME

    CMTJOBUSER

    Job User with open commit causing deadlock

    CHAR(10)

    job user, blanks if not deadlocked

    COMMIT JOB USER

    CMTJOBNUM

    Job Number with open commit causing deadlock

    CHAR(6)

    job number, blanks if not deadlocked

    COMMIT JOB NUMBER

    JRNANZREQ

    Journal analysis required after unplanned switch

    CHAR(10

    *NO, *YES

    JRN ANZ REQUIRED

    RCYPCYDSB

    Recovery policies disabled after unplanned switch

    CHAR(10

    *NO, *YES

    RECOVERY POLICIES DISABLED

    STSSNDSTS

    Status send process status

    CHAR(10)

    *ACTIVE, *INACTIVE, *UNKNOWN, *NONE

    STATUS SEND STATUS

    DBAPYTHD

    Database apply multithreaded process status

    CHAR(10)

    *NONE, *UNKNOWN, *ACTIVE, *INACTIVE, *VRTSWTTST

    DBAPY THREADING PROCESS

    FERCYFAIL

    File entry recovery count (failed)

    PACKED(5 0)

    0-99999

    FILE ENTRY RCY FAIL COUNT

    ITERCYFAIL

    IFS tracking entry recovery count (failed)

    PACKED(5 0)

    0-99999

    IFS TE RCY FAIL COUNT

    OTERCYFAIL

    Object tracking entry recovery count (failed)

    PACKED(5 0)

    0-99999

    OBJ TE RCY FAIL COUNT

    REPJOBIND

    Replicated job analysis required after switch

    CHAR(10)

    *NO, *YES

    REPLICATED JOB ANALYSIS