cann't open logfile
Franck Yu restored an Informix SE 4.x database onto SE 7.20 and got errors 224 and 120 (cannot open transaction log file); finderr suggested START DATABASE. Jonathan Stowe pointed to the dbaccess help and the SQL syntax guide. Art S. Kagel said the SE4 and SE7 file structures are incompatible, so the data must be unloaded and reloaded into a new SE7 database. Franck thanked them; no outcome was reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello,
I installed Informix SE V720 and restaured a database created under
Informix SE V4.x from another machine. When I try to connect to the
database, I receive the following messages:
224: Cann't open transaction log file
120: ISAM error: cann't open log file
finderr suggests that I should use START DATABASE to create a log file.
My questions are
- what is the syntax of START DATABASE?
- where could I find documentation about this statement? It seems that
it is not a SQL statement.
- how do I execute the statement? with dbaccess? It seems to me that
dbaccess is the only command interpreter of Informix. Am I right? Are
there other ones?
Thanks in advance for answers
And many thanks to Jonathan Leffler for his excellent answer to my
previous questions about Informix SE install
Franck
Franck Yu <fyu@fr.ibm.com> wrote:
> Hello,
>
> I installed Informix SE V720 and restaured a database created under
> Informix SE V4.x from another machine. When I try to connect to the
> database, I receive the following messages:
>
> 224: Cann't open transaction log file
> 120: ISAM error: cann't open log file>
> finderr suggests that I should use START DATABASE to create a log file.
> My questions are
> - what is the syntax of START DATABASE?
> - where could I find documentation about this statement? It seems that
> it is not a SQL statement.
> - how do I execute the statement? with dbaccess? It seems to me that
> dbaccess is the only command interpreter of Informix. Am I right? Are
> there other ones?
This will be described under the "Help" ring menu in dbaccess - its unders
others in the "Query Language" help.
It is also described in the Informix Guide to SQL - Syntax at :
<http://www.informix.com/answers/oldsite/answers/pubs/pdf/7882a.pdf>;
/J\\
--
"The Spice Girls don't care if I like them or not because I'm not twelve"
- Germaine Greer
As far as I know the file structure has changed between SE4 and SE7 and
the files you copied over are incompatible. You will have to go back to
the SE4 instance and unload the tables and then recreate the database in
SE7 empty and reload it from flat files.
Art S. Kagel
Franck Yu wrote:
>
> Hello,
>
> I installed Informix SE V720 and restaured a database created under
> Informix SE V4.x from another machine. When I try to connect to the
> database, I receive the following messages:
>
> 224: Cann't open transaction log file
> 120: ISAM error: cann't open log file>
> finderr suggests that I should use START DATABASE to create a log file.
> My questions are
> - what is the syntax of START DATABASE?
> - where could I find documentation about this statement? It seems that
> it is not a SQL statement.
> - how do I execute the statement? with dbaccess? It seems to me that
> dbaccess is the only command interpreter of Informix. Am I right? Are
> there other ones?
>
> Thanks in advance for answers
> And many thanks to Jonathan Leffler for his excellent answer to my
> previous questions about Informix SE install
>
> Franck
Jonathan,
Thank you for your quick reponse and infos!
Franck
_______________________________________________________________________________________________
Jonathan Stowe wrote:
> This will be described under the "Help" ring menu in dbaccess - its unders
> others in the "Query Language" help.
>
> It is also described in the Informix Guide to SQL - Syntax at :
>
> <http://www.informix.com/answers/oldsite/answers/pubs/pdf/7882a.pdf>;
>
> /J\\
> --
> "The Spice Girls don't care if I like them or not because I'm not twelve"
> - Germaine Greer