Apologies for the delay, I had to consult with my Db2 colleagues to get a response for you.
As you know, when the DPRSMF job runs, information from the last SMF statistics record encountered for each DB2 subsystem is written to the spin file and then used as the first record for the next DPRSMF run.
This implies that for each job that extracts DB2 statistic SMF records for some DB2s, the SPIN file should re-used for the next run. If the customer splits the extraction of DB2 statistic records into several jobs each of these jobs should use its own SPIN file. When re-starting one of these extraction jobs it needs the last records from the previous run to calculate the statistic interval deltas – and these ‘previous run last records’ are saved intermediately in the SPIN file.
Hope that helps.
We are planning on using the DC archives, not the SMF data. So here is my question.
WHEN you ARE loading the data, do you have to specify the actual archive datasets to include for processing a day of activity?
Using the archive files, for APPTUNE, you can have it dynamically allocate the files it needs. But for the Mainview jobs you have to select what archives to allocate?
Just to be clear, are you planning on using DOMBRPT1 to report on the data collector files? If so then there are several ways that you can allocate the required files. If you want to use archive files, as opposed to the active ones, you can add a DD like this:
//DOMBARC with the name of the COPYDIR, or archive directory
If DATASOURCE is omitted, and there is no TRACEIN DD in the JCL, the Archive Directory is searched for archived trace data sets based on the interval selection that you specified as parameters for the batch reports. The TRACEIN DD is dynamically allocated with the data sets that are retrieved from the Archive directory.
This way you do not need to hard code the archive datasets in your JCL each time
Knowledge Article 000148572 explains the different options available quite nicely. What files may be used as input to DOMBRPT1 for MainView for DB2 reports
I hope this helps
I will the articles over, I am happy to hear that there are ways to do this.
If I have questions I will let you know.
I had a ticket in on this, Support should know about this. They said there was not way of doing this.
Texas Comptroller of Public Accounts
111 E 17th Street
Austin, Texas 78774
I wanted to answer your question :
are you planning on using DOMBRPT1 to report on the data collector files?
Here is my plan, I want to load the Mainview Performance Data into DB2 tables. I do not want to have to pick and choose what
Archive files are needed for Certain Dates.
Now for what JCL to use.
The sample job alludes to using the MVDB2-DATA COLLECTOR ARCHIVE FILES AND LOAD . This is my initial focus.
I guess I want to know what the correct samplib member I should be using. tbe the DPRSMF specifies to use SMF files, which is not what I want.
Step1 in the samplib DPRSMF, DPRDSMF,
I have studied from the SAMPLIB, (DPRSUMNL) , and DPRSMF -. Yesterday some one said to use the DOMRPT jcl and use the traceworkfiles, as input to DPSUMLD.
So in this JCL DPRSMF, the steps are:
DPRSTAT - i would think I needed this step?
//*****WARNING - THIS STEP MUST BE RUN FOR STATISTICS **********
//*****WARNING - PROCESSING OR ELSE VERY LARGE NUMBERS**********
//*****WARNING - IN STATISTICS REPORTS WILL OCCUR **********
REPAIR - says to use IBM load utility , DSNUTILB OR IEFBR14 ( is this to just run Repairs)?
DPSUMLD - is THIS AND dprstat NEEDED?
BUILD DB2 LOAD CONTROL STATEMENTS, *
SUMMARIZE ACCOUNTING AND DDF ACCOUNTING RECORDS,*
PURGE OLD RECORDS *
DPRSUMNL - SUMMARIZE OR RE-SUMMARIZE ACCOUNTING TABLES.
NOTE: THIS JOB USES THE BMC NGT LOAD , I may use the BMC Load plus example MEMBER DPRSMFLP
NOTE: DETERMINE SUMMARIZATION INTERVAL AND FREQUENCY
DEFAULTS ARE: 1 DAY INTERVAL, RUN WEEKLY
NOTE: ADJUST CONTROL STATEMENTS:
RELATIVE START DATE OF SUMMARIZATION (SUMMSTART)
SUMMARIZATION INTERVAL (SUMMINT)
PURGE RETENTION PERIOD (RETPD) (DEFAULT 60 DAYS)
DPRSMF - takes in SMF files , but I want to use the Data Collector files. First I just want to use the ARCHIVED files, but then I would like to use active Data.
JOB TO EXTRACT DB2-RELATED RECORDS FROM
SMF OR MVDB2-DATA COLLECTOR ARCHIVE FILES AND LOAD
THEM INTO MVDB2 PERFORMANCE REPORTER TABLES
I would like to go back as far as possible to get performance data. I know we created BMC Apptune reports using just dates and the files needed would be
Dynamically allocated. I want to use this as well for loading the BMC Mainview data.
In the Near future we are going to request someone from BMC to work with me and the best ways to use MAINVIEW data
I understand that I use this control card //DOMBARC dd may be coded with the COPYDIR name so that automatic selection of the archives can be done (no DATASOURCE or TRACEIN DD needed)
for the dynamic allocations.
DATASOURCE ( COLLECTOR (dc01) - DATA COLLECTOR TO RETRIEVE DATA
FROM. SPECIFY COLLECTOR() TO
HAVE A DATA COLLECTOR SELECTED
Do I use this control card BACCTDR , for producing the mainview data to be loaded.
For the DOMRPT1 do I just put the dates ? Are there control cards I use to let the utility know that these are for Mainview tables and not the APPTUNE tables?
Do I need to use
1 of 1 people found this helpful
In MainView for Db2, there are 2 main types of reports:
1. Data collector reports, produced using the DOMBRPT1 utility. This produces reports directly from the active/archive datasets and is the same as the Apptune reporting utility, except it produces different reports based on the report name in the SYSIN. BACCTDR is one such report which you can run using SYSIN syntax like this:
This will run the report for the 24 hour period starting at midnight yesterday. Alternatively, you can specify exact start and end date and times. The syntax for that is the same as for producing Apptune reports.
2. Mainview Performance Reporter produces reports from Db2 tables using DPRREPT. If you want to do the second method, then there are SAMPLIB members to load the data. These are DPRARC, DPRARCLP and DPRARCNL depending on which Db2 load utility you have. I am not sur iif you have access to MainView for DB2 Performance Reporter User Guide but the control cards are all detailed there