Update Statistics

IDS 9.40.FC8X3 Solaris 10 SUN M5000 16*4 core CPU 128Gb Mem dostats version on this server:- Features Version 5.10, Source Revision: 1.125 Sorry to raise this topic again. We have a table with 654,484,092 rows, fragmentation is round robin in 8 fragments. Indexes are in their own dbspaces. There are approximately 400,000 rows added daily (no deletes, no updates). Using dostats to manage update statistics it took 29hours overall, output below Working on tjrnl: jrnl_id, line_id(LOW)...SUCCESSFUL (3 hrs 25 mins 57.326 Secs) acct_id, j_op_type(LOW)...SUCCESSFUL (2 hrs 16 mins 25.218 Secs) acct_id, cr_date(LOW)...SUCCESSFUL (14 hrs 29 mins 20.725 Secs) j_op_ref_key, j_op_ref_id(LOW)...SUCCESSFUL (2 hrs 11 mins 2.913 Secs) cr_date(LOW)...SUCCESSFUL (2 hrs 1 mins 40.404 Secs) jrnl_id, cr_date, j_op_type, j_op_ref_key, acct_id(HIGH)...SUCCESSFUL (5 hrs 18 mins 3.348 Secs) line_id, j_op_ref_id, user_id, amount, desc, balance(MEDIUM)...SUCCESSFUL (0 hrs 0 mins 43.592 Secs) Table tjrnl completed (29 hrs 43 mins 10.539 Secs) The script is run with the following DBUPSPACE=0:2048 PSORT_NPROCS=47 Command used to execute dostats was dostats -d <dbname> -t none -Q 30 -p -E -v -i @/informix/dostats/dostats_include_Thu >From previous conversations with Informix Tech Support I was told that a 'LOW' does not use PDQ so only has 1 thread scanning the whole table Is there anything else I can do to make this run quicker/faster/better? BTW, We'll be moving to 10.00.FC9 before the end of the month Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Share your photos with Windows Live Photos – Free. http://clk.atdmt.com/UKM/go/134665338/direct/01/