How to create a huge Informix database?

Question

Can anyone provide me with a script for creating a huge database (for example, 2 GB of data) in IBM Informix Dynamic Server (IDS) version 11.50.FC4 on a Linux RHEL 64-bit machine?

Answer 1

I have a 2TB+ (nrows=10M, rowsize=2048) ascii load file (with pipe delimiters) for Informix which has unique: fullnames, adresses, phone numbers and a variety of other data types, like DATE, SMALLINT, DECIMAL (9,2), etc. for testing/benchmarking purposes.

Problem is - how can I get it to you?

Writing a script for generating a 2TB+ test file will not produce realistic data.

Answer 2

thanks,you can reach me at [email removed] is that script customizable by size, suppose I want to create db with 10 gb ,I have the informix server and schema ready.just need to import some data into it for testing purpose