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
12681016
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
32.5k5407241050
accept rate: 20%

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:

×56
×48

question asked: 10 Aug '13, 08:29

question was seen: 2,608 times

last updated: 10 Aug '13, 10:56