informix 9.4 question: PDQPRIORITY and user threads

informix 9.4 question: PDQPRIORITY and user threads

Post by Mark.Ro.. » Thu, 22 May 2003 04:41:33



This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C31F07.D165AEC0
Content-Type: text/plain;
        charset="iso-8859-1"

        We are testing IDS 9.4 against linux Red Hat 7.2. Converting DB from
IDS 7.31 on HP-UX.

        We have PDQPRIORITY set to 1 for most of our 4gl applications. When
I do an onstat -u, I am seeing multiple user threads (sometimes 120) per
session. This type of high multi-threading does not occur with the same
PDQPRIORITY on IDS 7.31. In my testing, I have been setting the PDQPRIORITY
back to zero. This limits the user threads to one per session. And the
application performance does not seem affected. I am assuming since the 4gls
are programmed inline, with no forking, that using multiple user threads is
not helping.

        Has anyone else run into this issue?

Mark Roach
IT - Programmer/Analyst
Strategic Outsourcing, Inc.

------_=_NextPart_001_01C31F07.D165AEC0
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>informix 9.4 question: PDQPRIORITY and user threads</TITLE>
</HEAD>
<BODY>
<BR>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">We are testing IDS 9.4 against linux Red Hat 7.2. =
Converting DB from IDS 7.31 on HP-UX.</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">We have PDQPRIORITY set to 1 for most of our 4gl =
applications. When I do an onstat -u, I am seeing multiple user threads =
(sometimes 120) per session. This type of high multi-threading does not =
occur with the same PDQPRIORITY on IDS 7.31. In my testing, I have been =
setting the PDQPRIORITY back to zero. This limits the user threads to =
one per session. And the application performance does not seem =
affected. I am assuming since the 4gls are programmed inline, with no =
forking, that using multiple user threads is not helping.</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">Has anyone else run into this issue?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Mark Roach</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">IT - Programmer/Analyst</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Strategic Outsourcing, Inc.</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C31F07.D165AEC0--

 
 
 

1. Installing Informix 9.4 IDS on AIX Bombed out with this error

Installing IBM Informix Dynamic Server 9.40

441660 blocks
5240 blocks
69980 blocks
366340 blocks
etc/install: etc/brand: 0403-006 Execute permission denied.
     Server installation returned a Non-Zero value
Bundle Install program has finished

2. EM Problem in Client

3. Informix 9.4: poll

4. In Memory Table

5. Informix 9.4 fails on Red Hat: Beware of glibc-2.3.2-4.80

6. How to add / remove a lock from a table?

7. Migrate to Informix 9.4

8. Help...SQL UNION Error !!!

9. Informix 9.4 on Redhat 8.0

10. Informix 9.4 on Linux

11. Informix Universe 9.4

12. Informix Server 9.4 Installation Problem

13. Permission Error installing Informix 9.4 IDS on AIX 4.3.3