Previous Topic: MUF EOJ Log Status InformationNext Topic: Buffer Pool Information


MUF EOJ Report Logging Section Changes

The MUF LXX format options feature is a performance enhancement that allows MUF to process more maintenance requests per second while reducing the total cost of ownership. For details, see the CA Datacom/DB Database and System Administration Guide.

In support of the LXX format options feature, the logging section of the MUF EOJ provides new headings and six new detail lines as follows:

Note: Many of the fields in the report are provided to show that features are working and their results, largely for use by CA Support, CA Datacom development, and QA debugging.

All lines show the total record count as follows:

Other lines in the report are as follows:

PRCT OF LXX

provides the byte count of the records as a percent of all log bytes during this MUF execution, with one decimal place if it amounts to one percent or higher. If the size is less than one percent, however, it is printed as a number similar to the total record count field previously described.

Note: Other lines in the report are formatted as appropriate to their descriptions, similarly to the PRCT OF LXX format.

OLD RCD EXP

provides the bytes of the log records that contained the before image record in fully expanded format. Includes encrypted tables written as encrypted.

OLD RCD CMP

provides the bytes where CA Datacom/DB compression was used.

OLD RCD USER

provides the bytes where user compression was used and the option allowed them to be written as compressed (includes 16 bytes of compression name and data).

NEW WA ORIG

provides the bytes during a DELET or UPDAT that were the original user Work Area that was logged as smaller than the other options.

NEW WA DELTA

provides the bytes during an UPDAT that were logged as a Work Area with only changes based upon the LOG_RECORD_UPDAT_SIZE option.

NEW RCD EXP

provides the bytes that were logged as the expanded after record. Includes encrypted tables written as encrypted.

NEW RCD CMP

provides the bytes that were logged as the compressed after record.

NEW RCD USER

provides the bytes that were logged as the user compressed after record.

ELEM LIST

provides the bytes that were logged as the element list (FORMAT 0 external style or FORMAT 1 internal style) for records logged with a Work Area.

FORMAT 1 SAVED

provides the bytes that were saved by records logged over how they would have been saved with FORMAT 0.

In the following example, the number of log bytes was 337 million, which makes each percent 3m. The numbers in the form nn.n are percentages, and the others are less than one percent, which means they are printed as a number of bytes.

             PRCT -- OLD   OLD   OLD   NEW   NEW   NEW   NEW   NEW      FORMAT       TOTAL    OF --   RCD   RCD   RCD    WA    WA   RCD   RCD   RCD  ELEM     1 GROUP  RCDS   LXX --   EXP   CMP  USER  ORIG DELTA   EXP   CMP  USER  LIST SAVED ADDIT  352K  30.7                      1262K         6.6 3289K  727K  165K   1.6 DELET  352K  32.1      8.0   1.2 1705K                                     1453K UPDAT  352K  36.2      8.0   1.1  844K 1262K   2.2  1008   146     0   1.7   6.1 TSN    7781 1685K                                                                MOVER  3340 1042K                                                                OTHER   304 84805