Piotr Ługowski
asked on
How to avoid truncating monitoring tables after SELECT (e.g monSysSQLText)
Hi,
Is there any way to disable automatic truncating some of monitoring tables (monSysSQLText, monSysStatement) after SELECT operation? It will make my work a lot easier. I found only a note that ASE assumes that DB user don't want to see it again, which is not true in my case.
I am using Sybase ASE 16.0 & 15.7.
Is there any way to disable automatic truncating some of monitoring tables (monSysSQLText, monSysStatement) after SELECT operation? It will make my work a lot easier. I found only a note that ASE assumes that DB user don't want to see it again, which is not true in my case.
I am using Sybase ASE 16.0 & 15.7.
ASKER
I know I could increase the number of stored SQLs, but it's not my case. My problem is that after every SELECT I get only these rows, which wasn't in the table earlier. I would like to change this behavior - task is to get all rows, not only newly added.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can increase the number by tuning sql text pipe max messages.