ifx_getMartStat() function

The ifx_getMartStat() function returns the status of a single data mart as an unnamed row.

Syntax


1  ifx_getMartStat ( ' accelerator_name ' , ' data_mart_name ' )
accelerator_name
The name of the accelerator.
data_mart_name
The name of the data mart.

Usage

The ifx_getMartStat() function returns an unnamed row that contains the status for the data mart in the accelerator. The content of the row is the same as the content in the rows for the ifx_listMarts() function, which returns the status for all the data marts in an accelerator.

The row has the following columns:

name
The name of the data mart.
status
The status of the data mart. The status can have one of the following values:
Active
The data mart is available for query processing. You cannot use the loadMart() function to load the data mart when the data mart is in the Active state.
LoadInProgress
The data mart is being loading with data. It is not yet available for query processing.
LoadPending
The data mart has been defined successfully, but it is not yet being loading with data. It is not available for query processing.
Disabled
The data mart is deactivated. It is not available for query processing.
memory
The memory that is consumed by the data mart in MB.
lastload
The timestamp of last time that the data mart was loaded successfully.

Examples

The following example shows how to retrieve the unnamed row that contains the status of a single data mart.

EXECUTE FUNCTION ifx_getMartStat('MyAccelerator','Data_mart1');

The following example shows how to convert the returned result row into a table expression.

   SELECT c.* FROM TABLE(ifx_getMartStat('MyAccelerator','Data_mart1')) (c);