Hi,
maybe "onstat -g ses <session id>" can give you a bit more information.
Most likely, this is an application or user error, basically what the error description says:
-349 Database not selected yet.
This statement cannot be executed because no current database exists.
Either no current database has been established yet, or the current
database was closed with a CLOSE DATABASE statement. You execute the
DATABASE or CREATE DATABASE statement to establish a current database.
It is possible to connect to a server without specifying a database. For such a connection,
you will see an entry in the syssessions table or in the output of "onstat -g ses".
"onstat -g ses <session id>" consequently shows that no database is established.
To further figure out, what such a session did to get itself into this situation, is a bit difficult
on the server side. The only thing that comes to my mind is to activate SQLTRACE to be
able to see, what the session did before it received the error ... But activating SQLTRACE for
everybody in a production environment may not be desirable. It may be possible
to create a sysdbopen procedure for a specific database user who receives the error,
and then activate the SQL tracing in that sysdbopen procedure just for that user.
Check the documentation for details about the sysdbopen procedure and how to use
the "set environment" statement to enable SQL tracing for a a session.
Regards,
Martin
--
Martin Fuerderer
Software Engineer, Software Development
HCL Technologies Ltd.
Frankfurter Ring 17
80807 Munich, Germany
www.hcltech.com
::DISCLAIMER::
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.