Re: Negative PIDS, and SE/Online questions

Naomi Walker writes: > >Hey, all you Informix gurus..... > >I have two questions. The following is an excerpt from the Informix error >log on a Pyramid MIS-S server, runing 4.1 UC1 Online and 4.1 UC1 ESQL/C. >I've seen these negative pid's and funky user numbers before, and sloughed >them off as programming boo-boos. All I really know is that we had a >scheduled reboot of this machine, for another reason. Anyone seen this >negative pid and user id before or have any comments? When tbinit detects that a user's server process has died, it marks the pid in the user structure as negative. I'm not sure why it should do this, other than to flag that it is a problem. Once upon a time, this also showed up as a result of a real problem on AIX: IBM used 64bit userids, whereas we used 2 bytes to track it in shared memory; when the pid got too high, it showed up as a negative number. This was the only platform, that I know of, where this was the case. >My next question is about SE. I am very familiar with all the Informix >tools available to me when using Online. I am not familiar with SE. >In general, are the same or equivalent tools available when using the >standard engine (tbcheck)? How about all the sql statements, like >$ SET EXPLAIN ON/OFF, and $ ALTER TABLE to change things like lock modes >and next extent? bcheck is the SE equiv of tbcheck, though it provides less (no equiv of the -p options); SET EXPLAIN is available with SE; there are no lock modes or extents with SE, so these ALTER TABLE statements do not apply. Off the top of my head, the following OnLine items are not available with SE: Isolation levels BLOBS VARCHARs Buffered/Unbuffered Log toggle Distributed queries (I-Star) Deferred constraints Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney