OE 12:Database maintenance capabilities via SQL, - Forum - OpenEdge RDBMS - Progress Community

OE 12:Database maintenance capabilities via SQL,

 Forum

OE 12:Database maintenance capabilities via SQL,

This question is answered

Hi,

I still haven’t received OE 12 and can’t verify. Therefore, I ask here.

On this page docs.progress.com/.../Online-schema-changes.html it says that it is now possible to update the schema online using OpenEdge SQL.

"With online schema changes made in OpenEdge SQL 12.0, multiple database operations can be performed concurrently without interfering with each other. The benefit of online schema changes is that OpenEdge SQL objects do not have an exclusive lock and are accessible to other queries and operations as a result."

Is this true for the PUB schema?

Regards,
Valeriy

Verified Answer
  • Valeriy,
     
    These sql online schema change capabilities in 12.0 are only for db objects (tables, etc.) in a non-PUB schema.
    Tables in the PUB schema are not eligible for these online changes currently.
     
    Hope this helps,         ….steve pittman
     
All Replies
  • Valeriy,
     
    These sql online schema change capabilities in 12.0 are only for db objects (tables, etc.) in a non-PUB schema.
    Tables in the PUB schema are not eligible for these online changes currently.
     
    Hope this helps,         ….steve pittman
     
  • steve pittman
    These sql online schema change capabilities in 12.0 are only for db objects (tables, etc.) in a non-PUB schema.
    Tables in the PUB schema are not eligible for these online changes currently.

    Thank you Steve!

    But what, then, is the point of this change? 

    100% of our customers use the only PUB schema to work with ABL. All of their applications are highly critical systems, and it is 100% ABL applications, that require the ability to manage a 24x7 database online. It turns out that they again will not get what they really need so much. Surprise

    How many clients use OpenEdge to store database objects in a non-PUB schema? why would they do that?