URGENT:LOG PROBLEM IN ONLINE 7.3
Posted in 1999
Hello, I am installing Online Dynamic Server 7.3 (NT). Although I
have programmed in a Informix enviroment I am newbie on installing it. I
have been given only a server, a machine and some pdf manuals.
I think that the instalation process is very easy, and it is
installed well, and a first server instance too. But the problem raises
when I try to create a new database.
With SQL editor, what I do is:
create database dbname with log;
and then I launch the script with tables, constraints, etc. Everything
is ok, but when some statements have been executed (not too much) the
SQL Editor seems to crash, so I kill the task. If I init another
session, and try to drop the database, I can't because the server
returns :
SQL Error (-425) : Database is currently opened by another user. [ ISAM
error -107 : ISAM error: record is locked. ]
and I am sure there isn't another session open.
If I launch all the sentences within a transaction, all are executed
properly, and SQL Editor doesn´t crash.
So I think there's some problem with logging. (If I create the database
without log it also fails)
Maybe the nunmer of log, or logsize. This is the part of the file. The
parameters are default ones.
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 2000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 10 # Number of logical log files
LOGSIZE 500 # Logical log size (Kbytes)LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)
Can anyone tell me what could be wrong? I am lost!
Best regards,
Aurelio