Home
Data warehousingIn addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries. The resources that are external to the information center are marked as such.
Informix® Warehouse AcceleratorThe Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
ConfigurationYou must configure the accelerator server to work with the Informix® database server.
The ondwa utilityUse the ondwa utility to set up and work with the accelerator server.
ondwa listmarts commandUse the ondwa listmarts command to show information about existing data marts in the accelerators.

ondwa listmarts command

Use the ondwa listmarts command to show information about existing data marts in the accelerators.

To run this command, log on to the computer where the accelerator server is installed either as user root or as user informix. For you to run the command as user informix, specific memory resources must be available. For more information, see Users who can run the ondwa commands.

Usage:

$ ondwa listmarts

The following example lists the existing data marts that are found in the accelerators:

Found 4 marts:
mart="cq_sqrt", martid="151", accelerator="IDS.dwa1", state="ACTIVE", 
     epoch="1", lastload="2014-12-08 11:23:16.788831"
mart="iwadb_mart1", martid="152", accelerator="IDS.dwa1", state="ACTIVE", 
     epoch="3", lastload="2015-01-09 17:44:40.822332", 
     lastupdate="2015-01-13 16:43:49.048554"
mart="iwadb_mart2", martid="153", accelerator="IDS.dwa1", state="LOAD PENDING", 
     epoch="0"
mart="iwadb_mart2", martid="154", accelerator="IDS.dwa2", state="LOAD PENDING", 
     epoch="0"

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.