RE: create index stalls entire informix server
This is a discussion on RE: create index stalls entire informix server within the Informix forums, part of the Database Server Software category; --> Strange ... What does onstat -u say when the engine is in this state? Do you have PDQ on ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:03 PM
| ||||
| ||||
 RE: create index stalls entire informix server Strange ... What does onstat -u say when the engine is in this state? Do you have PDQ on ... post your onconfig. Anything in the informix messages log? MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto  wner-informix-list@iiug.org]On Behalf Of Steven Kurlander> Sent: Friday, 10 October 2003 9:41 a.m. > To: informix-list@iiug.org > 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,Fi eldNumber,No > teLink,RecordSequence) > 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      |
Linear Mode
