Re: PDQ

Attachment is missing!!! Gorazd "Rajib Sarkar" <rsarkar@us.ibm.com> wrote in message news:bn8r6t$2v2$1@terabinaries.xmission.com... > > Actually, Obnoxio is kind of right ..:-) Although this parameter is not > new, this parameter has been "upgraded" to accomodate a) More memory for > sorting b) To print out the progress of update stats (explain plan). > > Previously, the default was 4MB for sorting ...but now its 15MB default and > it can be set to 50MB by using DBUPSPACE but if you want more than that and > do it in parallel u will hv to use the PDQPRIORITY variable setting in > order to control that. I am attaching a white paper I had written on the > same subject ... > > HTH > (See attached file: UpdateStatisticsHeadsupArticle.doc) > > Thanx much, > > Rajib Sarkar > Advisory Software Engineer (RAS) > IBM Data Management Group > Ph : (602)-217-2100 > Fax: (602)-217-2100 > T/L : 667-2100 > > As long as you derive inner help and comfort from anything, keep it -- > Mahatma Gandhi > > > > "Mark D. Stock" > <mdstock@MydasSol To: Obnoxio The Clown <obnoxio@hotmail.com> > utions.com> cc: informix-list@iiug.org > Sent by: Subject: Re: PDQ > owner-informix-li > st@iiug.org > > > 10/23/2003 01:50 > AM > > > > > > Obnoxio The Clown wrote: > > > David E. Grove wrote: > > > >>>makes a big difference to stuff like index creation and update stats. > >> > >>We learned to be careful with PDQ and UPDATE STATISTICS. > > > > There is a new environment variable (DBUPSPACE?) which, when used with > PDQ > > will allocate more memory for the update statistics process which means > > that sorting of the index data will take place in parallel, which is much > > > faster. However,what you're describing is the documented behaviour of SP > > compilation. So yes, you don't want to do this for SPs, but you do want > to > > do it for data. > > No no no, it certainly isn't DBUPSPACE. That is a very old parameter that > LIMITS the amount of memory that UPDATE STATISTICS can use to 4Mb. Unless > they've changed it. > > Speaking of old parameters, you can also set PSORT_NPROCS to help optimise > parallel sorts during UPDATE STATISTICS. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| > | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| > | +-----------------------------------+//// / ///| > | |We value your comments, which have |/// / ////| > | |been recorded and automatically |// / /////| > | |emailed back to us for our records.|/ ////////| > +----------------------+-----------------------------------+-----------+ > > sending to informix-list > > --0__=88BBE75BDFC2E7E88f9e8a93df938690918c88BBE75BDFC2E7E8 > Content-type: application/msword; > name="UpdateStatisticsHeadsupArticle.doc" > Content-Disposition: attachment; filename="UpdateStatisticsHeadsupArticle.doc" > Content-transfer-encoding: base64 > > 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAANAAAAAAAAAAA > EAAANgAAAAEAAAD+////AAAAADMAAAD///////////////////////////////////////////// > //////////////////////////////////////////////////////////////////////////// > //////////////////////////////////////////////////////////////////////////// > //////////////////////////////////////////////////////////////////////////// > //////////////////////////////////////////////////////////////////////////// > //////////////////////////////////////////////////////////////////////////// > //////////////////////////////////////////////////////////////////////////// > ///////////////////////////////////////////////////////////////////////////s > pcEATSAJBAAA8BK/AAAAAAAAEAAAAAAABAAAChYAAA4AYmpiauI94j0AAAAAAAAAAAAAAAAAAAAA > AAAJBBYAIioAAIBXAACAVwAAChIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//w8AAAAA > AAAAAAD//w8AAAAAAAAAAAD//w8AAAAAAAAAAAAAAAAAAAAAAGwAAAAAAIIBAAAAAAAAggEAAIIB > AAAAAAAAggEAAAAAAACCAQAAAAAAAIIBAAAAAAAAggEAABQAAAAAAAAAAAAAAJYBAAAAAAAATggA > AAAAAABOCAAAAAAAAE4IAAAAAAAATggAAAwAAABaCAAAHAAAAJYBAAAAAAAAiBUAAPgAAACCCAAA > AAAAAIIIAAAAAAAAgggAAAAAAACCCAAAAAAAAIIIAAAAAAAAgggAAAAAAACCCAAAAAAAAIIIAAAA > AAAABxUAAAIAAAAJFQAAAAAAAAkVAAAAAAAACRUAAAAAAAAJFQAAAAAAAAkVAAAAAAAACRUAACQA > AACAFgAAIAIAAKAYAACMAAAALRUAABUAAAAAAAAAAAAAAAAAAAAAAAAAggEAAAAAAACCCAAAAAAA > AAAAAAAAAAAAAAAAAAAAAACCCAAAAAAAAIIIAAAAAAAAgggAAAAAAACCCAAAAAAAAC0VAAAAAAAA > ZgkAAAAAAACCAQAAAAAAAIIBAAAAAAAAgggAAAAAAAAAAAAAAAAAAIIIAAAAAAAAQhUAABYAAABm > CQAAAAAAAGYJAAAAAAAAZgkAAAAAAACCCAAALgAAAIIBAAAAAAAAgggAAAAAAACCAQAAAAAAAIII > AAAAAAAABxUAAAAAAAAAAAAAAAAAAGYJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA > AAAAAAAAAAAAAAAAAAAAAAAAAAAAgggAAAAAAAAHFQAAAAAAAGYJAAD4AQAAZgkAAAAAAABeCwAA > cgAAAAcUAABUAAAAggEAAAAAAACCAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA > AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABxUAAAAAAACCCAAAAAAAAHYIAAAMAAAAUDdrL6jW > wQGWAQAAuAYAAE4IAAAAAAAAsAgAAIgAAABbFAAADgAAAAAAAAAAAAAABxUAAAAAAABYFQAAMAAA > AIgVAAAAAAAAaRQAAJ4AAAAsGQAAAAAAADgJAAAuAAAALBkAAAAAAAAHFQAAAAAAAGYJAAAAAAAA > lgEAAAAAAACWAQAAAAAAAIIBAAAAAAAAggEAAAAAAACCAQAAAAAAAIIBAAAAAAAAAgDZAAAAVXBk > YXRlIFN0YXRpc3RpY3MgSW1wcm92ZW1lbnRzIGluIDcuMzEuW1UvRl1EMiBhbmQgOS4zMC5bVS9G > XUMyDQ1XaGF0IGRvZXMgVXBkYXRlIFN0YXRpc3RpY3MgZG8/DVVwZGF0ZSBzdGF0aXN0aWNzIGhh > cyB0aHJlZSBtYWpvciBmdW5jdGlvbnM6DUNvbXBpbGUgU3RvcmVkIFByb2NlZHVyZXMNRHJvcHBp > bmcgLyBDcmVhdGluZyBEYXRhIGRpc3RyaWJ1dGlvbnMNQ29sbGVjdGluZyBTdGF0aXN0aWNzIGZv > ciB0aGUgT3B0aW1pemVyDQ1UaGUgaW1wcm92ZW1lbnRzIGluIHRoZSBuZXcgcmVsZWFzZSBjb25j > ZW50cmF0ZSBvbiBiKSBhbmQgYykuIFRoZXJlIGFyZSBubyBzaWduaWZpY2FudCBjaGFuZ2VzIHRv > IHRoZSB1c2FnZSBvZiBVUERBVEUgU1RBVElTVElDUyBhcyB0aGUgc291cmNlIGNvZGUgaGFzIGJl > ZW4gcmUtd3JpdHRlbiBhbmQgaXMgdHJhbnNwYXJlbnQgdG8gdGhlIHVzZXIuIEJ1dCwgbm93IGlu > IHRoZSBuZXcgdmVyc2lvbnMgdGhlIERCQSBjYW4gZm9sbG93IHRoZSBwcm9ncmVzcyBvZiBVcGRh > dGUgU3RhdGlzdGljcyBhbmQgYWxzbyB0d2VhayB0aGUgbWVtb3J5IGFuZCBQRFFQUklPUklUWSB0 > byBtYWtlIGl0IGdvIGZhc3Rlci4NDVVwZGF0ZSBTdGF0aXN0aWNzIGluIFByZXZpb3VzIFZlcnNp > b25zDVRoaXMgdXNlZCB0byBydW4gaW4gYSBTSU5HTEUtVEhSRUFERUQgZmFzaGlvbiBzbyBpZiBh > IERCQSB3YW50ZWQgc29tZSBraW5kIG9mIHBhcmFsbGVsaXNtLCBoZS9zaGUgd291bGQgcnVuIG11 > bHRpcGxlIFVQREFURSBTVEFUSVNUSUNTIG9uIGRpZmZlcmVudCBjb2x1bW5zIHNpbXVsdGFuZW91 > c2x5LiANT25seSA0TUIgd2FzIGFsbG9jYXRlZCBmb3IgU09SVElORyBTUEFDRSB3aGljaCBmb3Jj > ZWQgdGhlIGVuZ2luZSB0byBkbyBtdWx0aXBsZSBzY2FucyBvZiB0aGUgdGFibGUgaWYgaXQgd2Fz > IGEgcHJldHR5IGJpZyB0YWJsZS4gDURCVVBTUEFDRSBlbnZpcm9ubWVudCB2YXJpYWJsZSB3YXMg > dXNlZCB0byBjb250cm9sIHRoZSBVUERBVEUgU1RBVElTVElDUyBkaXNrIHNwYWNlLg1ObyBtZXRo > b2Qgb3IgdXRpbGl0eSB0byBtb25pdG9yIHRoZSBwcm9ncmVzcyBv

Ups! Sory about that - attachment was inlined and I've missed it. Gorazd "Gorazd Hribar Rajteriďż˝" <REMOVE_gorazd.hribar@telekom.si> wrote in message news:p53mb.4860$2B6.908976@news.siol.net... > Attachment is missing!!! > > Gorazd >