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_autho rization,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.