Link to home
Start Free TrialLog in
Avatar of Piotr Ługowski
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.
Avatar of ste5an
ste5an
Flag of Germany image

Well, it's not exactly truncated. It only stores a certain amount of SQL statements. See SyBooks Online.
You can increase the number by tuning sql text pipe max messages.
Avatar of Piotr Ługowski
Piotr Ługowski

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
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial