5. FILES › 5.2 DB2 System Activity (DB2DSY) File › 5.2.3 Usage Considerations

5.2.3 Usage Considerations

This section identifies the special considerations or
techniques related to using the DB2DSY file.  Additionally,
several retrieval examples are provided to facilitate the use
of this file.

In the examples, we use a SAS macro to specify the DD name
part of the CA MICS file name. These macros are a standard
part of CA MICS and are available for all files. The macro
name has the form  _iiit, where "iii" is the Information Area
name and "t" is the time-span.  In addition, many of the
examples use the  _fffSUM macro, where "fff" is the file
identifier, to summarize the data as indicated by the _BY and
_BREAK macro definitions.

Special Considerations/Techniques

 1.  The following data elements only have meaning when using
     the DB2DSYnn file in the DETAIL time-span, in that they
     lose significance once summarization has been performed.
     These data elements should only be referenced when using
     the DB2DSYnn file in the DETAIL time-span.

     DSYISEQ   - Instrumentation Sequence Number
     DSYDSTSN  - Destination Sequence Number
     DSYINSEQ  - Instrumentation Sequence Number
     DSYIFCSD  - IFCID Sequence Number Data Base
     DSYIFCSS  - IFCID Sequence Number System
     DSYIFCSU  - IFCID Sequence Number User

 2.  Care must be exercised in using the special date and
     time data elements contained in each CA MICS file. As
     the file's granularity increases in higher time-spans,
     certain fields lose significance and should not be
     referenced.

     o HOUR should not be used in MONTHS and YEARS.
     o DAY and DAYNAME should not be used in WEEKS, MONTHS,
       or YEARS.
     o WEEK should not be used in MONTHS or YEARS.
     o MONTH should not be used in YEARS.

 3.  The data elements STARTTS and ENDTS have different
     meanings when used in the DETAIL time-span versus their
     meaning in the DAYS, WEEKS, MONTHS, and YEARS
     time-spans.  The ENDTS and STARTTS, when appearing in
     the DAYS, WEEKS, MONTHS, and YEARS time-spans, indicate
     the span of time over which the data has been summarized
     with STARTTS indicating the lowest date and time and
     ENDTS indicating the greatest date and time for the
     summarized data.

Retrieval Examples

 1.  Plot the accumulated TCB time used by DB2 over the last
     8 weeks by week.

     DATA TEST1;
     SET _DB2W.DB2DSY01
         _DB2W.DB2DSY02
         _DB2W.DB2DSY03
         _DB2W.DB2DSY04
         ;
     DATE=DATEPART(STARTTS);
     FORMAT DATE DATE7.;
     MACRO _BY WEEK %
     MACRO _BREAK WEEK %
     PROC SORT DATA=TEST1 OUT=TEST1;  BY _BY;
     DATA TEST1;
     SET TEST1;
     _DSYSUM;
     PROC PLOT DATA=TEST1;
     PLOT DSYTCBTM*DATE;
     TITLE DB2 SYSTEM TCB TIME;

 2.  Print the number of START DB2, START DATABASE, and
     DISPLAY DATABASE commands issued last week in Zone 1.

     DATA TEST2;
     SET _DB2W.DB2DSY01;
     IF ZONE=1;
     PROC PRINT DATA=TEST2;
     VAR DSYSTDB2 DSYSTDBA DSYSPDB;
     TITLE  NUMBER  OF  START  DB2, START DATABASE, AND START
     DATABASE COMMANDS;
     TITLE2 LAST WEEK IN ZONE 1;