Datacom

Tech Tip from Karina Pulinx, Principal Support Engineer for October 18, 2016

This is another in the series of tips for CA Datacom Core Products Version 15.1 enhancement PTF RO92259.

RO92259 delivers 10 new features.

One of these new features is this DBUTLTY function, REPORT TYPE=WHATIFCP (what if compression).

Use this DBUTLTY function if you are thinking of changing compression options to test value and costs of several choices.

There is no impact or risk to the data that exists with this function.

To implement this quickly and safely, the report borrows all of function: EXTRACT DBID=nnnnn,AREA=aaa,TABLE=ttt,MULTUSE=YES.

Instead of outputting data rows, it provides compression statistics about:

Current storage

Compressed or not

If DB is compressed

Up to 3 user compression options

Example 1)

REPORT DBID=999,TABLE=TRN,TYPE=WHATIFCP

                    TABLE         RECORDS

                    TRN               2,134,498

                    TOTAL           2,134,498

NOTE 1 - BELOW STORED BYTES NUMBERS OVER 999 BILLION PRINTED WITHOUT COMMA SEPARATORS

NOTE 2 - BELOW STORED BYTES NUMBERS AS COMPRESSED CAN BE LARGER THAN NONE IF NO BYTES ARE COMPRESSIBLE FOR THESE ROWS

NOTE 3 - BELOW CPU TO COMPRESS IS THE TOTAL HHH:MM:SS.THXXXX TO PERFORM THE COMPRESS OF EACH ROW

NOTE 4 - BELOW CPU TO EXPAND IS THE TOTAL HHH:MM:SS.THXXXX TO PERFORM THE EXPAND  OF EACH ROW

NOTE 5 - OPTION2 NOT PROVIDED OR BLANK IN FIRST BYTE OF EACH OF 3 17 BYTE OPTIONS PROVIDE COLUMNS ONLY NONE, INPUT, DB

NOTE 6 - OPTION2 IN QUOTES IF ANY BLANKS ALLOWS 3 ADDITIONAL OPTIONS WITH EACH 17 BYTES, COMPRESS NAME, ENCRYPTION NAME

NOTE 7 - EXAMPLE 1 OPTION2=DBVVRPR

NOTE 8 - EXAMPLE 2 OPTION2='PRESSPAKWEAK    ,PRESSPAKDCT12345/PRESSPAK        '  (SEPARATOR NOT EDITED)

NOTE 9 - FOR PRESSPAK, A BLANK ENCRYPTION-NAME IS TREATED AS 'STRONG' BUT YOU MAY NOT SAY 'STRONG'  

CASE             NO COMPRESSION       EXTRACT INPUT                      DB

COMPRESSION                                                             DB                       DB

STORED BYTES      2,160,111,976                772,819,519         772,819,519

PERCENT OF NONE                                                                               35.7

CPU TO COMPRESS                                                        000:00:10.336215

CPU TO EXPAND                                                              000:00:04.973794

Example 2)

REPORT  DBID=999,TABLE=TRN,TYPE=WHATIFCP,OPTION2=PRESSPAK

CASE             NO COMPRESSION    EXTRACT INPUT                        DB                          OPTION2

COMPRESSION                                                          DB                         DB                           PRESSP

STORED BYTES      2,160,111,976               772,819,519         772,819,519                     622,745,505

PERCENT OF NONE                                                                              35.7                                  28.8

CPU TO COMPRESS                                                                   000:00:10.448355 000:00:09.490219

CPU TO EXPAND                                                                         000:00:04.988591 000:00:14.721807