Previous Topic

Next Topic

Book Contents

Book Index

CTTRPT Sample Reports

The reports listed below can be created using the CTTRPT utility. These reports are located in the IOA SAMPLE library.

Some of these sample reports contain question marks (??) where customization is necessary. Replace the question marks with the desired values and use the appropriate job to produce the report.

Table 359 CTTRPT Sample Reports

Report

Description

CTTRFSCR

Full-scratch report. Lists all volumes with SCRATCH status in the Media database

CTTRINV

Vault inventory report. Lists all vaulted volumes and data sets in a specified location

CTTRINVT

Comprehensive inventory report. Lists all volumes and data sets in the Media database

CTTRSCRD

Lists all volumes scratched on a specified date and the data sets residing on these volumes

CTTRDELV

Lists all volumes with DELETED status

CTTRCLN

Clean report. Lists volumes that need to be cleaned (meaning, each volume that has more than a specified threshold number of permanent I/O errors)

CTTRRTNP

Lists all data sets (and their volumes) according to expiration date type (for example, CYCLE or CATALOG)

CTTRLACV

Lists all volumes accessed today

CTTRDCRE

Lists all data sets created yesterday

CTTRMOVW

Lists all volumes moved within the last seven days

CTTRCHKI

Lists all external volumes checked-in during the last 30 days)

CTTRUTIL

Lists volumes that are under-utilized (less than less than 10 megabytes)

CTTRLAVJ

Lists all volumes that were last accessed by a certain job since a specified date

CTTRWDCP

Lists all data sets that were written in a certain system (CPU) since a specified date

CTTROUTL

Lists all volumes in an out-location (borrower volumes)

CTTRLRTV

Lists all volumes with high retention dates (for example, after year 2001)

CTTRM10V

Lists all multi-volume data sets that span more than ten volumes

CTTRMACV

Lists the most active volumes (accessed more than ten times since they became active)

CTTREDM

Lists all EDM volumes

CTTRRCLV

Lists all RECALLed volumes

CTTRVUPD

Lists all volumes that were manually updated by a specified user

CTTRDUPD

Lists all data sets that were manually updated by a specified user

CTTRM25D

Lists all volumes containing more than 25 active data sets

CTTRVBOX

Lists the volumes stored in a specified box

CTTRBXLC

Lists all volumes that are stored in boxes, according to location and BOXID

CTTRNRTR

Lists all borrowed volumes that have not yet been returned

Jobs for Report Production

The above reports are produced using the following jobs (that are located in the JCL library):

Table 360 CTTRPT Jobs

Job

Description

REPFSCR

Produces report CTTRFSCR (full-scratch report)

REPINV

Produces report CTTRINV (comprehensive inventory report)

REPSJOB

Produces all other reports. This job requires customizations to indicate the desired report.

Parent Topic

CTTRPT – Database extraction and report utility