How To Load Data to table with large unl file
Hello, what is the best way to load data to informix tablea (running on windows) from large unl file (40GB) and record count around 80000000. any one has script to load data ? Thanks Pushpa
Create an external table for the unload file. For fastest loading make the
external table in EXPRESS mode. Then:
INSERT INTO premanent_table_name
SELECT * FROM external_table_name;
After the copy completes you will have to take a level 0 archive of the
server before you will be able to successfully index or access the new data
because of the EXPRESS mode load.
Next fastest: Use a normal mode external table (ie not EXPRESS) and use my
dbcopy utility to perform the copy. Be sure to define all character fields
in the external table as CHAR not LVARCHAR because of a bug in the ESQL/C
libraries that prevents dbcopy from copying from an LVARCHAR column type.
With this method there is no immediate need to archive the server. Dbcopy
also has options to perform partial commits to prevent long transaction
rollbacks (default: 10,000 rows).
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Sun, Dec 6, 2015 at 11:34 AM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote:
> Hello,
>
> what is the best way to load data to informix tablea (running on windows)
> from
> large unl file (40GB) and record count around 80000000.
>
> any one has script to load data ?
>
> Thanks
> Pushpa
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113fe84e7b164005263d77fe