Re: create index stalls entire informix server

Check your PDQ settings. If its not in your environment check to see if queries are using the PDQ Manager using onstat -g mgm. If they are using PDQ, chances are someone started the server with PDQ set. Doing this effectively makes every query that is executed run via the PDQ manager. Your index build is also using PDQ for the same reason. It is hogging all the resources which causes the other queries to wait until the job completes.....which in your case happens when you hit CTRL-C. Mark ----- Original Message ----- From: "Steven Kurlander" <skurlander@yahoo.com> To: <informix-list@iiug.org> Sent: Thursday, October 09, 2003 16:41 Subject: create index stalls entire informix server > Hi, > > I'm creating a detached index on a very large table (nearly > 200,000,000 rows). When I run > > create unique index w_freqNum on> w_standard(Identifier,Year,tsFrequency,tsNumber,FieldNumber,NoteLink,RecordS equence) > in w_stnd_index1; > > the entire server stalls for the other user of the system. My > colleague's select query references a table in another database and > the table is in an entirely different dbspace as my table and index. > When I hit ctrl-C and execution stops, his query of the database > completes immediately. > > I am using Informix Server 9.30 running on Solaris 8, Sun E3000 > system. > > Any idea why this happens, and is there any way to allow both to run > simultaneously? > > Thanks, > Steve sending to informix-list