V6 Migration/Missing colon - REXX to regenerate new format DBRMs

Venkat (PCA) Pillay

V6 Migration/Missing colon - REXX to regenerate new format DBRMs
Dear Listserv folks

For those, who are migrating to V6 and still have useful PLAN-DBRM
or packages, which were pre-compiled during V2.2 and prior and may/may not
have missing colons, I have a useful REXX.

The REXX exec reads SYSIBM.SYSSTMT or SYSIBM.SYSPACKSTMT and generates DBRM
as if they have been pre-compiled fresh in V5. This should take care of
migrating DBRMs from older version to newer version (regardless of colon for
host variables missing or not).

I will post the REXX to listserv document and hope that this will be useful.
This has been tested for about 1000 DBRMs in my shop and hopefully would
work for the most of the situations. However, it would be the best to backup
the catalog before binding with regenerated versions of DBRMs so that you
could backout just in case the REXX has goofed. Or bind the DBRMs into
altogether separate collections or plans.

Regards,
Venkat Pillay



Roger Miller

Re: V6 Migration/Missing colon - REXX to regenerate new format DBRMs
(in response to Venkat (PCA) Pillay)
Thanks to Venkat and Merrill Lynch for this. For customers who lost source
code or received a vendor package without source, this is probably the best
technique for migration.

Those who have the source code are better off changing the source if they
can, but this will help some to migrate sooner, knowing that a rebind will
not cause failures.

Please test.

Roger Miller, DB2 for OS/390