Export Informix Database Data

How to Export an Informix Database

Preparing the Environment

To prepare for database export, ensure an Informix server is running by using a Docker image. Download the latest Docker image version 14.10.FC1 from Docker Hub. Run the Docker image with the necessary flags and accept the license with -e LICENSE=accept. Use -it --name ifx -h ifx to name and host the container. Map the required ports with -p 9088:9088 -p 9089:9089 -p 27017:27017 -p 27018:27018 -p 27883:27883. Finally, run the image using ibmcom/informix-developer-database:latest.

Using dbexport Utility

Lock the database in exclusive mode as dbexport requires it. Use the dbexport utility to export both schema and data from the Informix database. The export will generate dbexport.out in the current directory, logging all messages. Foreign characters in data are supported. Confirm no fatal errors occur for successful export completion.

Post-export Steps

After exporting, use dbaccess in CLI mode with -- to interact with the database. Verify the list of tables with INFO TABLES;.

Best Practices for Export

Optimize deduplication by setting IFX_BAR_USE_DEDUP in the oninit environment. Avoid using IFX_BAR_USE_DEDUP with incremental backups and ensure to restart the server after setting the variable for changes to take effect.

Frequently Asked Questions

What is the purpose of the dbexport utility in Informix?

The dbexport utility is used to unload an entire database and its schema to disk or tape, creating text files for the data and a schema file that describes the database structure.

Can the dbexport utility be used on an HDR or SD secondary server?

No, the dbexport utility cannot be used on High-Availability Data Replication (HDR) secondary servers or Shared Disk (SD) secondary servers.

Are there any prerequisites before using the dbexport utility?

Yes, SELECT triggers must be disabled and MQ virtual tables must be dropped before using the dbexport utility.

How does the dbimport utility work in Informix?

The dbimport utility creates a new database and loads it with data from text files, which include a schema file and data files containing the database data.

What files does the dbexport command create and where?

The dbexport command creates a subdirectory named database.exp from the current location, a schema file named database.sql inside that subdirectory, and a file of messages named dbexport.out in the current directory.

Common Use Cases

• 
  Migrating data from an Informix database to another database management system
• 
  Creating backups of the Informix database for disaster recovery planning
• 
  Analyzing Informix data using external data analytics tools
• 
  Sharing Informix database contents with external stakeholders
• 
  Archiving historical data from an Informix database for compliance and auditing

Why Choose Sourcetable over Informix Export?

Discover the efficiency of Sourcetable as a modern alternative to traditional Informix export methods. With seamless integration of diverse data sources, Sourcetable simplifies data management.

Sourcetable's real-time data querying capabilities offer a significant advantage, allowing users to access and manipulate the latest information without the delays inherent in database exports.

Embrace the flexibility of a spreadsheet-like interface that Sourcetable provides, enabling intuitive data manipulation without the need for complex export processes or technical expertise.

Opt for Sourcetable to streamline your data workflows, reduce dependency on time-consuming exports, and enhance your decision-making with up-to-date data insights.