trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberta Marton <>
Subject RE: initialize trafodion?
Date Fri, 16 Jun 2017 00:03:53 GMT
You are the first person to add a new system SPJ for an official release.

For new installations, the new SPJ will be added automatically.
For existing installations, running :  "initialize trafodion, update libmgr" will add new
SPJ's and keep existing SPJ'S the same.

There needs to be a way when the new version of code is installed, is to somehow call:  "initialize
trafodion, update libmgr".  If we have a metadata change then this can be added.  But if we
don't change the metadata version then something needs to be designed.   Currently there are
various ways of doing this and we should standardize on some mechanism.

For example, adding HBase namespaces was added to initialize trafodion code.  Adding tenant
metadata was a change to the installation scripts.


-----Original Message-----
From: Eric Owhadi [] 
Sent: Thursday, June 15, 2017 4:05 PM
Subject: RE: initialize trafodion?

Cool, Thanks Dave,

-----Original Message-----
From: Dave Birdsall [] 
Sent: Thursday, June 15, 2017 5:59 PM
Subject: RE: initialize trafodion?

There are a variety of "initialize trafodion" variants, designed to upgrade just one or another

You can see the variety of syntax by looking at the parser (parser/SqlParser.y). The implementations
are in the sqlcomp directory.

-----Original Message-----
From: Eric Owhadi [] 
Sent: Thursday, June 15, 2017 3:54 PM
Subject: initialize trafodion?

Hi Trafodioneers,
I am studying how to create system SPJ.
I see in the code an set of instructions:
// To add a new procedure:
//   update export/lib/lib_mgmt.jar to include code for the new procedure
//   add a define representing the procedures below
//   add a static const QString representing the create procedure text
//   add a new entry in allLibmgrRoutineInfo
//   perform initialize trafodion, upgrade library management
// recommend that new procedures are added in alphabetic order

// At this time there is no support to drop or change the signature of an // existing procedure.
 Since customers may be using the procedures, it is // recommended that they not be dropped
or changed - instead add new ones // to handle the required change.

I am not sure how "initialize trafodion" work, since I have always used it only at first install.
I thought that this would wipe existing data, since it initializes metadata, right?
So there must be a mode that would just register the new system SPJ without really re-initializing
the metadata?


View raw message