8 Replies Latest reply on Feb 14, 2020 12:01 AM by David Linsell

    MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?

    Feli Brachthaeuser
      Share This:

      Hello

      MVDB2 Performance Reporter has DPDSPIN Datasets which are docuemnted by this:

      DPDSPIN DD

      Defines a spin file to retain SMF statistics records that end a period to resolve intervals on subsequent SMF processing

      The spin file is useful only when the same input source (such as an SMF Generation Data Group or Data Collector archive) is used for each DPRSMF run. 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. The DPRSMF job must run at regular intervals to ensure that no intervals are lost.

      If DPRSMF does not run at regular intervals, allocate a new spin file for each run. DMRSMF allocates the spin file with DISP=OLD. To create a new spin file, use the BBSAMP sample JCL member DPJSPIN.

      Step 2—Statistics consolidation - Documentation for MainView for DB2 12.1 - BMC Documentation

      As my customer is running various DPRSMF using the archives from the data collector as input, we are wondering how many DPDSPIN datasets we will need.

      Up until now, there has only be one, which is more related to the RTE than the environments as test and prod.

      It can easly happen that multiple jobs are running concurrently and more than one time per day.

      And DPDSPIN is allocated with DISP=OLD.

      What is your recommendations to prevent locking and data loss?

       

      Thanks,

      Feli

        • 1. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
          Simon Chang

          Hi Feli

           

          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.

           

          Regards

          Simon

          • 3. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
            carol goldberg

            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?

            • 4. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
              David Linsell

              Hi Carol,

               

              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

               

              Dave

              • 5. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
                carol goldberg

                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.

                 

                 

                Regards, Carol

                 

                 

                Carol Goldberg

                Texas Comptroller of Public Accounts

                Software Development

                512-475-0612

                Carol.Goldberg@cpa.texas.gov<mailto:Carol.Goldberg@cpa.texas.gov>

                111 E 17th Street

                Austin, Texas 78774

                • 6. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
                  carol goldberg

                  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:

                  DPRDSMF

                  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       

                      FOR REPORTING.      

                   

                                              

                   

                   

                  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

                   

                  Thanks, Carol

                  • 7. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
                    carol goldberg

                    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 

                                                                                           FOR YOU.                       

                    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

                    • 8. Re: MVDB2 - PR: DPDSPIN - how many spin datasets are Best Practice?
                      David Linsell

                      Hi Carol,

                      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:

                      REPORT(NAME(BACCTDR) -       

                      INTERVAL(START(-1,00:00:01)   FOR(1)

                      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

                       

                      Regards

                       

                      Dave

                      1 of 1 people found this helpful