Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

-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.

(PTF BQU1030 applied) 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*