ifx_getMartStat() function
The ifx_getMartStat() function returns the status of a single data mart as an unnamed row.
Syntax
>>-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);