Hi

I have to dump the transaction log of my master database every morning as it is filling up. I have noticed this is happening after the servce checks for RSA keys and licences
This is happening since last week only

I have installed and I am evaluating sybase monitoring tools like 'asetune' and 'asemon' which i downloaded from sourceforge and 'spotlight' evaluation version downloade from quest software. I'm not aware if any of these tools are setting/reseeting some config params which is causing the log to fill up

We have installed ASE15.7 on our production server
Adaptive Server Enterprise/15.7.0/EBF 22601 SMP SP62 /P/PPC64/Linux/ase157sp6x/3350/64-bit/FBO/Fri Apr 18 00:26:17 2014.


Copied below partial output of SYBASE.log file

[B]00:0012:00000:00000:2014/07/29 04:43:11.22 kernel extended error information: hostname: KCT login: claudius
00:0006:00000:00030:2014/07/29 05:22:22.17 server Adaptive Server Enterprise User Connection Report.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum number of User Accounts during current sample period: 928.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum number of User Accounts since startup: 929.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum Configured Number of User Connections during current sample period: 500
.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum Configured Number of User Connections since startup: 500.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum Number of User Connections during current sample period: 28.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum Number of User Connections since startup: 449.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum number of user seat licenses used during current sample period: 16.
00:0006:00000:00030:2014/07/29 05:22:22.17 server Maximum number of user seat licenses used since startup: 112.
00:0012:00000:00000:2014/07/29 06:06:14.88 kernel nrpacket: recv, Connection timed out, spid: 457, suid: 604
00:0012:00000:00000:2014/07/29 06:06:14.88 kernel extended error information: hostname: login: kctgeorg
00:0008:00000:00051:2014/07/29 07:05:04.31 server Space available in the log segment has fallen critically low in database 'maste
r'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:0008:00000:00593:2014/07/29 07:05:04.33 server background task message: ***!! Last Chance Threshold reached, for master(logseg
ment)
00:0008:00000:00593:2014/07/29 07:05:04.34 server ***!! Last Chance Threshold reached, for master(logsegment)
00:0008:00000:00593:2014/07/29 07:05:04.35 server Error: 4205, Severity: 16, State: 1
00:0008:00000:00593:2014/07/29 07:05:04.35 server Syslogs does not exist in its own segment in database 'master' with segmap '7'
with logical start page number of '0'. You cannot use DUMP TRANSACTION in this case, use DUMP DATABASE instead.
00:0006:00000:00008:2014/07/29 07:05:08.98 server 1 task(s) are sleeping waiting for space to become available in the log segment
for database master.
00:0006:00000:00008:2014/07/29 07:06:08.97 server 1 task(s) are sleeping waiting for space to become available in the log segment
for database master.
00:0006:00000:00008:2014/07/29 07:07:08.97 server 2 task(s) are sleeping waiting for space to become available in the log segment
for database master.


Please let me know how I can find the process that is filling up the transaction log


brgds
Lakshmi Reddy