Dennis:
If the task manager scheduler is shut down then SQLTRACE is not writing to sysadmin at all.
SQLTRACE itself only writes to the configured ring buffer in memory. Only the "Save SQL Trace" task in the scheduler writes to the sysadmin mon_sqltrace* tables.
I don't know what else might be consuming space there, but with the scheduler down it really is unlikely. What tables are being populated/growing?
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Tue July 09, 2024 08:07 AM
From: Dennis Melnikov
Subject: sysadmin DB relocation
Art:
We have the scheduler turned off on startup:
SCHAPI: "INFORMIXDIR/etc/sysadmin/stop" file is present.
Bypassing dbScheduler and dbWorker threads startup.
------------------------------
Sincerely,
Dennis
Original Message:
Sent: Tue July 09, 2024 07:35 AM
From: Art Kagel
Subject: sysadmin DB relocation
See this:
Moving (Resetting) the sysadmin database to a new dbspace in IBM Informix Dynamic Server (IDS)
| Ibm | remove preview |
| | Moving (Resetting) the sysadmin database to a new dbspace in IBM Informix Dynamic Server (IDS) | | How do you move the sysadmin database to a new dbspace? | | View this on Ibm > |
|
|
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Tue July 09, 2024 06:45 AM
From: Dennis Melnikov
Subject: sysadmin DB relocation
Hi,
IBM Informix Dynamic Server Version 11.70.FC5XE
Please, how to relocate sysadmin database from rootdbs to avoid rootdbs overflow during SQL tracing?
------------------------------
Sincerely,
Dennis
------------------------------