The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

My procedure repeatedly selects data from remote server and these unnecessary information fill server window. For example:

The query is being processed in FULL PASSTHRU mode
The Original Statement is 
    select ... tornado.LgotList ....
The Virtual Statement is 
    select vt_1.expr_1,vt_1.expr_2,vt_1.expr_3,vt_1.expr_4 from vt_1

In my case SELECT PROPERTY( 'RequestLogging' ) reports NONE.

asked 10 Aug '13, 08:29

Serge's gravatar image

Serge
1266714
accept rate: 0%

edited 10 Aug '13, 08:31


Short answer: Try this...

SET OPTION PUBLIC.cis_option = '0';

Long answer: It's not request level logging, it's remote data access logging, also known as CIS debugging where "CIS" stands for Component Integration Services which is the name for a previous incarnation of the middleware software which used to support remote data access, also known as "proxy tables".

This will tell you if it's on:

SELECT CONNECTION_PROPERTY ( 'cis_option' );

CONNECTION_PROPERTY('cis_option')
--------------------------------- 
7

If you have code in your application that does SET TEMPORARY OPTION cis_option = '7' then you will have to hunt that code down and remove it.

If you have set the option for the whole database with SET OPTION PUBLIC.cis_option = '7' then you can turn it off for the whole database with SET OPTION PUBLIC.cis_option = '0'.

Here is what the '7' value does for you...

SET OPTION PUBLIC.cis_option = '7';
SELECT * FROM proxy_t ORDER BY proxy_t.pkey;

The query is being processed in FULL PASSTHRU mode
The Original Statement is 
    select proxy_t.pkey,proxy_t.data from proxy_t order by proxy_t.pkey asc
The Virtual Statement is 
    select vt_1.expr_1,vt_1.expr_2 from vt_1
The Remote Statement for vt_1 is 
    select proxy_t.pkey,proxy_t.data from proxy_t order by proxy_t.pkey asc
Execute (ddd2_server): 
SELECT t1."pkey" , t1."data" FROM "t" t1  ORDER BY t1."pkey" ASC 
permanent link

answered 10 Aug '13, 10:38

Breck%20Carter's gravatar image

Breck Carter
26.6k418576824
accept rate: 21%

edited 10 Aug '13, 10:56

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×46
×30

question asked: 10 Aug '13, 08:29

question was seen: 652 times

last updated: 10 Aug '13, 10:56