-REBD (Db2 REBIND)

The -REBD command invokes the Db2 REBIND command and is used for all application plans and packages that are invalidated by changes to other objects.

Authorization ID switching ensures that the rebind applies to the original creator of the plan or package. The parameters that are used are from the Db2 catalog.

Analysis groups REBIND statements into a single -REBD command unless one of the following conditions exists:

  • The package includes regenerating an advanced trigger.
  • The command includes 50 or more REBIND statements.


Example of -REBD command for plans

-AUTH 000690 JEO
-REBD 000700 REBIND PLAN ALUAPL1
             VALIDATE(BIND) ISOLATION(CS)
             ACQUIRE(USE)  RELEASE(COMMIT) EXPLAIN(NO)


Example of -REBD command for packages

-AUTH 000690 JEO
-REBD 000700 REBIND PACKAGE (ACM721_D_MAIN.AEXARNAM
             OWNER(RDAMLB) QUALIFIER(ACM721SN)
             VALIDATE(BIND) ISOLATION(CS)
             RELEASE(COMMIT) EXPLAIN(NO)

Example of -REBD command for packages with grouped REBINDs

-REBD 007450 REBIND PACKAGE ( -                                          
  R1BINL_VERS.R1BINL.(V222222222222222222222222222222222222222222B) +     
  ) -                                                                     
             PLANMGMT(OFF)    -                                          
  QUALIFIER( -                                                            
 R1BINDC +                                                               
  ) -                                                                     
             CURRENTDATA(NO)    -                                        
             APREUSE(NONE)         -                                     
             VALIDATE(RUN) ISOLATION(RR) -                               
             DEGREE(1) -                                                 
             RELEASE(COMMIT) EXPLAIN(NO)                                 

 REBIND PACKAGE ( -                                    
 R1BTB40A.R1BTB40A +                                   
 ) -                                                   
             PLANMGMT(OFF)    -                        
 QUALIFIER( -                                          
 R1BINDC +                                             
 ) -                                                   
             CURRENTDATA(NO)    -                      
             APREUSE(NONE)         -                   
             VALIDATE(RUN) ISOLATION(CS) -             
             DEGREE(ANY) -                             
             RELEASE(DEALLOCATE) EXPLAIN(NO)           
                                                     
 REBIND TRIGGER PACKAGE ( -                            
 R1BINDC.R1BINATR +                                    
 ) -                                                   
             APREUSE(NONE)         -                   
             BUSTIMESENSITIVE(YES) -                   
             SYSTIMESENSITIVE(YES) -                   
             ARCHIVESENSITIVE(YES) -                   
             PLANMGMT(EXTENDED)    -                   
             EXPLAIN(NO)                               
                                                     
 REBIND TRIGGER PACKAGE ( -                            
 R1BINDC.R1BINBTR +                                    
 ) -                                                   
             APREUSE(NONE)         -                   
             BUSTIMESENSITIVE(YES) -    
             SYSTIMESENSITIVE(YES) -  
             ARCHIVESENSITIVE(YES) -  
             PLANMGMT(EXTENDED)    -  
             EXPLAIN(NO)               

Related topic

Worklist-commands

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*