DC/UCF System Reports—CREPORTS › SQL CACHE Reports (CREPORTs 047 and 048) › Contents

Contents

SQL CACHE reports provide information about SQL CACHE parameters that have been defined for each system. SQL CACHE parameters are represented in the dictionary by the CVGDEFS-142 record, which is a logical extension of the SYS-041 record.

CREPORT 047 describes SQL CACHE parameters for systems that have been defined but not generated; CREPORT 048 describes SQL CACHE parameters for executable systems. The fields and the formats of the two reports are the same.

Sample CREPORT 048:

 REPORT NO. 48                                   CA IDMS SQL CACHE REPORT   REL nn.n                             mm/dd/yy PAGE     1
 CREPORT 048                                       LISTING OF SQL CACHE PARAMETERS
                                                           OBJECT REPORT

          SYSTEM VERSION    99          DEFAULT CACHING IS OFF                                 STATEMENTS


          SYSTEM VERSION   110          DEFAULT CACHING IS ON                              700 STATEMENTS
                                        EXCEPT CONNECT TO APPLDICT
                                        EXCEPT CONNECT TO TSTDICT