Message Image

Log in

Skip to main content (Press Enter).

Skip auxiliary navigation (Press Enter).

IBM Data Management Community

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

Skip main navigation (Press Enter).

Informix

View Only

Expand all | Collapse all

Empty `onstat -g his`

Dennis MelnikovTue November 14, 2023 08:47 AM

Hi, That's my onconfig setting: SQLTRACE level=med,ntraces=1000,size=2,mode=user And that ...

Mike WalkerTue November 14, 2023 09:22 AM

Try setting the mode to global , unless you are trying to run the trace for individual users. If you ...

Doug LawryWed November 15, 2023 02:56 AM

Hi Dennis. Looks like SQLTRACE isn't running at all. The configuration parameter needs to be there ...

Dennis MelnikovTue June 11, 2024 09:08 AM

Hi Doug, Please could you be a little bit more detailed on Server Studio? ------------------------------ ...

Doug LawryTue June 11, 2024 09:28 AM

Hi Denis. That's covered from around 2 minutes into this video: https://www.serverstudio.co.uk/video-demos/#video-13 ...

Dennis MelnikovTue June 18, 2024 07:07 AM

Doug: FYI, Server Studio's SQL Trace does not have an option to resume tracing after suspending. ...

Doug LawryTue June 18, 2024 07:23 AM

Hi Denis. I will raise that with AGS. Meanwhile: EXECUTE FUNCTION sysadmin:task("set sql tracing ...

Doug LawryFri June 21, 2024 01:32 PM

AGS have fixed that in version 10.5 Build 21124 which you can get from www.serverstudio.com/downloads ...

Art KagelTue June 11, 2024 09:40 AM

Dennis: Here is a script that will help you manage SQLTRACE. You should still read about it in the ...

Dennis MelnikovWed July 03, 2024 09:38 AM

Hi, Please, how to trace a single session? Seems like `EXECUTE FUNCTION task("set sql tracing session", ...

Doug LawryWed July 03, 2024 10:14 AM

Hi Denis. You can't specify one session ID, but only databases and users. ------------------------------ ...

Dennis MelnikovWed July 03, 2024 10:31 AM

Doug: Hmm, what is "set sql tracing session" for? As the guide reads, Use the on argument ...

Doug LawryWed July 03, 2024 10:58 AM

That means for the Informix instance until it is shutdown. Badly worded, I agree! ------------------------------ ...

Dennis MelnikovWed July 03, 2024 11:16 AM

Doug: I still don't understand what does it mean. How is it supposed to work? ------------------------------ ...

Art KagelWed July 03, 2024 02:31 PM

Not true Doug. You can set SQL TRACE on for: globally a database or databases a user or users ...

Doug LawryWed July 03, 2024 04:14 PM

You're right Art. Never used that, have now found in the IDS documentation. Not an option in the ...

Dennis MelnikovThu July 04, 2024 11:06 AM

Art: Can that be a matter of 11.70? Or may be I am missing something? What is a working sequence ...

Art KagelThu July 04, 2024 11:47 AM

Dennis: Ahh, that's your problem! V11.70 only supported global and user modes. No support yet for ...

1. Empty `onstat -g his`

0 Like