Sample Report: Utility Function History

REPORT (Generate Reports) › Type H - Utility Function History Report › Sample Report: Utility Function History

Sample Report: Utility Function History

Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ REPORT DBID=1,TYPE=H FUNCTION=REPORT DBID=1 TYPE=H Ž

Œ: The command exactly as entered.
: An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
Ž: Any messages related to syntax processing would be displayed in this area.

Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 1 ******************************************************************************** Directory: PRODCXX FUNCTION HISTORY REPORT Œ Ž ‘ ’ “ AREA EVENT JOB NAME DATE TIME CXXNAME TYPE OTHER IXX INIT DBDVL 12/03/2002 09.36.41 PRODCXX EXTEND EXTENDS SINCE INIT - 0 DEM INIT DBDVL 12/03/2002 09.36.39 PRODCXX EXTEND EXTENDS SINCE INIT - 0 RESTART LOAD DBDVL 12/03/2002 09.36.41 PRODCXX B LOAD (-1) DBDVL 12/03/2002 09.36.39 B RETIX RETIX (-1) BACKUP BACKUP (-1) BACKUP (-2) BACKUP (-3) BACKUP (-4) BACKUP (-5) BACKUP (-6) BACKUP (-7) PAY INIT DBDVL 11/07/2002 08.09.49 PRODCXX EXTEND EXTENDS SINCE INIT - 0 RESTART LOAD DBDVL 12/11/2002 09.00.00 PRODCXX LOAD (-1) DBDVL 12/11/2002 08.00.00 RETIX DBDVL 11/14/2002 13.48.31 RETIX (-1) BACKUP DBDVL 12/11/2002 09.14.03 E BACKUP (-1) DBDVL 12/11/2002 08.52.30 E BACKUP (-2) DBDVL 11/07/2002 15.30.33 N BACKUP (-3) DBDVL 11/07/2002 08.11.37 N BACKUP (-4) BACKUP (-5) BACKUP (-6) BACKUP (-7) PMF INIT DBDVL 11/07/2002 08.09.50 PRODCXX EXTEND EXTENDS SINCE INIT - 0 RESTART LOAD DBDVL 12/03/2002 09.36.41 PRODCXX B LOAD (-1) DBDVL 12/03/2002 09.36.00 B RETIX RETIX (-1) BACKUP DBDVL 11/07/2002 15.30.33 N BACKUP (-1) DBDVL 11/07/2002 08.11.37 N

Œ

AREA - The area with the data area name or IXX for the Index Area. If the database has Multi-Dataset Index areas, the index areas named Inn follow the IXX area and are in front of the data areas.

EVENT - A list of the functions that have executed against the area.

Ž

JOB NAME - The name of the job that executed the function.

DATE -The date the function was executed.

TIME - The time the function was executed.

‘

CXXNAME - The name of the Directory at the time the function executed. The CXXNAME is only available for the INIT and the last LOAD.

’

TYPE - The choices made with the execution of the function (EVENT). The following shows the function that shows under EVENT, the value that shows under TYPE, and a description of the code.

BACKUP

Codes and descriptions

E: An EXTRACT was performed. Whether it was PHYSICAL or NATIVE is not provided.
N: SEQ=NATIVE
P: SEQ=PHYSICAL
R: SEQ=PHYSICAL, RECID=YES

EXTEND

Not applicable.

INIT

Not applicable.

LOAD

Codes and descriptions

0: FORMAT=NONE
E: FORMAT=EXTRACT
V: FORMAT=VAR
B: FORMAT=BACKUP (without control information)
N: FORMAT=BACKUP, SEQ=NATIVE
P: FORMAT=BACKUP, SEQ=PHYSICAL
R: FORMAT=BACKUP, SEQ=PHYSICAL, RECID=YES

RESTART

Not applicable.

RETIX

Not applicable.

“

OTHER - Additional information, such as the number of extents since the last INIT function and a description of the origin of the data used in a LOAD function. OTHER can contain SORT=0 if the last LOAD or RETIX had SORT=0 set (and it was not a LOAD FORMAT=NONE). This is to show the databases that were not last subject to LOAD and RETIX with a SORT value greater than 0 (which we recommend).