Using the Central Component › Export Central Component Data › Export Job Information - Job APCBJEXP

Previous Topic: Export Central Component Data

Next Topic: Export Alerts - Job APCXJEXP

Export Job Information - Job APCBJEXP

To export information from the database, use job APCBJEXP. This job creates a list or a file that can be exported for use in other systems; for example, Microsoft EXCEL, or SAS. The data is exported from the database to a sequential file that can be used in other mainframe systems or file transferred to the PC. 

//JOBCARD
//********************************************************************
//* PMA: APCBJEXP                                                    *
//* MAINTENANCE: PMA TEAM                                            *
//* ACTION:      EXPORT JOB INFO FROM PMA DATA BASE                  *
//* FUNCTION:    LIST OR EXPORT FILE WILL BE CREATED                 *
//*------------------------------------------------------------------*
//* COPYRIGHT (C) 2011 CA. All Rights Reserved.                      *
//* Copyright (C) Trilog AG                                          *
//********************************************************************
//APCBATAB EXEC PGM=APCBATAB
//STEPLIB  DD   DISP=SHR,DSN=prefix.PMA.LOAD
//APCIN    DD   DISP=SHR,DSN=prefix.PMA.CNTL(APCBCJEX)
//APCTAB   DD   SYSOUT=*
//APCEREP  DD   SYSOUT=*
//APCBJOB1 DD   DISP=SHR,
//              DSN=prefix.PMA.KSDSJOB
//APCBALT1 DD   DISP=SHR,
//              DSN=prefix.PMA.KSDSALT
//APCBBPM1 DD   DISP=SHR,
//              DSN=prefix.PMA.KSDSBPM

To assist you in using this job information after it has reached its destination, the following record description is provided. Each field of the record is separated by a semicolon delimiter.

Field Contents for Job Information Export

Length

Job name

8

Step name

8

Procedure step

8

Program name

8

Application program

8

Number of runs

5

Condition code exceptions

4

Number of measurements

4

Most recent alert state

2

Consumed elapsed time - minutes

4

Service units - in thousands

7

Importance

2

Example of a job information export record:

        !        !        !        !        !   NUMBER OF   ALT!  CONSUMPTION
JOBNAME !STEPNAME!PROCSTEP!PGMNAME !APPLPGM !RUNS ! CC !PROF!ST!ELPS!SRVUNIT!IM
--------+--------+--------+--------+--------+-----+----+----+--+----+-------+--
JOBB4500;ABPROC1 ;ABSTP02 ;DFSRRC00;P3AB398 ;00005;0000;0000;PE;0042;0011993;18;

The scope of the data to be exported is defined within the job by using input parameters in member APCBCJEX of the product CNTL library. These parameters are described in the following table:

APCBCJEX parameters

Input

MODE=x

Enter an E for export or an L for list. The default is E.

MODE=xx

Enter EX (export extended) or LX (list extended) to produce output records with a LRECL of 90 and display the LPAR column.

LPAR=name

Enter a fully-qualified LPAR name or a generic name by using the underscore (_) as a wildcard.

You can retrieve only the job information where the LPAR of the last job step execution matches either the fully-defined or generic LPAR search expression.

JOBNAME=name

Enter a fully-qualified job name or a generic name by using the underscore (_) as a wildcard.

PGMNAME=name

Enter a fully-qualified program name or a generic name by using the underscore (_) as a wildcard.

IMPORTANCE>=

Enter a value for the importance. A number from 1 to 50 is valid. A higher number indicates a higher job step importance.

SERVICE-UNITS>=

Enter the service units in thousands, 1 - 999999.

ELAPSED-TIME>=

Enter the session duration in minutes, 1 - 9999.

The following is an example of how to use the APCBCJEX parameters:

MODE=L
JOBNAME=__R_____
PGMNAME=APC____
IMPORTANCE>=10
ELAPSED-TIME>=30
SERVICE-UNITS>=1000