Errors -242 and -211 help needed, configuratoin file included
Posted in 1992
Topics: Installation, Setup & Upgrades, Storage & Space Management, Transactions, Locking & Isolation, Logging & Checkpoints, Platform-Specific Issues
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 -242Cannot read system catalog (systables)
SYSTEM error -101
File is not open.
Only once I got this:
SQL error -211Cannot 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 buffersTBLSPACES 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!)