Adding table spaces at job build time by using the Wildcard field

If you have an application that frequently adds or removes table spaces, you can use the Wildcard field to allow Db2 Automation Expertto resolve the object list at job build time. You can use this feature to avoid manually modifying the object profile whenever your application adds an object.

1. On the Enter Tablespace Like to Display window, enter a database, table space, or creator name or mask in the appropriate fields and enter Y in the Wildcard field, as showing in the following figure:

                          Enter Tablespaces Like to Display                        
                                                                                   
     Database Like. . *          Wildcard   Y (Yes/No)                             
     Tablespace Like. *          Exclude    I (E - Exclude, I - Include)           
     Creator Like . . PD*         >                                                
                                                                                   
     Process Dependent Indexes . . . . . . . . . . N (Yes/No)                      
     Process Referentially Dependent Tablespaces . N (Y - Yes, N - No,             
                                                      B - Build time Expansion,    
                                                      R - Run time Expansion)      
     Process Cloned Tables . . . . . . . . . . . . N (Yes/No)                      
     Process AUX Tablespaces . . . . . . . . . . . N (L - LOB, X - XML,            
                                                      A - All, N - No)             
     Process History and Archive objects . . . . . N (H - History,                 
                                                      A - Archive,                 
                                                      B - Both, N - None)          
     Advanced SQL . . . . N (Yes/No)    Update SQL N (Yes/No)                      
                                                                                   
                                                                                   
                                                                                   

2. Press Enter to continue.
   The window that is shown in the following figure is displayed.

                     Choose Partition Method                  
                                                              
     Utilities can run against each partition or it can       
     run against all partitions.  When DAJ explodes wild      
     card table and index spaces, which method would you      
     like partitioned spaces exploded?                        
                                                              
              Explode  A  (A - All, P - Partitioned)          
                                                              
                                                              

   Specify how table space partitions are processed. To handle all partitions (for example, equivalent to a REORG TABLESPACE), enter A in the Explode field. To individually process each partition (for example, equivalent to REORG TABLESPACE PART n), enter P in the Explode field.
3. Press Enter.
   The specified spaces are added to the Update Object Profile Display and a Y is entered in the Wildcard column.