Using the Central Component › Export Central Component Data › Export Alerts - Job APCXJEXP

Previous Topic: Export Job Information - Job APCBJEXP

Next Topic: Print Alert Text

Export Alerts - Job APCXJEXP

To export alerts from the database, use job APCXJEXP. This job creates a list or a file that can be exported for use in other systems, for example, EXCEL, SAS. The alerts are exported from the alert database to a sequential file that can be used in other mainframe systems or file transferred to the PC. 

//JOBCARD...
//********************************************************************
//* PMA: APCXJEXP                                                    *
//* MAINTENANCE: PMA TEAM                                            *
//* ACTION:      EXPORT ALERT INFO FROM PMA DATA BASE                *
//*              FOR JOBSTEPS, CICS OR IMS TRANSACTIONS              *
//* FUNCTION:    LIST OR EXPORT FILE WILL BE CREATED                 *
//*------------------------------------------------------------------*
//* COPYRIGHT (C) 2011 CA. All Rights Reserved.                      *
//* Copyright (C) Trilog AG                                          *
//********************************************************************
//APCXATAB EXEC PGM=APCXATAB
//STEPLIB  DD   DISP=SHR,
//              DSN=prefix.PMA.LOAD
//APCIN    DD   DISP=SHR,
//              DSN=prefix.PMA.CNTL(APCXCAEX)
//APCBALT1 DD   DISP=SHR,
//              DSN=prefix.PMA.KSDSALT
//APCTAB   DD   SYSOUT=*
//APCEREP  DD   SYSOUT=*

To assist you in using this alert information after it has reached its destination, the following record description is provided. The field delimiter is a semicolon.

Field Contents for Transaction Alert

Length

Field Contents for Job Alert

Length

Transaction name

8

Job name

8

PMA system control name

8

Step name

8

Alert ID

5

Procedure step

8

Creation date (yyyy-mm-dd)

10

Alert ID no.

5

Job name of the region

8

Alert creation date (yyyy-mm-dd)

10

State code

4

Program name

8

Reason code

4

Link date of program (yyyy-mm-dd)

10

Average CPU time percentage

6

Alert state code

4

Measured CPU percentage

6

Alert reason code

4

Average number of measurements

5

 

 

The following is an example of a transaction alert export record:

X-NAME !SYS-NAME!ALT-#!CR-DATE   !JOBNAME !STAT!FROM!AV CPU!ME CPU!MEAS#!
--------+--------+-----+----------+--------+----+----+------+------+-----+
OKD07900;IMS     ;17682;2011-01-15;IMSZZ001;OPEN;STAT;   .39;  1.69;  165;