IBM® Informix® Warehouse Accelerator, Version 12.10

SQL administration routines

You can use the Informix® Warehouse Accelerator functions and procedures from the command line or in an application to automate administration tasks.

The names of the functions and the procedures are not case sensitive.

Here are the character limits for the SQL administration routine elements:

Accelerator name length - 128 characters
IP address length - 256 characters
Data mart name length - 128 characters
Schema name length - 128 characters
Table name length - 128 characters
Column name length - 128 characters
Authentication token length - 100 characters (generated by the system)

You must have permissions to administer Informix Warehouse Accelerator. For more information, see Permissions for administering Informix Warehouse Accelerator.

You cannot run Informix Warehouse Accelerator functions and procedures from the sysadmin database.

SQL administration routines sorted by task
SQL administration routines are sorted into logical areas based on the type of task.
ifx_createMart() function
The ifx_createMart() function creates a data mart in an accelerator.
ifx_def2Mart() procedure
The ifx_def2Mart() procedure uses the ifx_getMartdef() function to retrieve the data mart definition from an accelerator. It then uses the ifx_xml2Mart() procedure to store the data mart definition XML file in the data mart schema tables.
ifx_dropMart() function
The ifx_dropMart() function drops (removes) the data mart from an accelerator.
ifx_dropPartMart() function
The ifx_dropPartMart() function removes the data in one partition in a fragmented table or all of the data from a non-fragmented table.
ifx_genMartDef() function
The ifx_genMartDef() function returns a character large object (CLOB) that contains the data mart definition in XML format.
ifx_getdwaMetrics() function
The ifx_getdwaMetrics() function returns metrics about an accelerator.
ifx_getMartdef() function
The ifx_getMartdef() function retrieves the data mart definition from an accelerator and returns it as a character large object (CLOB) in XML format.
ifx_getMartStat() function
The ifx_getMartStat() function returns the status of a single data mart as an unnamed row.
ifx_listMarts() function
The ifx_listMarts() function returns a set of unnamed rows that contain the status for all the data marts in an accelerator.
ifx_loadMart() function
The ifx_loadMart() function populates an empty data mart in an accelerator with data. The data is copied from the database tables that are referenced in the data mart definition.
ifx_loadPartMart() function
The ifx_loadPartMart() function loads the data into one partition in a fragmented table or into a non-fragmented table.
ifx_probe2Mart() procedure
The ifx_probe2Mart() procedure converts the data that is gathered from probing into a data mart definition.
ifx_refreshMart() function
The ifx_refreshMart() function checks for data changes in individual partitions and refreshes the changed partitions.
ifx_removeDWA() function
The ifx_removeDWA() function removes (drops) an accelerator from the accelerator server. This function removes the connectivity information from the sqlhosts file in the Informix database server. The data marts that are associated with the accelerator are not removed, but they are not accessible. Drop the data marts before you drop the accelerator.
ifx_removeTrickleFeed() function
The ifx_removeTrickleFeed() function stops trickle feed so that data in the data mart is no longer continuously refreshed.
ifx_setMart() function
The ifx_setMart() function changes the state of a data mart from Active to Disabled or from Disabled to Active.
ifx_setupDWA() function
The ifx_setupDWA() function creates an accelerator in an accelerator server. This function creates the connection between the database server and the accelerator server. You can also use this function to renew the connectivity information for an accelerator.
ifx_setupTrickleFeed() function
The ifx_setupTrickleFeed() function enables the continuous refreshing of data in the fact and dimension tables of the data mart as the data changes in the database.
ifx_TSDW_createWindow() function
The ifx_TSDW_createWindow function creates a time window to limit the amount of time series data in a time series virtual table of a data mart.
ifx_TSDW_dropWindow() function
The ifx_TSDW_dropWindow function removes time windows from a time series virtual table in a data mart.
ifx_TSDW_moveWindows() function
The ifx_TSDW_moveWindows function moves time windows in a time series virtual table within a data mart.
ifx_TSDW_updatePartition() function
The ifx_TSDW_updatePartition function refreshes the time series data within a time series virtual table in a data mart.
ifx_TSDW_setCalendar() function
The ifx_TSDW_setCalendar function assigns a time series calendar to a time series virtual table in a data mart.
ifx_xml2Mart() procedure
The ifx_xml2Mart() procedure converts a data mart definition from XML format into data mart schema tables.

Parent topic: Informix Warehouse Accelerator

Related concepts:

Permissions for administering Informix Warehouse Accelerator

Related information:

Privileges required to create a routine

Granting the EXTEND Role

Examples exchange | Troubleshooting

To find the PDF, see Publications for IBM Informix Warehouse Accelerator 12.10.
For the release notes, see the Release Notes topic.

Release date: March 2015