Cognos Data Manager Change Logging Options for All available Job Streams and Builds.
Scenario: We want to change the logging options of all the available components in Cognos Data Manager.
Method 1 - You can do it manually for all the component. Right click on component select property in ptoperty window select logging tab. Inside the Trace Check all the available option. But this method will take lots of effort when you have thousands of Job Stream, Builds. Below is the alternative method.
Preferred Alternative - Execute below query to update all the Job Streams and Build using below query.
SET LINE_TEXT = 'DECLARE ''TRACE_VALUES'' ''CHAR(56)'' ''''''<Comma_Separated_Name_For_Required_Property>'''''''
WHERE LINE_TEXT LIKE 'DECLARE ''TRACE_VALUES'' ''CHAR(%'
Note: Allowable options for logging are PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL,USER,VARIABLE
EXAMPLE Logging everything for a Job Stream and Builds
You can modify this query to a build or Job Stream using Component_type in Where Clause.
Below Query is updating logging options only for Job Streams
Your Valuable Comments will be highly appreciated.
Please login to post your valuable comments.
Get the latest vLemonn news first