Informix thread management
This is a multi-part message in MIME format. ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BlankHi 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 the 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 used in informix... Regards, Vijay Kumar.R Software Engg. HP-ISO Bangalore, Ph : 205 2640 ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <TITLE id=3DridTitle>Blank</TITLE> <STYLE>BODY { MARGIN-TOP: 25px; FONT-SIZE: 10pt; MARGIN-LEFT: 25px; COLOR: #000000; = FONT-FAMILY: Arial, Helvetica; BACKGROUND-COLOR: #ffffff } P.msoNormal { MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; = FONT-FAMILY: Helvetica, "Times New Roman" } LI.msoNormal { MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; = FONT-FAMILY: Helvetica, "Times New Roman" } </STYLE> <META content=3D"MSHTML 6.00.2722.900" name=3DGENERATOR></HEAD> <BODY id=3DridBody style=3D"BACKGROUND-COLOR: #ffffff" bgColor=3D#ffffff = background=3D""> <DIV><SPAN class=3D359031912-12122003>Hi All,</SPAN></DIV> <DIV><SPAN class=3D359031912-12122003></SPAN> </DIV> <DIV><SPAN = class=3D359031912-12122003> I=20 have fragmented my database & now want to use the parallel database = feature=20 of Informix.. I read in a document that we need to limit the database's = parallel=20 processing feature because, the more the parallel threads spawned the = more the=20 resource used... Thus other process will have to wait till the memory = used by=20 the previous threads... Please guide me on how the paralled query = threads are=20 used in informix...</SPAN></DIV> <DIV><SPAN class=3D359031912-12122003></SPAN> </DIV> <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Regards,</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Vijay = Kumar.R</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Software = Engg.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>HP-ISO = Bangalore,</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Ph : 205 = 2640</FONT></DIV> <P> </P></BODY></HTML> ------=_NextPart_000_0043_01C3C0D8.C5ED7B90-- sending to informix-list
Vijay wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > > BlankHi 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 the 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 used in informix... > > Regards, > Vijay Kumar.R > Software Engg. > HP-ISO Bangalore, > Ph : 205 2640 > > > > ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Diso-8859-1"> > <TITLE id=3DridTitle>Blank</TITLE> > > <STYLE>BODY { > MARGIN-TOP: 25px; FONT-SIZE: 10pt; MARGIN-LEFT: 25px; COLOR: #000000; = > FONT-FAMILY: Arial, Helvetica; BACKGROUND-COLOR: #ffffff > } > P.msoNormal { > MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; = > FONT-FAMILY: Helvetica, "Times New Roman" > } > LI.msoNormal { > MARGIN-TOP: 0px; FONT-SIZE: 10pt; MARGIN-LEFT: 0px; COLOR: #ffffcc; = > FONT-FAMILY: Helvetica, "Times New Roman" > } > </STYLE> > > <META content=3D"MSHTML 6.00.2722.900" name=3DGENERATOR></HEAD> > <BODY id=3DridBody style=3D"BACKGROUND-COLOR: #ffffff" bgColor=3D#ffffff = > > background=3D""> > <DIV><SPAN class=3D359031912-12122003>Hi All,</SPAN></DIV> > <DIV><SPAN class=3D359031912-12122003></SPAN> </DIV> > <DIV><SPAN = > class=3D359031912-12122003> I=20 > have fragmented my database & now want to use the parallel database = > feature=20 > of Informix.. I read in a document that we need to limit the database's = > parallel=20 > processing feature because, the more the parallel threads spawned the = > more the=20 > resource used... Thus other process will have to wait till the memory = > used by=20 > the previous threads... Please guide me on how the paralled query = > threads are=20 > used in informix...</SPAN></DIV> > <DIV><SPAN class=3D359031912-12122003></SPAN> </DIV> > <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Regards,</FONT></DIV> > <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Vijay = > Kumar.R</FONT></DIV> > <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Software = > Engg.</FONT></DIV> > <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>HP-ISO = > Bangalore,</FONT></DIV> > <DIV><FONT face=3D"Comic Sans MS" color=3D#808000>Ph : 205 = > 2640</FONT></DIV> > <P> </P></BODY></HTML> > > ------=_NextPart_000_0043_01C3C0D8.C5ED7B90-- I might help if you promise to stop sending HTML. -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche
On Fri, 12 Dec 2003 07:22:55 -0500, Vijay wrote: > 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 the 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 used in informix... > > Regards, > Vijay Kumar.R > Software Engg. > HP-ISO Bangalore, > Ph : 205 2640 <HTML SNIPPED> PLEASE DO NOT POST HTML AND ESPECIALLY NOT MIME! Mime triples the bandwidth needed to download your postings! This is a text only newsgroup. PDQPRIORITY=-1 ==> Use the PDQPRIORITY in the engine's startup environment. PDQPRIORITY=0 ==> No parallel query at all. No parallel sorting. PDQPRIORITY=1 ==> Parallel fragment scanning and fragment elimination only. PDQPRIORITY=2->100 ==> Fill parallel query and sorting. Actual effective PDQPRIORITY is PDQPRIORITY / MAX_PDQPRIORITY). Now PDQPRIORITY >=2 implies acquisition of that percentage of the engine's resources including memory and CPU VPs. If you run a query with PDQPRIORITY=100 and MAX_PDQPRIORITY=100 then that query will a) have to wait until no other query is actively running, and b) will block all other queries once it starts until it completes. This implies that only 2 querys with an effective PDQPRIORITY of 50 can run concurrently, etc. Art S. Kagel