From: alfonso@mtecv2.mty.itesm.mx
Newsgroups: comp.databases.informix
Subject: Errors -242 and -211 help needed, configuratoin file included
Date: 26 Aug 92 22:33:15 GMT
Reply-To: alfonso@mtecv2.mty.itesm.mx
Distribution: alt

Hi, I've already sent a message to this list, but in this I include my
configuration file.

I have installed informix On-Line 4 on 2 RS/6000 under AIX 3.1. In one machine
there's no problem, but the other.....

Suddenly I get this messages while running an application or the isql:

SQL error -242
Cannot read system catalog (systables)
SYSTEM error -101
File is not open.

Only once I got this:

SQL error -211
Cannot read "table name"
SYSTEM error -101
File is not open

These errors appear whenever they want, there's nothing special between a query
done when no error appears and when it does appear.
What can I do? I read somewhere in the list that this may be a bug and somebody
supplied some bug numbers.
Can somebody explain this for me?
Here is my configuration file. I'd gladly change it if this is the solution.

Tanks in advance:

    Alfonso

  alfonso@mtecv2.mty.itesm.mx

Servicios de Informacion
ITESM

#**************************************************************************
#
#			   INFORMIX SOFTWARE, INC.
#
#  Title:	tbconfig.std
#  Sccsid:	@(#)tbconfig.std	7.1.1.1	1/4/90  14:19:43
#  Description: INFORMIX-TURBO Configuration Parameters
#
#**************************************************************************

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /dev/online     # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        1335296         # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         rootdbs         # Location (dbspace) of physical log
PHYSFILE        1000            # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        20              # Number of logical log files
LOGSIZE         500             # Logical log size (Kbytes)

# Message Files

MSGPATH         /usr/informix/online.log # System message log file path
CONSOLE         /usr/informix/msgol.log # System console message path

# System Archive Tape Device

TAPEDEV         /dev/rmt0       # Tape device path	
TAPEBLK         16              # Tape block size (Kbytes)
TAPESIZE        2048000         # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV        /dev/rmt0       # Log tape device path
LTAPEBLK        16              # Log tape block size (Bytes)
LTAPESIZE       2048000         # Max amount of data to put on log tape (Kbytes)

# System Configuration

SERVERNUM       0               # Unique id corresponding to a TURBO instance
SERVERNAME      info2           #
DEADLOCK_TIMEOUT 60              # max time to wait of lock in distributed env.
RESIDENT        0               # Forced residency flag (Yes = 1, No = 0)

# Shared Memory Parameters

USERS           50              # Maximum number of concurrent users (processes)
LOCKS           5000            # Maximum number of locks
BUFFERS         2000            # Maximum number of shared buffers
TBLSPACES       500             # Maximum number of open tblspaces
CHUNKS          8               # Maximum number of chunks
DBSPACES        8               # Maximum number of dbspaces
PHYSBUFF        64              # Physical log buffer size (Kbytes)
LOGBUFF         64              # Logical log buffer size (Kbytes)
LOGSMAX         20              # Maximum number of logical log files
CLEANERS        0               # Number of buffer cleaner processes
SHMBASE         0x30000000        # Shared memory base address
CKPTINTVL       300             # Check point interval (in sec)

# System Page Size

BUFFSIZE        4096            # Page size (do not change!)