Monday, September 26, 2011

DB2: Sample REBIND job

The below sample job REBINDs a package.

//BIND EXEC  PGM=IKJEFT01                                          
//SYSTSPRT DD SYSOUT=*                                             
//SYSPRINT DD SYSOUT=*                                             
//SYSUDUMP DD SYSOUT=*                                              
//SYSTSIN  DD *                                                    
DSN SYSTEM(DB0T)                                                   
REBIND PACKAGE(MYCOLLID.TESTPGM.(2011-12-13-11.16.16.321748))+      
     ENABLE(*)+                                                     
     OWNER(T9289ATD)        QUALIFIER(T9289ATD)   VALIDATE(BIND)+  
     CURRENTDATA(NO)        ISOLATION(CS)         RELEASE(COMMIT)+ 
     EXPLAIN(YES)           DEGREE(1)             KEEPDYNAMIC(NO)+ 
     REOPT(NONE)            DBPROTOCOL(DRDA)      IMMEDWRITE(NO)+  
     ENCODING(37)           ROUNDING(HALFEVEN)                     
//*

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.