New version of utils2_ak.

I have uploaded, and Walt has installed, a new version of utils2_ak which contains fixes to several of the utilities for AIX users to aid compilation and a mostly rewritten myschema.ec. The myschema code has been modularized making two new features possible: 1) SE support is now MOSTLY complete. (I say mostly because I have not had any opportunity to test it AT ALL. I will do so but any help is appreciated.) 2) The long promised split schema feature is now available. If you provide two filenames at the end of the commandline myschema.ec will output CREATE TABLE and table level permissions statements to the first (or primary schema) file and all other statements (like CREATE INDEX) to the second (or secondary schema) file. This is great for data loads and for cloning a server! You may want to edit the results still to move UNIQUE indexes from the secondary schema to the primary (and later versions may make this optional) but 90% of the work is now done for you (and for me ;-)) Enjoy. Art S. Kagel

In article <37F8E9D9.19DFBAF9@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >I have uploaded, and Walt has installed, a new version of utils2_ak which >contains fixes to several of the utilities for AIX users to aid compilation >and a mostly rewritten myschema.ec. The myschema code has been modularized >making two new features possible: > >1) SE support is now MOSTLY complete. (I say mostly because I have not > had any opportunity to test it AT ALL. I will do so but any help is > appreciated.) I will start testing tomorrow. We have several databases on SE 4.x and SE 7.x! >2) The long promised split schema feature is now available. If you > provide two filenames at the end of the commandline myschema.ec will > output CREATE TABLE and table level permissions statements to the first > (or primary schema) file and all other statements (like CREATE INDEX) to > the second (or secondary schema) file. This is great for data loads and > for cloning a server! You may want to edit the results still to move > UNIQUE indexes from the secondary schema to the primary (and later > versions may make this optional) but 90% of the work is now done for you > (and for me ;-)) > >Enjoy. > >Art S. Kagel -- David Williams

Great Dave. If you get it working even minimally send me a listing from: myschema -d <anydatabase> -t 'sys*' from both 4.x and 7.x please. (For the SE4 server you may have to use the -5 option to get it to work, let me know and I'll doc it.) Art S. Kagel David Williams wrote: > > In article <37F8E9D9.19DFBAF9@bloomberg.net>, Art S. Kagel > <kagel@bloomberg.net> writes > >I have uploaded, and Walt has installed, a new version of utils2_ak which > >contains fixes to several of the utilities for AIX users to aid compilation > >and a mostly rewritten myschema.ec. The myschema code has been modularized > >making two new features possible: > > > >1) SE support is now MOSTLY complete. (I say mostly because I have not > > had any opportunity to test it AT ALL. I will do so but any help is > > appreciated.) > I will start testing tomorrow. We have several databases on SE 4.x and > SE 7.x! > > >2) The long promised split schema feature is now available. If you > > provide two filenames at the end of the commandline myschema.ec will > > output CREATE TABLE and table level permissions statements to the first > > (or primary schema) file and all other statements (like CREATE INDEX) to > > the second (or secondary schema) file. This is great for data loads and > > for cloning a server! You may want to edit the results still to move > > UNIQUE indexes from the secondary schema to the primary (and later > > versions may make this optional) but 90% of the work is now done for you > > (and for me ;-)) > > > >Enjoy. > > > >Art S. Kagel > > -- > David Williams