IDMS

 View Only
Expand all | Collapse all

How to setup a SREPORT 007

  • 1.  How to setup a SREPORT 007

    Posted Aug 22, 2019 12:36 PM
    Would anyone have a SREPORT 007 example ?  JCL example?


  • 2.  RE: How to setup a SREPORT 007

    Posted Aug 23, 2019 11:45 AM

    You need the usual Culprit JCL with the following SYSIN.
    The log backups would be listed in SYS010

    //SYSIN DD *
    DATABASE DICTNAME=SYSDIRL
    IN 280 V DD=SYS010
    PARAM=LIST
    USE 'SREPORT 000'​
    USE 'SREPORT 007'​



    ------------------------------
    Tommy Petersen
    ------------------------------



  • 3.  RE: How to setup a SREPORT 007

    Posted Aug 23, 2019 01:39 PM
    Tommy,
    Thank you for your reply.  I's great help.  I didn't see ​in the documentation to use the 'DD=' statement.  I was using 'FN=' and of course that didn't work. 
    Now I'm trying to figure out how to read the input file using Culprit commands.  I'm new to this stuff.  Anymore help would be appreciated. 

    Thanks again,
    Mike Barta


  • 4.  RE: How to setup a SREPORT 007

    Posted Aug 23, 2019 03:41 PM
    //SYSIN    DD  *                             
     DATABASE DICTNAME=SYSDIRL DBNAME=IDOTDICT   
     IN 280 V DD=SYS010                          
     USE 'SREPORT 000' (00001 0001 99365 2355 1) 
     USE 'SREPORT 005'                           
     USE 'SREPORT 006'                            


    ***********  END OF FILE  ******************************************************                   
               0 INPUT RECORDS READ                                                                    
        SELECTION SPECIFICATION STATISTICS                                                             
        BEGINNING      TIMES        TIMES        TIMES      NUMERIC    SUBSCRIPT                       
        REFERENCE     TESTED         TRUE        FALSE       ERRORS       ERRORS                       
         NUMBER                                                                                        
              1        2,714            0        2,714            0            0                       
      C750009 RECORDS WRITTEN FOR REPORT 00 --           0                                             
    REPORT NO. 05                                IDMS-DC TASK STATISTICS BY USER ID  R17.0             
              SELECTED FROM:  00001  00:01      TO:  99365  23:55                                      
                     ACTUAL:  00000  00:00      TO:  00000  00:00                                      
    USER ID:                                                                                           
                                                                                                       
            NO DATA FOR REPORT 5                                                                       
      C750009 RECORDS WRITTEN FOR REPORT 05 --           6                                             
    REPORT NO. 06                                IDMS-DC TASK STATISTICS BY LTERM ID  R17.0            
              SELECTED FROM:  00001  00:01      TO:  99365  23:55                                      
                     ACTUAL:  00000  00:00      END: 00000  00:00             
    NO DATA FOR REPORT 6                                             
      C750009 RECORDS WRITTEN FOR REPORT 06 --           6           
                              ​
    Not sure why I'm not retrieving any records.  Job is reading the input file cause number of tested is 2700 which is the number of recs in the archive file.

    Mike Barta


  • 5.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 08:13 AM

    Hi Mike, 

    If you have the Performance Monitor installed​ you may have turned off capturing of statistics in the DC Log.

    In the #PMOPT macro you would have DCSTATS=NO

    You can run SREPORT 017 to see the types of statistics you are collecting.



    ------------------------------
    Tommy Petersen
    ------------------------------



  • 6.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 09:18 AM
    I did LOOK PROGRAM=#PMOPT :

    0DC99E00 +0      7BD7D4D6 D7E34040 F1F0F0F7 F2F21042 #PMOPT  100722..  
    0DC99E10 +10     C3D6D7E8 D9C9C7C8 E3404DC3 5D40F2F0 COPYRIGHT (C) 20  
    0DC99E20 +20     F0F740C3 C14B40C1 D3D340D9 C9C7C8E3 07 CA. ALL RIGHT  
    0DC99E30 +30     E240D9C5 E2C5D9E5 C5C44B40 40404040 S RESERVED.       
    0DC99E40 +40     40404040 40404040 40404040 40404040                   
                        SAME AS PREVIOUS LINE                              
    0DC99E60 +60     C3C160C9 C4D4E240 F1F7F0F0 8000C140 CA-IDMS 1700..A   
    0DC99E70 +70     C0FF0000 00320032 1FF40000 00004040 {........4....    
    0DC99E80 +80     40400000 00000000 00000000 00000000   ..............  
    0DC99E90 +90     00000000 000A0014 0005000A 1FF40960 .............4.-  
    0DC99EA0 +A0     00000000 00000000 00000000 00000000 ................  
    0DC99EB0 +B0     E6000000 00000000 00000000 00000000 W...............  

    and ran SREPORT17 and it return all 0

    ***********  END OF FILE  ******************************************************                                   
               0 INPUT RECORDS READ                                                                                    
        SELECTION SPECIFICATION STATISTICS                                                                             
        BEGINNING      TIMES        TIMES        TIMES      NUMERIC    SUBSCRIPT                                       
        REFERENCE     TESTED         TRUE        FALSE       ERRORS       ERRORS                                       
         NUMBER                                                                                                        
              1        2,714            0        2,714            0            0                                       
      C750009 RECORDS WRITTEN FOR REPORT 00 --           0                                                             
    REPORT NO. 17                                      SUMMARY OF RECORDS READ  R17.0                               08/2
              SELECTED FROM:  00000  00:00      TO:  00000  00:00                                                      
                     ACTUAL:  00000  00:00      TO:  00000  00:00                                                      
        STATISTICS                     BELOW           BEFORE            PASSED TO             DATES/TIMES OF 1ST AND  
        RECORD TYPES                 DATE/TIME         TRIGGER           STATISTICS            LAST RECS OF EACH TYPE  
        STL/HST                        RANGE           STARTUP           ROUTINES              PASSED TO THE ROUTINES  
                                                       RECORDS                                                         
        00    - START UP                   0                   0               0                                       
                                                                                                                       
        01/01 - PUTJRNL REQ SIZE           0                   0               0                                       
        01/02 - LOADED PGM SIZE            0                   0               0                                       
        01/03 - QUEUE RECORD SIZE          0                   0               0                                       
        01/04 - SCRATCH REC SIZE           0                   0               0                                       
        01/05 - USER STG SIZE              0                   0               0     

     01    - SYSTEM STATS               0                   0               0        
     02    - TASK STATS                 0                   0               0        
     03    - TRANSACTION STATS          0                   0               0        
     04    - TASK CODE STATS            0                   0               0        
     05    - PROGRAM STATS              0                   0               0        
     06    - QUEUE STATS                0                   0               0        
     07    - LINE STATS                 0                   0               0        
     08    - PTERM STATS                0                   0               0        
     09    - ADS STATS                  0                   0               0        
          TOTALS                        0                   0               0        
    750009 RECORDS WRITTEN FOR REPORT 17 --          49                                                                 

    So does this mean the system is not collect STATS?

    Or am I missing something ?

    Mike Barta

    p.s.  Thanks for your help.



  • 7.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 10:00 AM

    Hi Mike,

    In that case you need to look at both the SYSTEM and ADSO statements in SYSGEN.
    In ADSO you need to have "DIALOG STATISTICS ON ALL"
    In SYSGEN on the STATISTICS parameter you need  "TRANSACTION" my guess is that you already have "TASK COLLECT" which is needed to implement task limits.

    Best regards



    ------------------------------
    Tommy Petersen
    ------------------------------



  • 8.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 10:48 AM
    I did command :
      SYSGEN DIS all SYS 10 with details :

    SYSGEN -
    STATISTICS INTERVAL 1800 NOLINE TASK COLLECT NOUSER NOTRANSACTION​

    ADSO -
    DIALOG STATISTICS OFF

    Mike


  • 9.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 11:37 AM

    ​With NOTRANSACTION you do not get transaction statistics collected or written. 
    The way I understand the INTERVAL is that you should get the interval statistics written every 30 minutes, however, DCSTATS=NO in the #PMOPT module might negate that.  If you use the default PMOPT module, I believe it uses DCSTATS=NO.

    It would really be a question for IDMS Support.

    ​​

    ------------------------------
    Tommy Petersen
    ------------------------------



  • 10.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 11:51 AM
    Tommy ,
    Thanks for the information.  You've been a great help.

    My client is running IDMS V17 which is unsupported.  They have elected not to upgrade since they are sun setting IDMS.  I will inform them extra work will be needed if the want to generate those SREPORTs.

    Thanks again for the help.
    Mike




  • 11.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 11:59 AM
    If they have the performance monitor they can run similar reports from there.​

    ------------------------------
    Tommy Petersen
    ------------------------------



  • 12.  RE: How to setup a SREPORT 007

    Posted Aug 26, 2019 12:16 PM
    I will recommend that option to them.  Thanks.​