Using the Central Component › Export Central Component Data › Export Data Mining - Job APCBJDAX

Previous Topic: Alert Export Parameters

Next Topic: Measure the Jobs of Critical Paths - Job APCBJCRI

Export Data Mining - Job APCBJDAX

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

//JOBCARD...
//*********************************************************************
//* PMA: APCBJDAX                                                     *
//* MAINTENANCE: PMA TEAM                                             *
//* FUNCTION:    XREF OF  DATA MINING                                 *
//* ACTION:      BUILD XREF ON LIST                                   *
//* COPYRIGHT (C) 2011 CA. All Rights Reserved.                       *
//* Copyright (C) Trilog AG                                           *
//*********************************************************************
//APCBADAX EXEC  PGM=APCBADAX
//STEPLIB  DD DSN=prefix.PMA.LOAD,DISP=SHR
//APCPARM1 DD DSN=prefix.PMA.PARMS,DISP=SHR
//APCBPRO1 DD DSN=prefix.PMA.KSDSPRO,DISP=SHR
//APCBBPM1 DD DSN=prefix.PMA.KSDSBPM,DISP=SHR
//APCBJOB1 DD DSN=prefix.PMA.KSDSJOB,DISP=SHR
//APCIN DD DSN=prefix.PMA.CNTL(APCBCDAX),DISP=SHR
//APCREP   DD SYSOUT=*
//APCEREP  DD SYSOUT=*

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

APCBCDAX parameters

Meaning

Default

XREF=n

where n identifies the tuning object:

1    Application program

2    System program

3    subsystem

4    DB2 plan

5    System program

6    Corresponding job steps

A    All cross references

A

SCOPE=x

Where x identifies the Data Mining Scope:

T           All objects in the TOP Scope

ALL     All objects of PMA

Mnnn  Maximum nnn objects

T

JOBNAME=name

A fully qualified job name or a generic name that uses the underscore (_) as a wildcard

all

PGMNAME=name

A fully qualified program name or a generic name that uses the underscore (_) as a wildcard

all

IMPORTANCE=nn

where nn is the lower limit of the job's importance

all

FROMDATE=yyyymmdd

lower limit of the measurement's creation date

All

BASEDATE=yyyymmdd

base date for frequency weighting

Date of data mining execution

ANNUALFRQ=Y/N

defines whether the frequency annual forecast calculation is done

If N is specified, the CPU is calculated with the current job step frequency.

Y

All defined parameters are combined with a logical AND.

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

XREF=A
SCOPE=T
JOBNAME=________
PGMNAME=________
IMPORTANCE=00
FROMDATE=20110101