Is rebinding required after upgrading to Easytrieve release 11.6?
search cancel

Is rebinding required after upgrading to Easytrieve release 11.6?

book

Article ID: 209401

calendar_today

Updated On:

Products

Easytrieve Report Generator PAN/SQL

Issue/Introduction

Upgrading to Easytrieve release 11.6, are DB2 rebinds required for the upgrade?

The Easytrieve compile and BIND job is going to create the other DBRM member:
...
//DB2PRE  EXEC PGM=DSNHPC,COND=(3,LT,GEN),    
//             PARM='HOST(ASM),XREF,SOURCE'   
//DBRMLIB  DD  DISP=SHR,DSN=your.DBRMLIB(
ezt+pgmn)

 

Environment

Easytrieve Report Generator, release 11.6
Pan/SQL 2.4C

 

Resolution

If the Easytrieve programs are bound dynamically, then no rebound is needed.  Pan/SQL runs fine with either release of the Easytrieve product and one plan is bound for all jobs. 

However, if the Easytrieve programs are bound statically with one plan per program, then they, of course, will be rebound when the DB2PRE step is run as part of the step.

Based on the above JCL, the DB2PRE step as noted is part of the JCL when plans are bound statically.

Please see knowledge article, 57006, which contains the sample IVP job when running Easytrieve release 11.6 DB2 programs statically and the DB2PRE steps is then executed with the DBRMLIB. 

Here is the knowledge article link: 
Knowledge Article 57006