sql trace question - message log
in the message log, i will see this at certain points but i do not
know what exactly why or what there is to do as a fix?
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -206 The specifiedtable (mon_syssqltrace) is not in the database.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: norecord found.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -310 Table
(informix.mon_syssqltrace_info) already exists in database.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: norecord found.
Any help is appreciated
Thanks
http://www.iiug.org/forums/ids/index.cgi/noframes/read/18690
it is a bug, follw this thread to create the three missing tables.
-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Tom Lehr
Sent: Thursday, May 06, 2010 2:41 PM
To: informix-list@iiug.org
Subject: sql trace question - message log
in the message log, i will see this at certain points but i do not
know what exactly why or what there is to do as a fix?
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -206 The specifiedtable (mon_syssqltrace) is not in the database.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: norecord found.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -310 Table
(informix.mon_syssqltrace_info) already exists in database.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: norecord found.
Any help is appreciated
Thanks
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Every new instance I configure, I got this error too.
Just drop the table mon_syssqltrace_info and wait for next time of the sqltrace task run, they will recreate all this and others tables...
Cesar
--- Em qui, 6/5/10, Tom Lehr <tomcaml@gmail.com> escreveu:
De: Tom Lehr <tomcaml@gmail.com>
Assunto: sql trace question - message log
Para: informix-list@iiug.org
Data: Quinta-feira, 6 de Maio de 2010, 16:41
in the message log, i will see this at certain points but i do not
know what exactly why or what there is to do as a fix?
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -206 The specifiedtable (mon_syssqltrace) is not in the database.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: norecord found.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -310 Table
(informix.mon_syssqltrace_info) already exists in database.
14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: norecord found.
Any help is appreciated
Thanks
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Thanks much!
On May 6, 2:50 pm, Cesar Inacio Martins
<cesar_inacio_mart...@yahoo.com.br> wrote:
> Every new instance I configure, I got this error too.
>
> Just drop the table mon_syssqltrace_info and wait for next time of the sqltrace task run, they will recreate all this and others tables...
>
> Cesar
>
> --- Em qui, 6/5/10, Tom Lehr <tomc...@gmail.com> escreveu:
>
> De: Tom Lehr <tomc...@gmail.com>
> Assunto: sql trace question - message log
> Para: informix-l...@iiug.org
> Data: Quinta-feira, 6 de Maio de 2010, 16:41
>
> in the message log, i will see this at certain points but i do not
> know what exactly why or what there is to do as a fix?
>
> 14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -206 The specified> table (mon_syssqltrace) is not in the database.
> 14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: no> record found.
> 14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -310 Table
> (informix.mon_syssqltrace_info) already exists in database.
> 14:30:00 SCHAPI: [Save SQL Trace 21-3239] Error -111 ISAM error: no> record found.
>
> Any help is appreciated
> Thanks
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list