Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!cmcl2!phri!marob!daveh From: daveh@marob.masa.com (Dave Hammond) Newsgroups: comp.databases Subject: INFORMIX ISQL 2.0 problem Message-ID: <714@marob.masa.com> Date: 31 May 89 15:43:24 GMT Reply-To: daveh@marob.masa.com (Dave Hammond) Organization: ESCC, New York City Lines: 79 System: AT/286-compatible OS: SCO Xenix 2.2.1 Database: Informix ISQL 2.0. When attempting to create or drop a table, we are getting a `no system permission' type of error. The operation has been attempted as `informix', as `root' and as the table owner (dave): > drop table stkord__dtl; 211: Cannot read system catalog (systables). 111: C-ISAM error: no record found. > Error in line 1 Near character position 23 --- The only system change which has occured is that the owner (dave) username has been changed to `daveh'. However, his UID is unchanged. The following `ls' outputs detail the permissions and ownership of related programs and data files: /u0/informix/bin: total 2902 -rwsr-xr-t 1 informix informix 132574 Apr 26 1988 isql /u0/informix/lib: total 538 -rwsr-sr-t 1 informix informix 61561 Apr 26 1988 pisam -rwsr-sr-t 1 informix informix 208558 Apr 26 1988 sqlexec /u0/cmx2/data: drwxrwxrwx 5 root gods 3360 May 22 18:27 . drwxrwxrwx 2 informix informix 784 May 19 15:19 carna.dbs -rw-rw-rw- 1 informix informix 1024 Mar 27 19:53 carna.dbs/systabauth.dat -rw-rw-rw- 1 informix informix 3584 Mar 27 19:53 carna.dbs/systabauth.idx -rw-rw-rw- 1 informix informix 4608 Mar 27 19:53 carna.dbs/systables.dat -rw-rw-rw- 1 informix informix 3584 Mar 27 19:53 carna.dbs/systables.idx --- The following transcript shows that the `systables' table is readable: > select * from systables where tabname = "stkord__dtl"; tabname stkord__dtl owner dave dirpath stkord_149 tabid 149 rowsize 108 ncols 8 nindexes 2 nrows 19741 created 11/04/1988 version 5 tabtype T audpath 1 row(s) retrieved. --- Any clues to our problem would be greatly appreciated. BTW, assuming that a true resolve to this problem never appears, can we achieve the same effect as a "drop table" SQL command, by deleting the associated `sys*' table records, .dat and .idx files? Also, on an unrelated note-- We have several machines which are running ISQL 2.0 which lacks the `dbschema' utility. Can the version supplied with ISQL 2.1 function with ISQL 2.0 tables? I will monitor this group for replys, however e-mail responses are prefferable. Thanks in advance. -- Dave Hammond DSI Communications, Inc. daveh@dsix2.uucp -or- daveh@marob.masa.com