Negative PIDS, and SE/Online questions
Posted in 1993
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?
Question #1
==============================================================================
Fri Jan 8 00:00:16 1993
19:55:40 Level 0 Archive Started
20:39:28 Level 0 Archive Completed
23:12:45 Shutdown Mode
23:12:56 Process Aborted Abnormally: pid=-1541 user=1002 us=11001fd8 flags=1
23:12:56 Process Aborted Abnormally: pid=-21712 user=-25536 us=1100211c flags=1
23:12:56 Process Aborted Abnormally: pid=-18047 user=-25536 us=11002704 flags=1
23:12:56 Process Aborted Abnormally: pid=-8545 user=-21525 us=110028b4 flags=1
23:12:56 Process Aborted Abnormally: pid=-23189 user=21708 us=11002920 flags=1
23:12:56 Process Aborted Abnormally: pid=-24163 user=-25536 us=11002cec flags=1
23:12:56 Quiescent Mode
23:12:58 INFORMIX-OnLine Stopped
Fri Jan 8 23:19:33 1993
23:19:33 INFORMIX-OnLine Initialized -- Shared Memory Initialized
23:19:33 Physical Recovery Started
23:19:33 Physical Recovery Complete: 0 Pages Restored
23:19:33 Logical Recovery Complete: 0 Committed, 0 Rolled Back
23:21:32 On-Line Mode
==============================================================================
Question #2
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?
--
Naomi Walker (aka N7FSA) naomi%anasaz.UUCP@asuvax.eas.asu.edu
Enthusiasm is caught, In tennis,
not taught. love means nothing.