Setting switch time options

Edit online

When performing an online REORG with SHRLVL CHANGE or REFERENCE, you can specify a switch time for the final log iteration of the LOG phase to begin.

About this task

On the Online Reorg options panel, enter Y in both the Switchtime options Include and Update fields and press Enter. The panel that is shown in the following figure is displayed:

Figure 1. Switchtime Options panel
 AUTOXPRT V1R1 ------------ Switchtime Options ----------- 2023/10/20  13:02:33 
 Option   ===>                                                                  
                                                                                
   Creator: TWUSR      Name: TEST PROFILE                     User: TWUSR       
                                                     Db2 Subsystem: SS13        
   Enter the "Switchtime" options to associate with this utility profile        
                                                                                
     Switchtime  . . . . . . . . . . N   (N - None, T - Timestamp, L - Lde)     
                                                                                
     Timestamp value . . . . . . . .                                            
                                                                                
     Newmaxro  . . . . . . . . . . .          (blank, Number)                   
                                                                                
                                                                    More:     + 
     Labeled Duration Expression                                                
     Base On Current Date/Timestamp      (D - Date, T - Timestamp)              
     Time Zone . . . . . . . . . . . N (Yes/No)                                 
     +/-   Value                                                                
                      Year(s)                                                   
                      Month(s)                                                  
                      Day(s)                                                    
                      Hour(s)

Procedure

  1. In the Switchtime field, specify the type of deadline for the switch time.
    Enter T for a timestamp or L for labeled duration expression, or enter N for no switch time deadline.
  2. (Optional) Specify a value in the Newmaxro field that will override the Maxro value.
    Leaving this field blank will result in NEWMAXRO NONE at job build time. Refer to the help panel for additional information about this field.
  3. Do one of the following:
    • If you specified to use a timestamp for the switch time, enter a timestamp in the Timestamp value field.
    • If you specified to use an LDE for the switch time, complete the following labeled duration expression fields.
      Based on Current Date/Timestamp
      Indicate in this field whether you want to use a date or timestamp as the base. Enter D for date or T for timestamp.
      Time Zone
      Type Y to specify that the CURRENT TIMESTAMP is compared with the time zone column. This option is available only for REORGs with labeled-duration-expressions using CURRENT TIMESTAMP.
      +/-
      In this column, type + to add the specified value, or - to subtract the specified value.
      Value
      Enter an integer value to correspond with the time value.
  4. Press PF3 (END) to return to the Online Reorg options panel.