In multi-version environments, SQL plans could be backward compatible
search cancel

In multi-version environments, SQL plans could be backward compatible

book

Article ID: 191057

calendar_today

Updated On:

Products

Datacom Datacom/DB Datacom/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.