analytics/informix/etc/sysadmin/sch_save.sql

{**************************************************************************}
{*                                                                        *}
{*  Licensed Materials - Property of IBM and/or HCL                                  *}
{*                                                                        *}
{*  IBM Informix Dynamic Server                                           *}
{*  (c) Copyright IBM Corporation 2001, 2016. All rights reserved.        *}
{*  (c) Copyright HCL Technologies Ltd. 2017.  All Rights Reserved.         *}
{*                                                                        *}
{**************************************************************************}

{**************************************************************************
 *
 *  Preserve all the internal table data 
 *
 **************************************************************************}
database sysadmin;
insert into sysadmin:tenant select * from sysadmin_tmp:tenant;
insert into sysadmin:ph_allow select * from sysadmin_tmp:ph_allow;
insert into sysadmin:storagepool select * from sysadmin_tmp:storagepool;

INSERT INTO sysadmin:iwa_datamarts      SELECT * FROM sysadmin_tmp:iwa_datamarts;
INSERT INTO sysadmin:iwa_marttables     SELECT * FROM sysadmin_tmp:iwa_marttables;
INSERT INTO sysadmin:iwa_martpartitions SELECT * FROM sysadmin_tmp:iwa_martpartitions;
INSERT INTO sysadmin:iwa_martcolumns    SELECT * FROM sysadmin_tmp:iwa_martcolumns;
INSERT INTO sysadmin:iwa_dmd_marts      SELECT * FROM sysadmin_tmp:iwa_dmd_marts;
INSERT INTO sysadmin:iwa_dmd_tables     SELECT * FROM sysadmin_tmp:iwa_dmd_tables;
INSERT INTO sysadmin:iwa_dmd_columns    SELECT * FROM sysadmin_tmp:iwa_dmd_columns;
INSERT INTO sysadmin:iwa_dmd_refs       SELECT * FROM sysadmin_tmp:iwa_dmd_refs;
INSERT INTO sysadmin:iwa_dmd_refcols    SELECT * FROM sysadmin_tmp:iwa_dmd_refcols;
INSERT INTO sysadmin:iwa_tsvt_partcal   SELECT * FROM sysadmin_tmp:iwa_tsvt_partcal;
INSERT INTO sysadmin:iwa_tsvt_windows   SELECT * FROM sysadmin_tmp:iwa_tsvt_windows ;

close database;