Error sql -998 (???)
Posted in 2009
Topics: Server Administration, Platform-Specific Issues
Hello, everybody!!!
I´ve recently monitored one instance of
IDS 11.50.FC4, running on linux 64 bits,
and sometimes appears a session like this:
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR
Vers Explain
76986 - - - Wait *-998* 0
9.35 Off
But when I try to debug it, getting the "onstat -g ses" command, the
session has already dissapeared on the list.
Any ideas, what´s going on? This error doesn´t have any description???
Thanks for your attention, always!
--
Alexandre Marini
Analista de Tecnologia da Informação - DBA
SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
Try put a trap
1) active the trap:
$ onmode -I 998
(Capital i )
2) check the trap:
$ onstat -m3) monitor the log and wait the error occur
4) Deactive the trap:
$ onmode -I
When the error occur the IDS will generate a Assert Failed and maybe you can
get some information.
Tip: disable memory dump before do this.
César
--- Em ter, 30/6/09, Alexandre Marini <amarini@fazenda.ms.gov.br> escreveu:
De: Alexandre Marini <amarini@fazenda.ms.gov.br>
Assunto: Error sql -998 (???) [16193]
Para: ids@iiug.org
Data: Terça-feira, 30 de Junho de 2009, 14:06
Hello, everybody!!!
I´ve recently monitored one instance of
IDS 11.50.FC4, running on linux 64 bits,
and sometimes appears a session like this:
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR
Vers Explain
76986 - - - Wait *-998* 0
9.35 Off
But when I try to debug it, getting the "onstat -g ses" command, the
session has already dissapeared on the list.
Any ideas, what´s going on? This error doesn´t have any description???
Thanks for your attention, always!
--
Alexandre Marini
Analista de Tecnologia da Informação - DBA
SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
____
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
Hi ,
Can you able to find what is the sql last parsed in that session during onstat
-g ses?
rgds
schillache
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g