Re: Informix thread management

Posted in 2003

Rajib Sarkar — Fri, 12 Dec 2003 09:09:34 -0700 — source: Usenet: comp.databases.informix

--0__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: multipart/alternative; Boundary="1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E" --1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable U have got throttle controls which can essentially control how much of resources can be used by the threads. Please read the manual about PDQPRIORITY, MAXPDQPRIORITY, DS_TOTAL_MEMORY, DS_MAX_SCANS, DS_MAX_QUER= Y .. These are the onconfig / env./session parameters which can help you throttle the usage of mem resources by the parallel processing. HTH Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "Vijay" = <rudrappa@india.h To: <informix-list= @iiug.org> p.com> cc: = Sent by: Subject: Informix threa= d management owner-informix-li = st@iiug.org = = = 12/12/2003 05:22 = AM = Please respond to = rudrappa = = Hi All, I have fragmented my database & now want to use the parallel= database feature of Informix.. I read in a document that we need to limit the database's parallel processing feature because, the more t= he parallel threads spawned the more the resource used... Thus other process will have to wait till the memory used by the previous threads... Please guide me on how the paralled query threads are use= d in informix... Regards, Vijay Kumar.R Software Engg. HP-ISO Bangalore, Ph : 205 2640 = --1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body bgcolor=3D"#FFFFFF"> U have got throttle controls which can essentially control how much = of resources can be used by the threads. Please read the manual about P= DQPRIORITY, MAXPDQPRIORITY, DS_TOTAL_MEMORY, DS_MAX_SCANS, DS_MAX_QUERY= .. These are the onconfig / env./session parameters which can help you= throttle the usage of mem resources by the parallel processing. HTH Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison <img src=3D"cid:10__=3D88BBE769DFCB1A1E8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Vijay" &= lt;rudrappa@india.hp.com>">"Vijay" <rudrappa@india.hp.c= om> <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D88BBE769DFCB= 1A1E8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D88BBE769DFCB1A1E8f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D88BBE769DFCB1A1E8f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>"Vijay" <rudrappa@india.hp.com>= Sent by: owner-informix-list@iiug.org 12/12/2003 05:22 AM Please respond to rudrappa</ul> </ul> </ul> </ul> </td><td width=3D"100%"><img src=3D"cid:20__=3D88BBE769DFCB1A1E8f9e8a93= df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> To: <informix-list@iiug.or= g> cc: Subject: Informix thread mana= gement</td></tr> </table> <ul>Hi All, I have fragmented my database & now wa= nt to use the parallel database feature of Informix.. I read in a docum= ent that we need to limit the database's parallel processing feature be= cause, the more the parallel threads spawned the more the resource used= ... Thus other process will have to wait till the memory used by the pr= evious threads... Please guide me on how the paralled query threads are= used in informix... Regards, Vijay Kumar.R = Software Engg.<br= > HP-ISO Bangalore,= Ph : 205 2640 </ul> </body></html>= --1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E-- --0__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=88BBE769DFCB1A1E8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: image/gif;@

Related threads

How to get the sequence value in ESQL/C program?