Setting searchtime options

Search time options are used when REORG TABLESPACE copies the existing compression dictionaries for a table space that is defined with DATA CAPTURE CHANGES into the compression dictionary data set (CDDS), instead of reorganizing the table space. The Searchtime options panel lets you specify the timestamp that REORG TABLESPACE uses to determine which expansion dictionary to use to populate the CDDS. If the expansion dictionary that the target page set is currently using has an LRSN value that is later than the SEARCHTIME value, REORG searches for the prior expansion dictionary in the Db2 log and in SYSCOPY information. If a prior expansion dictionary exists, REORG copies that dictionary into the CDDS.

 AUTOXPRT V1R1 ------------ Searchtime Options ----------- 2023/10/20  13:12:14 
 Option   ===>                                                                  
                                                                                
   Creator: TWUSR      Name: TEST PROFILE                     User: TWUSR       
                                                     Db2 Subsystem: SS01        
   Enter the "Searchtime" options to associate with this utility profile        
                                                                                
     Searchtime  . . . . . . . . . . N   (N - None, T - Timestamp, L - Lde)     
                                                                                
     Timestamp value . . . . . . . .                                            
                                                                                
                                                                    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)                                                   
                      Minute(s)                                                 
                      Seconds(s)                                                
                                                                                

1. In the Searchtime field, indicate the type of timestamp that you want to set.
   • To specify that REORG populates the CDDS from the expansion dictionary that the target page set is currently using, type N in this field.
   • To specify a TIMESTAMP(6) constant that determines which expansion dictionary to use to populate the CDDS, type T in this field and enter a timestamp in the Timestamp field.
   • To specify an LDE, type L in this field and complete the Labeled Duration Expression fields.
2. Do one of the following:
   • If you specified to use a timestamp for the search time, enter a timestamp in the Timestamp value field.
   • If you specified to use an LDE for the search 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.

3. Press PF3 (END) to return to the Online Reorg options panel.