In multi-version environments, SQL plans could be backward compatible
book
Article ID: 191057
calendar_today
Updated On:
Products
DatacomDatacom/DBDatacom/AD
Issue/Introduction
We're in the middle of upgrading Datacom from Version 14.0 to 15.1. We compile our programs in the test environments and then extract SQL plans from test and import them into production. During the upgrade, will plans created on Version 15.1 test run successfully when imported into 14.0 production?
Environment
Release : 15.1
Component : CA DATACOM/DB
Resolution
As long as you do not use any new Version 15.1 features, but stick with the same feature set as you are currently using with Version 14.0, there should be no problems. The Auto-rebind process will bind the plan in the 14.0 environment, just as if you were to fallback from Version 15.1 to 14.0.
So the key is to contain your SQL features to what is available in the lowest available version. If you do this, all should be fine.
Additional Information
As always, please contact Broadcom support for CA Datacom if you have further questions.