ifx_takefrag()

Description:

Extract fragmentation information from the database.

Syntax:

ifx_takefrag(ifxconn, table1,table2,...)

Note:

The function 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.

Parameters:

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