Dataset Activity Report
The Dataset Activity Report is produced by using the DATASET Analyzer control statement.
The data for this report is obtained from SMF type 42-6 records. The report consists of six sections. All sections of the report contain the same information; however, each section presents the information in a different order or level of detail. Also, several options let you further alter the content of each report section:
- An I/O count threshold limit lets you set a threshold as to what data sets can appear on a report. DSN or volume I/O counts that fall below the threshold do not appear on the report.
- You can limit reports to certain jobs, DSNs, and volumes, and various combinations of each.
The Dataset Activity Report consists of the following individual sections:
Dataset Activity Detail by DSN section
This section of the Dataset Activity Report is ordered by DSN, volume, and job name. It includes full activity details with subtotals by job name and volume.
A sample of the Dataset Activity Detail by DSN section is shown in following figure. A list and description of the fields in the entire Dataset Activity Report can be found in Dataset Activity Report field descriptions.
Dataset Activity Summary by DSN section
This section of the Dataset Activity Report summarizes the information in the Dataset Activity Detail by DSN section, providing a listing of the most active data sets in this order:
- descending order by total I/O count
- descending order by I/O intensity
- ascending order by cache hit percentage
A sample of the Dataset Activity Summary by DSN section is shown in the following figure. A list and description of the fields in the entire Dataset Activity Report can be found in Dataset Activity Report field descriptions.
Dataset Activity Detail by Job Name section
This section of the Dataset Activity Report is ordered by job name and is broken out by DSN and volume. It includes full activity details with subtotals by volume and DSN.
A sample of the Dataset Activity Detail by Job Name section is shown in the following figure. A list and description of the fields in the entire Dataset Activity Report can be found in Dataset Activity Report field descriptions.
Dataset Activity Summary by Job Name section
This section of the Dataset Activity Report summarizes the information in the Dataset Activity Detail by Job Name section, providing a listing of the most active jobs in this order:
- descending order by total I/O count
- descending order by I/O intensity
- ascending order by cache hit percentage
A sample of the Dataset Activity Summary by Job Name section is shown in following figure. A list and description of the fields in the entire Dataset Activity Report can be found in Dataset Activity Report field descriptions.
Dataset Activity Detail by Volume section
This section of the Dataset Activity Report is ordered by volume, DSN, and job name. It includes full activity details with subtotals by job name and DSN.
A sample of the Dataset Activity Detail by Volume section is shown in following figure. A list and description of the fields in the entire Dataset Activity Report can be found in Dataset Activity Report field descriptions.
Dataset Activity Summary by Volume section
This section of the Dataset Activity Report summarizes the information in the Dataset Activity Detail by Volume section, providing a listing of the most active volumes in this order:
- descending order by total I/O count
- descending order by I/O intensity
- ascending order by cache hit percentage
A sample of the Dataset Activity Summary by Volume section is shown in the following figure. A list and description of the fields in the entire Dataset Activity Report can be found in Dataset Activity Report field descriptions.
BMC SOFTWARE, INC. BMC ENGINEERING REPORT DATE: DD MMM YY 11.45
REQD 19 MAY YY 10.42.31 19 MAY YY 11.46.00 SYSTEM ID: SJSD * N/A *
ACTL 19 MAY YY 10.42.31 19 MAY YY 11.45.14 REPORT CYCLE: CYCLE099
BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 42-6/3,095/0/0
-------------------------------------------------- DATASET ACTIVITY DETAIL BY DSN --------------------------------------------------
# OF # OF CACHE -- AVERAGE TIMES (MILLISECONDS) --- -- DATASET --
DATASET NAME VOLSER JOB NAME JOBS I/Os HIT % RESP CONN DISC PEND IOSQ CU Q TYPE BLKSIZ
-------------------------------------------- ------ -------- ----- --------- ----- ----- ----- ----- ----- ----- ----- ------ ------
AAO.ARDATA.D65B BAB341 AAOD65B 1 9 0 2.9 2.3 0 0.4 0 0 PS 27,750
AAO.ARDATA.D71B BAB322 AAOD71B 1 3 0 2.8 2.3 0 0.3 0 0 PS 27,750
AAO.BMCPSWD BAB361 AAODL71 11 22 100.0 0.5 0.2 0 0.1 0 0 PDS 2,924
AAO.QAOSMON.D65B BAB345 AAOD65B 6 6 0 1.1 0.6 0 0.3 0 0 PS 8,000
AAO.QAOSMON.D71B BAB339 AAOD71B 6 6 0 1.6 1.0 0 0.5 0 0.2 PS 8,000
AAO62.BAODDL.DATA BAB318 AAODL64 6 12 100.0 0.9 0.4 0 0.3 0 0 PDS 27,920
* * AAODL65 7 14 92.9 2.1 0.3 0.7 0.2 0 0 PDS 32,720
* * AAODL71 47 1,445 91.6 1.3 0.4 0.2 0.3 0 0.1 PDS 32,720
* * *ALL* 60 1,471 91.7 1.3 0.4 0.2 0.3 0 0.1 PDS 32,720
AAO64.BAODDL.LOAD BAB317 AAODL64 5 152 100.0 6.9 6.0 0 0.5 0 3.4 PDS 32,760
AAO64.DL64.JOURNAL2 BAB318 AAODL64 2 7 85.7 3.1 1.2 0.8 0.6 0 0 DA 4,096
AAO65.DL65.BBIDIV.DATA BAB301 AAODL65 1 11 100.0 5.6 2.3 0 0.5 0 0.1 LINEAR 4,096
AAO65.DL65.BBIVARS BAB318 AAODL65 1 1 100.0 1.4 0.6 0 0.5 0 0 DA 5,720
AAO65.D65B.BBIDIV.DATA BAB301 AAOD65B 5 117 99.1 2.7 1.7 0 0.4 0 0 LINEAR 4,096
AAO65.D65B.BBIVARS BAB358 AAOD65B 5 10 100.0 4.1 1.9 0 1.9 0 0.4 DA 5,720
AAO65.D65B.JOURNAL2 BAB358 AAOD65B 4 14 85.7 1.4 0.5 0.5 0.2 0 0 DA 4,096
AAO71.AOENG.BBACTDEF BAB357 SMSPDSE 3 4 50.0 2.1 0.3 1.5 0.1 0 0 PDSE 0
AAO71.BAODDL.BBACTDEF BAB317 AAODL71 2 4 75.0 2.6 0.1 2.0 0.1 0 0 PDS 32,720
AAO71.BAODDL.BBPLIB BAB320 BAODDL2 14 0 0 0 0 0 0 0 0 PDSE 32,720
AAO71.BAODDL.HISTDS01.DATA BAB301 AAODL71 1 3 0 7.3 0.6 6.4 0.1 0 0 KSDS-D 32,768
AAO71.BAODDL.HISTDS01.INDX BAB301 AAODL71 1 5 40.0 4.4 0 4.0 0.1 0 0 KSDS-I 512
AAO71.BAODDL.HISTDS02.DATA BAB301 AAODL71 6 251 86.9 3.0 1.4 0.6 0.5 0 0.4 KSDS-D 32,768
AAO71.BAODDL.HISTDS02.INDX BAB301 AAODL71 6 61 96.7 1.9 0.8 0.3 0.5 0 0.3 KSDS-I 512
AAO71.BAODDL.HISTDS03.DATA BAB301 AAODL71 1 3 0 4.9 0.6 4.0 0.3 0 0 KSDS-D 32,768
AAO71.BAODDL.HISTDS03.INDX BAB301 AAODL71 1 5 40.0 3.6 0.1 3.1 0.1 0 0 KSDS-I 512
Dataset Activity Report (continued)
PRODUCED BY CMF ANALYZER (v.r.mm RSL yymm ) DATASET ACTIVITY REPORT RPTSEQ 3 PAGE 37
BMC SOFTWARE, INC. BMC ENGINEERING REPORT DATE: DD MMM YY 11.45
REQD 19 MAY YY 10.42.31 19 MAY YY 11.46.00 SYSTEM ID: SJSD * N/A *
ACTL 19 MAY YY 10.42.31 19 MAY YY 11.45.14 REPORT CYCLE: CYCLE099
BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 42-6/3,095/0/0
------------------------------------------------- DATASET ACTIVITY SUMMARY BY DSN --------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------
40 MOST ACTIVE DATASETS -- IN DESCENDING ORDER BY TOTAL I/Os
------------------------------------------------------------------------------------------------------------------------------------
# OF # OF CACHE -- AVERAGE TIMES (MILLISECONDS) --- -- DATASET --
DATASET NAME VOLSER JOB NAME JOBS I/Os HIT % RESP CONN DISC PEND IOSQ CU Q TYPE BLKSIZ
-------------------------------------------- ------ -------- ----- --------- ----- ----- ----- ----- ----- ----- ----- ------ ------
CSGI.MQS600.SCSQAUTH 30 9,890 91.8 9.4 7.3 0 0.4 0 0.2
MTAQA.GA.MVTA21.V2075.ESDSMPE.BBLINK 4 9,346 0 2.9 1.9 0.4 0.2 0 0
MTAQA.QA.V2235.PUT0801B.BBLINK 4 6,481 0 2.9 1.8 0.4 0.3 0 0
MTAQA.V2080.ESD0315.LOAD 5 5,797 0 1.6 0.8 0 0.4 0 0.1
IFASMF.IFASMF.SJSD.LOGR1.A0000000.DATA 2 5,506 0 21.5 20.6 0 0.5 0 0.4
MTAQA.MTAWFAD.D2005307.DSLG1.A0732001 79 5,394 100.0 0.3 0 0 0.1 0 0
MTAQA.IMS8N.RDS2 5 4,505 100.0 1.1 0.4 0 0.2 0 0.1
MTAQA.IMS8B.RDS2 5 4,504 100.0 1.0 0.5 0 0.2 0 0.2
MV.QA60.SJSD.MV60LOGR.A0814003 5 4,351 100.0 1.5 0.4 0 0.2 0 0
BBI26.ENG.LINKLIB 50 4,188 92.8 6.3 4.7 0 0.4 0 0.5
CSGI.MQS600.SCSQANLE 25 3,982 99.2 5.7 3.0 0.1 0.5 0 0.3
BBQ25.ENG.LINKLIB 46 3,954 98.0 3.6 2.6 0 0.4 0 0.3
BB.XTST1.BBLINK 66 3,846 47.2 13.6 8.1 1.4 0.3 0 0.5
BBI26.BASE.LINKLIB 42 3,812 98.8 6.3 3.8 0 0.4 0 0.7
BBT11.ENG.LINKLIB 34 3,630 99.2 6.5 4.6 0.1 0.4 0 1.1
BBT11.BASE.LINKLIB 34 3,621 99.3 5.2 4.2 0 0.4 0 0.3
MTAQA.IMS8B.WADS0 5 3,360 100.0 3.5 2.6 0 0.5 0 2.1
MTAQA.IMS8B.WADS1 5 3,360 100.0 1.1 0.6 0 0.3 0 0.2
MTAQA.IMS8N.WADS0 5 3,359 100.0 1.4 0.5 0 0.2 0 0.1
MTAQA.IMS8N.WADS1 5 3,359 99.9 2.4 0.5 0 0.2 0 0.2
BBQ25.BASE.LINKLIB 41 3,199 99.8 3.0 2.2 0 0.4 0 0.2
MV.QA50.PUT0402B.IMAGSJSD.A0814002 5 2,929 99.8 1.2 0.2 0 0.1 0 0
OLT22.BASE.LINKLIB 24 2,761 99.2 4.5 3.5 0 0.4 0 0.4
OLT22.ENG.LINKLIB 24 2,759 98.8 5.0 3.5 0.1 0.5 0 0.4
SYS1.SJSD.HASPCKPT 5 2,732 99.7 1.6 1.0 0 0.1 0 0
MAM21.SJSD.TESTING.REGISTRY.DATA 5 2,677 71.2 5.7 4.6 0.1 0.5 0 0.6
PWD32.BASE.LINKLIB 15 2,533 100.0 0.8 0.4 0 0.1 0 0
PWD32.ENG.LINKLIB 15 2,533 100.0 0.9 0.4 0 0.1 0 0
SYS2.BBPROD.BBPROC 172 2,420 99.9 1.9 0.5 0 0.4 0 0.1
MVQA.AO71QA.BBLINK 5 2,345 97.9 15.1 13.9 0 0.4 0 0.2
BB.XTST1.BBPARM 51 2,271 27.7 0.8 0.3 0.1 0.2 0 0
IMF31.BASE.LINKLIB 19 2,117 99.3 4.2 3.3 0 0.4 0 0.2
IMF31.ENG.LINKLIB 19 2,117 99.2 4.3 3.3 0 0.4 0 0.3
CICS640.SDFHEXCI 5 2,054 99.4 3.3 2.5 0 0.3 0 0.1
CSGI.MQS600.SCSQLOAD 5 2,054 99.4 3.4 2.5 0 0.3 0 0.1
MVQA.AO71QA.TEMP.BBLINK 5 2,054 97.9 4.4 3.2 0.1 0.7 0 0.5
MQS12.CSQ2.PARMS 20 1,928 100.0 5.7 4.7 0 0.5 0 1.2
CICS410.SDFHEXCI 10 1,855 99.5 4.4 3.2 0 0.5 0 0.3
SYS1.IBMMQS.TST520.SCSQAUTH 5 1,816 99.7 9.0 8.1 0 0.4 0 0.3
LNX11.ENG.LINKLIB 24 1,773 98.5 5.8 4.4 0 0.4 0 0.4
PRODUCED BY CMF ANALYZER (v.r.mm RSL yymm ) DATASET ACTIVITY REPORT RPTSEQ 3 PAGE 40
BMC SOFTWARE, INC. BMC ENGINEERING REPORT DATE: DD MMM YY 17.51
REQD 19 MAY YY 10.42.31 19 MAY YY 11.46.00 SYSTEM ID: SJSD * N/A *
ACTL 19 MAY YY 10.42.31 19 MAY YY 11.45.14 REPORT CYCLE: CYCLE099
BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 42-6/3,095/0/0
----------------------------------------------- DATASET ACTIVITY DETAIL BY JOB NAME ------------------------------------------------
# OF # OF CACHE -- AVERAGE TIMES (MILLISECONDS) --- -- DATASET --
JOB DATASET NAME VOLSER JOBS I/Os HIT % RESP CONN DISC PEND IOSQ CU Q TYPE BLKSIZ
-------- -------------------------------------------- ------ ----- --------- ----- ----- ----- ----- ----- ----- ----- ------ ------
AAODL64 AAO62.BAODDL.DATA BAB318 6 12 100.0 0.9 0.4 0 0.3 0 0 PDS 27,920
* AAO64.BAODDL.LOAD BAB317 5 152 100.0 6.9 6.0 0 0.5 0 3.4 PDS 32,760
* AAO64.DL64.JOURNAL2 BAB318 2 7 85.7 3.1 1.2 0.8 0.6 0 0 DA 4,096
* BB.XTST1.BBLINK BAB333 5 152 99.3 27.1 20.0 0 0.3 0 0.4 PDS 23,476
(rest of report has been deleted)
PRODUCED BY CMF ANALYZER (v.r.mm RSL yymm ) DATASET ACTIVITY REPORT RPTSEQ 3 PAGE 61
BMC SOFTWARE, INC. BMC ENGINEERING REPORT DATE: DD MMM YY 17.51
REQD 19 MAY YY 10.42.31 19 MAY YY 11.46.00 SYSTEM ID: SJSD * N/A *
ACTL 19 MAY YY 10.42.31 19 MAY YY 11.45.14 REPORT CYCLE: CYCLE099
BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 42-6/3,095/0/0
----------------------------------------------- DATASET ACTIVITY SUMMARY BY JOB NAME -----------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------
40 MOST ACTIVE JOBS -- IN DESCENDING ORDER BY TOTAL I/Os
------------------------------------------------------------------------------------------------------------------------------------
# OF # OF CACHE -- AVERAGE TIMES (MILLISECONDS) --- -- DATASET --
JOB DATASET NAME VOLSER JOBS I/Os HIT % RESP CONN DISC PEND IOSQ CU Q TYPE BLKSIZ
-------- -------------------------------------------- ------ ----- --------- ----- ----- ----- ----- ----- ----- ----- ------ ------
AAODL71 332 24,785 96.7 3.4 2.2 0.4 0.3 0 0.2
MQMGT44 165 22,202 96.6 2.6 1.8 0 0.3 0 0.2
AAOD71B 131 21,746 99.4 4.3 3.3 0.1 0.4 0 0.3
AAOD65B 121 19,384 99.2 4.5 3.5 0 0.5 0 0.3
MTAP21D 386 15,937 41.3 0.7 0.2 0 0.2 0 0
MV71AO 817 15,780 98.1 0.9 0.5 0 0.2 0 0
(rest of report has been deleted)
Dataset Activity Report (continued)
PRODUCED BY CMF ANALYZER (v.r.mm RSL yymm ) DATASET ACTIVITY REPORT RPTSEQ 4 PAGE 64
BMC SOFTWARE, INC. BMC SOFTWARE, INC. REPORT DATE: DD MMM YY 11.45
REQD 19 MAY YY 10.42.31 19 MAY YY 11.46.00 SYSTEM ID: SJSD * N/A *
ACTL 19 MAY YY 10.42.31 19 MAY YY 11.45.14 REPORT CYCLE: CYCLE099
BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 42-6/3,095/0/0
------------------------------------------------ DATASET ACTIVITY DETAIL BY VOLUME -------------------------------------------------
# OF # OF CACHE -- AVERAGE TIMES (MILLISECONDS) --- -- DATASET --
VOLSER DATASET NAME JOB NAME JOBS I/Os HIT % RESP CONN DISC PEND IOSQ CU Q TYPE BLKSIZ
------ -------------------------------------------- -------- ----- --------- ----- ----- ----- ----- ----- ----- ----- ------ ------
ADR027 BB.XTST2.BBPLIB BAODDL2 14 36 100.0 0.4 0 0 0.1 0 0 PDS 32,720
ADR030 DMRQA.COPY.OUTGRP4.TRACE1.RBAT.D DOMQEV54 1 14 78.6 2.3 0 1.9 0.1 0 0 ESDS 4,096
ADR035 CMN57.CMENG.BBPLIB SMSPDSE 2 6 100.0 0.3 0.1 0 0.1 0 0 PDSE 0
ADR039 RXA35.ASBASE.BBPLIB SMSPDSE 1 4 25.0 6.1 0.3 5.5 0.3 0 0 PDSE 0
ADR046 DMRQA.V5R4M00.PARMLIB DOMQEV54 2 13 61.5 9.3 7.2 1.9 0.1 0 0 PDS 27,920
(rest of report has been deleted)
PRODUCED BY CMF ANALYZER (v.r.mm RSL yymm ) DATASET ACTIVITY REPORT RPTSEQ 3 PAGE 90
BMC SOFTWARE, INC. BMC ENGINEERING REPORT DATE: DD MMM YY 17.51
REQD 19 MAY YY 10.42.31 19 MAY YY 11.46.00 SYSTEM ID: SJSD * N/A *
ACTL 19 MAY YY 10.42.31 19 MAY YY 11.45.14 REPORT CYCLE: CYCLE099
BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 42-6/3,095/0/0
------------------------------------------------ DATASET ACTIVITY SUMMARY BY VOLUME ------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------
40 MOST ACTIVE VOLUMES -- IN DESCENDING ORDER BY TOTAL I/Os
------------------------------------------------------------------------------------------------------------------------------------
# OF # OF CACHE -- AVERAGE TIMES (MILLISECONDS) --- -- DATASET --
VOLSER DATASET NAME JOB NAME JOBS I/Os HIT % RESP CONN DISC PEND IOSQ CU Q TYPE BLKSIZ
------ -------------------------------------------- -------- ----- --------- ----- ----- ----- ----- ----- ----- ----- ------ ------
TSG312 60 14,811 94.3 7.4 5.1 0 0.4 0 0.2
BAB378 27 13,548 82.8 1.6 0.6 0.1 0.2 0 0.2
BAB365 218 10,097 7.3 0.8 0.3 0.1 0.2 0 0
BAB311 116 8,927 96.0 5.5 3.7 0 0.4 0 0.5
BAB350 16 8,375 22.4 3.6 2.5 0.1 0.4 0 0.2
(rest of report has been deleted)
Dataset Activity Report field descriptions
The table below describes each field in the Dataset Activity Report.
Field | Description | |
|---|---|---|
DATASET NAME | name of the data set | |
VOLSER | DASD volume upon which the data set is allocated | |
JOB NAME | name of the job that utilized the data set | |
# OF JOBS | total number of jobs utilizing the data set | |
# OF I/Os | total number of I/Os performed | |
CACHE HIT % | percentage of I/Os that were satisfied from cache | |
AVERAGE TIMES (MILLISECONDS | average performance times in milliseconds; possible values are as follows: | |
RESP | response time | |
CONN | I/O connect time | |
DISC | disconnect time | |
PEND | pending I/O time | |
IOSQ | device-active-only time | |
CU Q | control unit queue time | |
D/S TYPE | data set type; possible values are as follows: | |
DA | direct access | |
ESDS | VSAM entry-sequenced data set | |
EXCP | execute channel program | |
EF | extended-format data set | |
HFS | hierarchical file system | |
ISAM | indexed sequential access method | |
KSDS-D | VSAM KSDS data component | |
KSDS-I | VSAM KSDS index component | |
LINEAR | linear data set | |
PDS | partitioned data set | |
PDSE | partitioned data set extended | |
PS | physical sequential | |
RRDS | fixed-length RRDS | |
RRDS-D | VSAM variable RRDS data component | |
RRDS-I | VSAM variable RRDS index component | |
Other | not one of the previous values | |
BLKSIZ | block size of the data set | |
Related topics