Re: Negative PIDS, and SE/Online questions

In article <1993Jan11.220300.16666@informix.com> davek@informix.com (David Kosenko) writes: >>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. > >bcheck is the SE equiv of tbcheck, though it provides less (no equiv Also CHECK TABLE within SQL, for any table that isn't already open otherwise. >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 Minor nit: SET LOCK MODE *is* available with SE, if the port uses kernel-level record locking (although the wait time period parameter is not supported). >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 Also not that the whole logging methodology is different; the database log is maintained as a separate UNIX file which must be manually emptied after completing a database backup. See the doc. >Dave -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland Elvis: shot a TV when bored. Amish Elvis: beat a book with a stick when bored.