Script: ifx_xferdb.sh
Author: Santosh Sajip

Purpose: Export a database using external tables with PIPES to a target
database on either the same instance or another IDS instance 
(on same or different node). 
- This script is platform and endian independent. 
- It is NOT TESTED/SUPPORTED for WINDOWS/MAC-OS currently.

 args: <source_dbname> <target_dbname> [<target_informixserver>]

       source_dbname: database name to be exported.
       target_dbname: target database name.
       target_informixserver: [optional] specified only if target database is 
                              on a different INFORMIXSERVER.
                              omit if source and target are on same instance.

 Description: 1. Creates database on target (if user specifies) with NO 
                LOG (search for LOG_STR if you need to change this default 
                 mode).
              2. Create all database objects (if user specifies).
              3. Disables indexes, constraints, triggers on target 
              4. Loads all the tables on the target server using external 
                 tables and PIPES.
              5. Re-enables indexes, constraints, triggers.

 REQUIREMENTS/LIMITATIONS:
       1. *** Search for TODO in this script to change settings. ***
       2. Assumes local and target instances are online.
       3. Assumes dbspaces with same size as local are created on target.
       4. sqlhosts files should contain the remote_informixserver entry and
          the source server should be trusted for user informix on remote.
     5. Does not handle SQL errors.
      6. IDS creates 1 FIFO VP by default. This script runs onmode -p +N fifo 
          to add N fifovps on the source where max(N) = 4.
          Run this on the remote manually before starting this script.
       7. Uses delimited format for tables with blobs and collection types, 
	   else uses informix binary.
       8. Supports Informix-XPS as source server.

  WARNING: If you see cpus being pegged, decrease the value in the NUM_CPUVPS 
  macro below.

Please send feedback to sanshi22@yahoo.com.