Archiving and Compressing the CCDB › Overview › NDVRARCO Output

NDVRARCO Output

NDVRARCO output provides the user with four types of information: a standard input command listing, followed by compiled input commands, running information, and summary statistics.

As a matter of course, NDVRARCO echoes the user's input commands at the beginning of the output listing. Following the initial input command listing, NDVRARCO provides a series of informational messages that apply specifically to compiled input.

volser                                                      CA, INC.                                        DATE      TIME     PAGE
RELEASE nn.n                                        C A - E N D E V O R / D B                             mm/dd/yy  10:14:22  00001
                                                  CCDB ARCHIVE/COMPRESS UTILITY

   SIGNON DBNAME SRCNDVR USER EDBADMIN.
   COMPRESS               TO DATE mm/dd/yy.
   ARCHIVE  USER EDBADMIN TO DATE mm/dd/yy.
   ALTER CONFIRMATION CHANGE LOG ENTRYS
       FROM DBNAME TGTDICT SYSTEM SYSTEM81
         TO DBNAME TGTNDVR SYSTEM SYSTEM81.


NDVRARCO: I002 COMPRESS PROCESSING WILL BE PERFORMED ON CCDB CHANGE-LOG ENTRIES CREATED BEFORE DATE mm/dd/yy TIME 23:59:59
NDVRARCO: I003 CHANGE-LOG ENTRIES FOR EDBADMIN                         PRIOR TO DATE mm/dd/yy TIME 23:59:59 WILL BE ARCHIVED
NDVRARCO: I004 ABORTED UPDATE SESSIONS OCCURRING BEFORE DATE mm/dd/yy TIME 10:14:22 WILL BE REMOVED FROM THE DATABASE


NDVRARCO: I020 CLE NUMBER      100 DATE mm/dd/yy TIME 06:31:22 FOR ELE DATE-2                                   BEING PROCESSED

NDVRARCO: I005 NUMBER OF ABORTED UPDATE SESSIONS REMOVED FROM DATABASE ...............:        2

NDVRARCO: I006 NUMBER OF CHANGE-LOG RECORDS REMOVED FROM DATABASE BY COMPRESSION .....:        3

NDVRARCO: I007 ARCHIVE PROCESSING FOR USER EDBADMIN
               NUMBER OF CHANGE-LOG RECORDS REMOVED FROM DATABASE ....................:      123
               NUMBER OF RECORDS WRITTEN TO ARCHIVE FILE .............................:      461

NDVRARCO: I008 NUMBER OF CONFIRMATION CHANGE-LOG ENTRIES ALTERED
               FROM DBNAME TGTDICT  SYSTEM SYSTEM81 TO DBNAME TGTNDVR  SYSTEM SYSTEM81:      150

• If a COMPRESS command was specified, NDVRARCO informs the user that compress processing will be performed, along with the date and time prior to which everything will be compressed.
• If ARCHIVE commands were specified, NDVRARCO provides a message for each archive that is to be performed, along with the name of each program to be archived and a PRIOR TO date and time.
• If ALTER CONFIRMATION commands were specified, NDVRARCO provides a message for each command indicating the number of Confirmation Change Log records that were altered.

The final message in this listing block refers to the aborted updates, which were removed from the database as NDVRARCO performed its routine cleanup of uncommitted work.

Note: If the user specified a MANAGEMENT-GROUP name, NDVRARCO provides the names of associated CCIDs in the compiled command listing, not the management group.

Following the compiled input listing, NDVRARCO provides run-related information for job monitoring purposes. As indicated in the bolded area below, the first listings in this block indicate aborted update sessions. These are the incomplete jobs that are rolled out by the updating program (for example, IDD). One of these messages appear for each aborted session. The final information in this block serves as a "counter" for the passing of each 100 CLEs. These listings indicate the date/time stamp in that particular CLE, along with that CLE's associated entity name. This is NDVRARCO's way of letting administrators observe execution progress.

The final block of information provided in NDVRARCO output is the summary statistics listing.

• The first message in this block reflects the number of aborted update sessions removed from the database. This single message occurs with every NDVRARCO run.
• The second message reflects the number of change-log records removed from the database by compression. This single message occurs only if compress processing was requested.
• The third type of message is archive-related and will consequently appear only if archive processing was requested. Each archive request produces a list of summary statistics indicating the number of change-log records removed from the database, and the number of records written to an archive file.
• The fourth type of message will appear only if ALTER CONFIRMATION processing was requested. Each ALTER CONFIRMATION request produces summary statistics indicating the number of Confirmation Change Log records altered in the CCDB for the request.