cancel
Showing results for 
Search instead for 
Did you mean: 

sql tracing in IQ

Former Member
0 Kudos

Hi All,

When we create a archiving object in BW side so then there would be two tables created on the IQ side.

Is there some kind of tracing which i can setup on the IQ side to see the sql which is being used to create the tables on the IQ side.

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

tayeb_hadjou
Advisor
Advisor
0 Kudos

Hi,

To enable tracing.


CALL sa_server_option( 'RequestLogging', 'ALL');


Please see KBA for details

http://service.sap.com/sap/support/notes/2270379


Regards,


Former Member
0 Kudos

Hi,

Where does the sql get stored once its created?

saroj_bagai
Contributor
0 Kudos

default is .srvlog unless log file have been specified with startup switch -zo or at runtime with

sa_server_option ('Request_level_log_file',  '<filename>')

Answers (0)