informix huge db creation

Question

how to create huge database in informix ids 11.50

Answer 1

Is 2+ Terabytes big enough for you?.. Best way is to create a table, then load an ascii file into it. I have a 2TB+ (nrows=10M, rowsize=2048) ascii test file (with pipe delimiters) which has unique: fullnames, adresses, phone numbers and a variety of other datatypes, like DATE, SMALLINT, DECIMAL (9,2), etc. for testing/benchmarking purposes.

Problem is. how can i get it to you?

You could also create an SPL to insert random data, but for a huge test table, its not going to produce realistic or meaninful data for test purposes.

Answer 2

It is not very different from creating normal database. You can create tables as normal, but then you fill tables with huge amount of data. I think the best you can do is to create application that will fill database with random data. Of course you can use some real data like dates, city names, first names etc, or create "looking normal" names using Markov chain. Look at some examples in Python: Python Markov Chains and how to use them.

For massive inserts you should use PreparedStatement (this is quite easy with Java or Jython), or create huge text file and load them using dbimport.