trafodion-development team mailing list archive

Thread
Date

Trafodion support for ANSI schemas

To: "trafodion-development@xxxxxxxxxxxxxxxxxxx" <trafodion-development@xxxxxxxxxxxxxxxxxxx>
From: "Gray, Cliff" <Cliff.Gray@xxxxxx>
Date: Wed, 17 Dec 2014 21:12:04 +0000
Accept-language: en-US
Thread-index: AdAaPgp6Fy4iZyRDRki0U5Qbh38beg==
Thread-topic: Trafodion support for ANSI schemas

ANSI schemas have been merged to the main thread as of change 831.  With this change, you will now need to create a schema before creating objects in the schema.  After you rebase, you have three choices:

1)      Drop Trafodion and reinitialize
This is the simplest but you will lose all your data.

INITIALIZE TRAFODION,DROP;
INITIALIZE TRAFODION;


2)  Upgrade from .9 or earlier
if you have not rebased your instance for several weeks and are still running on .90, you can use the upgrade option:
INITIALIZE TRAFODION,UPGRADE;


3)      Upgrade/update .91
If you have already upgraded to .91 AND you want to keep your data, you can just upgrade the ANSI schema related metadata changes:

INITIALIZE TRAFODION,CREATE SCHEMA OBJECTS;

If your instance does not have any objects in the SEABASE schema and you want a SEABASE schema (recommended, it is the default), create it manually:
CREATE SCHEMA TRAFODION.SEABASE;


For more details on ANSI schemas see the blueprint at https://blueprints.launchpad.net/trafodion/+spec/security-ansi-schemas.