OPS/MVS

  • 1.  OPSMVS Question >  How do you handle DB2 tasks?

    Posted Sep 26, 2018 12:51 PM

    Currently we only have the MSTR in SSM, Then Fire off of EOM rule for DB2* to count how many regions are left. before changed current state to DOWN.  

     

    NODB2S = OPSTATUS('S','A',DB2IDX)
    SAY "MISC.EOMDB2 - NODB2S='"NODB2S"'"

     

    Well that doesn't work so will because it fires like three times because the opstatus sees 0 but EOM is still firing (timing thing) ...



  • 2.  Re: OPSMVS Question >  How do you handle DB2 tasks?

    Broadcom Employee
    Posted Sep 28, 2018 02:44 PM

    Hi Randy,

     

    I believe the DB2 MSTR started task is always the last one to be stopped. In this case, you can considered DB2 in DOWN state when this task only is detected by EOM. Have you had any different results?

     

    Thank you,

    Mario



  • 3.  Re: OPSMVS Question >  How do you handle DB2 tasks?

    Posted Oct 01, 2018 12:26 PM

    Hi Carlos,

    I seeing some timing issues ...

    We have to put the DB2 regions in PASSIVE mode because a batch job that runs will do some maintenance and will bring in up/down itself .....

     

    DBP8 is the problem child ... it wont start because the state is in  DOWN_UNKNOWN.  I added another region that runs the same process and it works fine (DBT4) ....

     

    03:30:16 APPTBL.DBP8MSTR UPDATED by OPSOSF.SYSD REQ.SHUTDB2 DESIRED_STATE=DOWN

    03:30:16 APPTBL.DBP8MSTR UPDATED by OPSOSF.SYSD REQ.SHUTDB2 PREMODE=INACTIVE  

    03:30:16 APPTBL.DBP8MSTR: UP_DOWN MVSCMD=-DBP8STOP DDF MODE(FORCE)  

    03:30:16 APPTBL.DBP8MSTR: UP_DOWN MVSCMD=-DBP8STOP DB2 MODE(FORCE)  

     

    03:30:16 APPTBL.DBP8MSTR UPDATED by OPSMVS STATEMAN CURRENT_STATE=STOPPING

    03:30:16 APPTBL.DBP8MSTR: STOPPING_DOWN=NO ACTION FOUND        

     

    03:30:21 APPTBL.DBP8MSTR UPDATED by OPSOSF.SYSD REQ.SHUTDB2 MODE=PASSIVE      

    03:30:21 APPTBL.DBP8MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=UNKNOWN    

    03:30:21 APPTBL.DBP8MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=UNKNOWN    

     

    03:30:50 STC DBP8MSTR        

    03:30:50 OPS1181H MSTJCL00 OPSS (*Local*) MVS N/A EOM.EOMDBP8 |JBS ACTIVATE DB2

    03:30:50 |JBS ACTIVATE DB2P.DBP8DOWN GLOBAL                                  

    03:30:50 |JBS ACTIVATE DB2P.DBP8DOWN GLOBAL                                  

    03:30:50 DTM6420I JBS BINDING DISPLAY                                          

     

    03:30:51 APPTBL.DBP8MSTR UPDATED by *MASTER* EOM.EOMDBP8 CURRENT_STATE=DOWN

     

    03:30:54 /SDBP8                                                              

    03:30:54 /SDBP8                                                              

    03:30:54 IEF404I DH0899 - ENDED - TIME=03.30.54                              

     

    03:31:02 APPTBL.DBP8MSTR UPDATED by DH0899 CMD.SOFCMD MODE=ACTIVE            

    03:31:02 APPTBL.DBP8MSTR UPDATED by DH0899 CMD.SOFCMD DESIRED_STATE=UP        

    03:31:02 APPTBL.DBP8MSTR UPDATED by DH0899 CMD.SOFCMD PREMODE=ACTIVE  

     

    03:31:24 APPTBL.DBP8MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=UNKNOWN

     

    03:31:45 APPTBL.DBP8MSTR: DOWN_UNKNOWN=NO ACTION FOUND        

     

    ==================================================================================

     

    04:01:03 APPTBL.DBT4MSTR UPDATED by OPSOSF.SYSD REQ.SHUTDB2 DESIRED_STATE=DOWN

    04:01:03 APPTBL.DBT4MSTR UPDATED by OPSOSF.SYSD REQ.SHUTDB2 PREMODE=INACTIVE  

    04:01:03 TION FOR APPTBL.DBT4MSTR: UP_DOWN MVSCMD=*DBT4STOP DDF MODE(FORCE)  

    04:01:03   (*Local*) MVS N/A OPSYSTZS *DBT4STOP DDF MODE(FORCE)  

     

    04:01:03 APPTBL.DBT4MSTR UPDATED by OPSMVS STATEMAN CURRENT_STATE=STOPPING

    04:01:03 TION FOR APPTBL.DBT4MSTR: STOPPING_DOWN=NO ACTION FOUND

     

    04:01:08 APPTBL.DBT4MSTR UPDATED by OPSOSF.SYSD REQ.SHUTDB2 MODE=PASSIVE  

    04:01:08 APPTBL.DBT4MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=UNKNOWN

    04:01:08 APPTBL.DBT4MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=UNKNOWN

     

    04:01:31 STC DBT4MSTR

    04:01:31 APPTBL.DBT4MSTR UPDATED by *MASTER* EOM.EOMDB2 CURRENT_STATE=DOWN    

    04:01:31 APPTBL.DBT4MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=DOWN        

    04:01:31 APPTBL.DBT4MSTR UPDATED by OPSMVS STATEMAN DESIRED_STATE=DOWN

     

    04:01:35 OPS1181H MSTJCL00 OPSS (*Local*) MVS N/A EOM.EOMDB2 |JBS ACTIVATE DB2T

    04:01:35 |JBS ACTIVATE DB2T.DBT4DOWN GLOBAL                                  

    04:01:35 |JBS ACTIVATE DB2T.DBT4DOWN GLOBAL  

     

    04:04:41 APPTBL.DBT4MSTR UPDATED by DF0021.SYSI CMD.SOFCMD MODE=ACTIVE        

    04:04:41 APPTBL.DBT4MSTR UPDATED by DF0021.SYSI CMD.SOFCMD DESIRED_STATE=UP  

    04:04:41 APPTBL.DBT4MSTR UPDATED by DF0021.SYSI CMD.SOFCMD PREMODE=ACTIVE    

    04:04:41 APPTBL.DBT4MSTR: DOWN_UP MVSCMD=*DBT4 START DB2 PARM(DSNZDBT4

    04:04:41   (*Local*) MVS N/A OPSYSTZS *DBT4 START DB2 PARM(DSNZDBT4)        

    04:04:41 (DSNZDBT4)                                    



  • 4.  Re: OPSMVS Question >  How do you handle DB2 tasks?
    Best Answer

    Broadcom Employee
    Posted Oct 01, 2018 12:45 PM

    Hello Randy,

     

    I suggest that you open a support case. We need to review the OPSLOG and the involved rules to diagnose this exact situation.

     

    Regards,

    Mario