IDS Forum

Re: sysdbopen problem

Posted By: Eric Rowell
Date: Monday, 19 December 2016, at 9:57 p.m.

In Response To: sysdbopen problem (SERGIO PERES)

So without any info on your configuration I would agree with Art to opening a PMR.

If usIng HDR and DBA with 11.70 check out: IC91981

What programming language is the app written in?
What engine version?
Is this using SQL Linked Server?

"But when a user who is connected to the local database calls a remote UDR or performs a distributed DML operation that references a remote database object by using the database:object or database@server:object notation, no sysdbopenprocedure is invoked in the remote database.)". -Here's to hoping this isn't the case but this can be over come by adding this procedure to the originating database.

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1799.htm

If that's not the case:

The above link states you can TRACE in the sysdbopen. Use it to see if something crazy is being done. I wouldn't put it past an app opening a transaction and rolling back (have seen this once because there was an error), the error might be trapped and the app moves on with its next statement. But even if there is a rollback after the SPL was excluded you should see the trace file, with no data in the table.

SET DEBUG FILE TO
set it to something with sessionid or a datetime year to second. So less likely to overwrite.

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1112.htm

TRACE ON
https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqlt.doc/ids_sqt_513.htm

Hope this helps,
Eric Rowell

> On Dec 18, 2016, at 2:45 PM, SERGIO PERES <sergio.peres@airc.pt> wrote:
>
> Hi,
>
> I doing some tests with one procedure table to register all access to my
> informix instance, even for informix user. I am using the code from planetids
> to use sysdbopen and sysdbclose:
> http://planetids.com/content/how-track-resources-used-database-users
> Every thing works fine until I have done a test with one software that
> connects over oledb, and I have no information about this connection.
> Is it necessary to specify some special parameters? What can I have done
> wrong?
> How can I track all access to my instance?
>
> Thanks for any help,
>
> SP
> sergio.peres@airc.pt
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--Apple-Mail-CC5C522F-993A-4B1E-810C-4B32FDB789A0

Messages In This Thread

• sysdbopen problem
  SERGIO PERES -- Sunday, 18 December 2016, at 2:45 p.m.
  • Re: sysdbopen problem
    Art Kagel -- Sunday, 18 December 2016, at 4:45 p.m.
  • Re: sysdbopen problem
    Eric Rowell -- Monday, 19 December 2016, at 9:57 p.m.
    • Re: sysdbopen problem
      SERGIO PERES -- Tuesday, 20 December 2016, at 4:34 a.m.
      • Re: sysdbopen problem
        Art Kagel -- Tuesday, 20 December 2016, at 6:18 a.m.
      • Re: sysdbopen problem
        Eric Rowell -- Tuesday, 20 December 2016, at 10:18 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.