RE: Informix 9.4 locking with DDW

Set PDQ to 0. What do you see or mean by locking? Do you see locks on the server or does the client simply not respond? Do you see a connection to the server? MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Harry Johnson > Sent: Wednesday, 11 February 2004 7:06 a.m. > To: informix-list@iiug.org > Subject: Re: Informix 9.4 locking with DDW > > > Keith, > > I changed the PDQ to 20 and it still locked up. I am on IDS 9.40.UC2. > I will try IDS 9.40.UC3. > > Since this is a connection using SETNET32, I wonder if there is a > problem on this release. > > > "Simmons, Keith" <keith.simmons@office2office.biz> wrote in > message news:<c0a8sr$v8a$1@terabinaries.xmission.com>... > > What are your PDQ settings ? Both environment and onconfig? > > > > > > -> -----Original Message----- > > -> From: hjohnson@keeneinfo.com [mailto:hjohnson@keeneinfo.com] > > -> Sent: Monday, February 09, 2004 7:50 PM > > -> To: informix-list@iiug.org > > -> Subject: Informix 9.4 locking with DDW > > -> > > -> > > -> I am having a problem with Data Director for Web and Informix 9.4. > > -> When I bring up the database containing the Webdatablade and click on > > -> the "text" folder of a project, the Informix will lock up. I am > > -> runing Informix 9.4 on Red Hat 8.0 (2.4.18). The DDW is > > -> 2.00.TC4 and I > > -> am running CSDK 2.70 on the server and CSDK 2.81 on the client. Has > > -> anyone experienced this problem? I can run any type of SQL in > > -> DBACCESS until I do the above at which time the system locks. > > -> > > > > > > > ****************************************************************** > **************** > > This message is sent in strict confidence for the addressee > only. It may > > contain legally privileged information. The contents are not to > be disclosed > > to anyone other than the addressee. Unauthorised recipients are > requested > > to preserve this confidentiality and to advise the sender > immediately of any > > error in transmission. > > This footnote also confirms that this email message has been > swept for the > > presence of computer viruses, however we cannot guarantee that > this message > > is free from such problems. > > > ****************************************************************** > **************** > > > > sending to informix-list > > > > > > sending to informix-list sending to informix-list sending to informix-list

Sorry, I quess I should be a little more specific. What happens is that when I try to connect to the server and pull up web pages stored by Data Director for Web, the server stops responding. I then have to take Informix down and then back up to clear it up. If I just try dbaccess to pull up something from the database, it works. I can even run 3 or more sessions of dbaccess but when I try to connect with DDW, it will stop responding. I look at the server and the majority of the time onstat - will indicate that a "Checkpoint is Required". This is strange because there is practically no activity and I have plenty of logs and the checkpoint interval is 5 minutes. I have also received messages occasionally that there are "too many files open". This is also strange because our limit on open files are 100 times the amount that are really open. DDW works just fine on Informix 9.3. It was only when I upgraded to 9.4 did I start getting this problem. I even installed the lastest 9.4.UC3 and I still get the error. Thanks for your help. "Murray Wood (IList)" <ifxmaillist@quanta.co.nz> wrote in message news:<c0bofd$gkt$1@terabinaries.xmission.com>... > Set PDQ to 0. > What do you see or mean by locking? Do you see locks on the server or does the client simply not respond? > Do you see a connection to the server? > > MW > > > -----Original Message----- > > From: owner-informix-list@iiug.org > > [mailto:owner-informix-list@iiug.org]On Behalf Of Harry Johnson > > Sent: Wednesday, 11 February 2004 7:06 a.m. > > To: informix-list@iiug.org > > Subject: Re: Informix 9.4 locking with DDW > > > > > > Keith, > > > > I changed the PDQ to 20 and it still locked up. I am on IDS 9.40.UC2. > > I will try IDS 9.40.UC3. > > > > Since this is a connection using SETNET32, I wonder if there is a > > problem on this release. > > > > > > "Simmons, Keith" <keith.simmons@office2office.biz> wrote in > > message news:<c0a8sr$v8a$1@terabinaries.xmission.com>... > > > What are your PDQ settings ? Both environment and onconfig? > > > > > > > > > -> -----Original Message----- > > > -> From: hjohnson@keeneinfo.com [mailto:hjohnson@keeneinfo.com] > > > -> Sent: Monday, February 09, 2004 7:50 PM > > > -> To: informix-list@iiug.org > > > -> Subject: Informix 9.4 locking with DDW > > > -> > > > -> > > > -> I am having a problem with Data Director for Web and Informix 9.4. > > > -> When I bring up the database containing the Webdatablade and click on > > > -> the "text" folder of a project, the Informix will lock up. I am > > > -> runing Informix 9.4 on Red Hat 8.0 (2.4.18). The DDW is > > > -> 2.00.TC4 and I > > > -> am running CSDK 2.70 on the server and CSDK 2.81 on the client. Has > > > -> anyone experienced this problem? I can run any type of SQL in > > > -> DBACCESS until I do the above at which time the system locks. > > > -> > > > > > > > > > > > ****************************************************************** > > **************** > > > This message is sent in strict confidence for the addressee > only. It may > > > contain legally privileged information. The contents are not to > be disclosed > > > to anyone other than the addressee. Unauthorised recipients are > requested > > > to preserve this confidentiality and to advise the sender > immediately of any > > > error in transmission. > > > This footnote also confirms that this email message has been > swept for the > > > presence of computer viruses, however we cannot guarantee that > this message > > > is free from such problems. > > > > > ****************************************************************** > > **************** > > > > > > sending to informix-list > > > > > > > > > sending to informix-list > > sending to informix-list > > > sending to informix-list