Description:
Extract fragmentation information from the database.
Syntax:
ifx_takefrag(ifxconn, table1,table2,...)
Note:
The external library function (See External Library Guide) extracts the fragmentation information of the specified table(s) from the database and writes it into the Ifxconn object. As there isn’t the fragmentation information in fragfile file, the txt file is empty; get the fragmentation file of all tables being fragmented if parameter table is absent.
Parameter:
|
ifxconn |
An Ifxconn object |
|
table |
The table being fragmented; can be omitted and can have multiple number of it |
Example:
|
|
A |
|
|
1 |
="d:/frag1.txt" |
Create and save a fragmentation information file. |
|
2 |
=ifx_conn("com.informix.jdbc.IfxDriver","jdbc:informix-sqli:192.168.0.7:8000/tpch:informixserver=tramsserver&user=informix&pwd=informix";A1) |
Connect to Informix database. |
|
3 |
=ifx_takefrag(A2) |
Extract fragmentation information of all specified tables. |
|
4 |
=ifx_takefrag(A2,"lineitem") |
Extract fragmentation information of table lineitem. |