SQLTRACE on HDR Secondary

Is there a trick to get SQLTRACE to work on the HDR Secondary. We use our secondary for some read only applications and would like to be able to analyze the queries with SQLTRACE. This is for HDR, but also wonder if SQLTRACE works for RSS and SDS Read Only Secondaries? IDS 11.10.FC4 RedHat Thanks --K

On Jun 11, 9:42 am, informixdba <informix...@gmail.com> wrote: > Is there a trick to get SQLTRACE to work on the HDR Secondary. > We use our secondary for some read only applications and would like to > be able to analyze the queries with SQLTRACE.   This is for HDR, but > also wonder if SQLTRACE works for RSS and SDS Read Only Secondaries? > > IDS 11.10.FC4 > RedHat > > Thanks >  --K I'm not sure what you mean by trick? I just uncommentted the SQLTRACE line in the onconfig file and bounced my secondary and then was able to see statements show up in the onstat -g his output, so are you saying you tried to turn it on via the onconfig parameter (bounced the server), and were not getting the SQL you were running traced? Jacques Renaut IBM IDS Advanced Support APD team

On Jun 11, 4:34 pm, jrenaut <jpren...@yahoo.com> wrote: > On Jun 11, 9:42 am, informixdba <informix...@gmail.com> wrote: > > > Is there a trick to get SQLTRACE to work on the HDR Secondary. > > We use our secondary for some read only applications and would like to > > be able to analyze the queries with SQLTRACE.   This is for HDR, but > > also wonder if SQLTRACE works for RSS and SDS Read Only Secondaries? > > > IDS 11.10.FC4 > > RedHat > > > Thanks > >  --K > > I'm not sure what you mean by trick?  I just uncommentted the SQLTRACE > line in the onconfig file and bounced my secondary and then was able > to see statements show up in the onstat -g his output, so are you > saying you tried to turn it on via the onconfig parameter (bounced the > server), and were not getting the SQL you were running traced? > > Jacques Renaut > IBM IDS Advanced Support > APD team I tried on the secondary baccess sysadmin <<EOF execute function task ("set sql tracing on", 10000, "2k", "low","user"); EOF 626: Cannot obtain or set serial value. 140: ISAM error: operation illegal on a DR Secondary I guess I just did not look past the error. SQLTRACE is turned on and I can enable it for a user. I can also view in OAT. DUH