Monitor queries against tables
Currently running Informix IDS 11.70.FCx and have been approached by management that they would like all queries against specific tables monitored. How best to approach this? Thanks Peter
Can you elaborate on your needs? Do you just need to know that someone queried the table? Or do you need the query SQL? Or do you also need to know the result set? Would a "best effort" be enough or would you need to capture every query without being possible not fail any? Regards On Mon, Jun 2, 2014 at 3:24 PM, PETER DIAZ DE LEON < peter.diazdeleon@gmail.com> wrote: > Currently running Informix IDS 11.70.FCx and have been approached by > management that they would like all queries against specific tables > monitored. > How best to approach this? > > Thanks > Peter > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --089e013a25d6a6d69404fadb3a8c
Just an idea: Use a select trigger and generate a protocol table, which will hold the accesses. Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Fernando Nunes" <domusonline@gmail.com> An: ids@iiug.org Gesendet: Montag, 2. Juni 2014 16:30:01 Betreff: Re: Monitor queries against tables [33134] Can you elaborate on your needs? Do you just need to know that someone queried the table? Or do you need the query SQL? Or do you also need to know the result set? Would a "best effort" be enough or would you need to capture every query without being possible not fail any? Regards On Mon, Jun 2, 2014 at 3:24 PM, PETER DIAZ DE LEON < peter.diazdeleon@gmail.com> wrote: > Currently running Informix IDS 11.70.FCx and have been approached by > management that they would like all queries against specific tables > monitored. > How best to approach this? > > Thanks > Peter > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --089e013a25d6a6d69404fadb3a8c ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.