Posting from the Informix-list

I want to load millions of rows into my database. There is some parameter that expediate the process. Can I know which is that? Informix 8.3 Datawarehousing Sun soaris 2.6 dabccess 8.30 UC1 TIA

1. Create your table as 'RAW' 2. Try to use Light Appends. onstat -p will tell you about light appends progress. 3. Use external table to load (HPL, XPS version) 4. Use PDQ PRIORITY (in range) It will help you in starting your job ASAP when the min required resoureces are free. 5. Monitor your job with plan id ( use onstat -g rgm, for finding your plan id). Use onstat -g xqp <plan-id> and xqs and xmp for your job progressing. Light Appends are the fastest way of loading in XPS. If you are having light appends then you should not worry about anything else. Remember you need to configure your onconfig buffer parameters for light appends. I guess you can check out in Performance guide for correct configuration. Sanjeev K. Sagar Mukund_Shevkar@providian.com wrote: > I want to load millions of rows into my database. There is some parameter > that expediate the process. Can I know which is that? > Informix 8.3 Datawarehousing > Sun soaris 2.6 > dabccess 8.30 UC1 > > TIA