RE: dostats, PDQ and the sorting memory usage

Have a look at..... http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/0203miller.html Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: Jack Miller <jackmillerd@yahoo.com> >Reply-To: jackmillerd@yahoo.com >To: informix-list@iiug.org >Subject: dostats, PDQ and the sorting memory usage >Date: Tue, 16 Jan 2007 00:40:24 -0800 (PST) > >Hi all! >We are running 9.30.UC3 on Solaris 5.8. > >We are trying dostats (Features Version 5.10, Source Revision: 1.128 !) and >have a couple of misunderstanding. >First, we are getting different results (10% difference !) with "-Q 100" >option and with PDQPRIORITY=HIGH environment variable. The work was done >faster without PDQPRIORITY. Command line - dostats -d is_back -S -Q 100 -v2 >-X -e > >Second, we couldn't use more than 50Mb memory for sorting: >dostats -d is_back -S -Q 100 -v2 -X -e -t event >UPDATE STATISTICS:>================== > >Table: bp.event >Mode: HIGH >Number of Bins: 267 Bin size 11757 >Sort data 204.4 MB PDQ memory granted 214.6 MB >Estimated number of table scans 1 >PASS #1 >oper_code,currency,event_code,id_document,id_authorization,id_transaction > id_card,id_account_credit,id_eod,id_account_debit,id >Light scans enabled >Scan 20 Sort 8 Build 21 Insert 0 Close 0 Total 49 >Completed pass 1 in 0 minutes 49 seconds > >but > >dostats -d is_back -S -Q 100 -v2 -X -e >UPDATE STATISTICS:>================== > >Table: bp.event >Mode: HIGH >Number of Bins: 267 Bin size 11757 >Sort data 204.4 MB Sort memory granted 50.0 MB >Estimated number of table scans 5 >PASS #1 oper_code,id_card >PASS #2 event_code,id_account_credit,currency >PASS #3 id_document,id_eod >PASS #4 id_authorization,id_account_debit >PASS #5 id_transaction,id >Light scans enabled >Scan 7 Sort 2 Build 4 Insert 0 Close 0 Total 13 >Completed pass 1 in 0 minutes 13 seconds >Scan 6 Sort 0 Build 7 Insert 0 Close 0 Total 13 >Completed pass 2 in 0 minutes 13 seconds >Scan 4 Sort 1 Build 3 Insert 0 Close 0 Total 8 >Completed pass 3 in 0 minutes 8 seconds >Scan 5 Sort 3 Build 4 Insert 0 Close 0 Total 12 >Completed pass 4 in 0 minutes 12 seconds >Scan 4 Sort 5 Build 4 Insert 0 Close 0 Total 13 >Completed pass 5 in 0 minutes 13 seconds > >Any ideas would be helpful. >Jack Miller > > >--------------------------------- > Get your own web address. > Have a HUGE year through Yahoo! Small Business. >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Windows Live' Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb