Cognos Data Manager Change Logging for All Components

Cognos Data Manager Change Logging for All Components

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.

Solution:

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.

UPDATE CognosDataManagerCatlogDB.DBO.DSB_Component_line

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
BEGIN TRAN
 
/* Assuming Cognos Data Manager Catalog Available in SQL Server */
/* Here CognosDataManagerCatalogDB is Catalog Database */
 
UPDATE CognosDataManagerCatlogDB.DBO.DSB_Component_line
 
SET LINE_TEXT = 'DECLARE ''TRACE_VALUES'' ''CHAR(56)'' ''''''PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL,USER,VARIABLE'''''''
 
WHERE LINE_TEXT LIKE 'DECLARE ''TRACE_VALUES'' ''CHAR(%'
 
--You can uncomment below line if you are satisfied with the output.
 
--COMMIT TRAN

 

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

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* Assuming Cognos Data Manager Catalog Available in SQL Server */
/* Here CognosDataManagerCatalogDB is Catalog Database */
 
BEGIN TRAN
 
UPDATE CognosDataManagerCatlogDB.DBO.DSB_Component_line
 
SET LINE_TEXT = 'DECLARE ''TRACE_VALUES'' ''CHAR(56)'' ''''''PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL,USER,VARIABLE'''''''
 
WHERE LINE_TEXT LIKE 'DECLARE ''TRACE_VALUES'' ''CHAR(%'
 
AND COMPONENT_TYPE = 'J'
 
--You can uncomment below line if you are satisfied with the output.
 
--COMMIT TRAN

 

Applicable Components

Job Stream(J)

Build(B)

Dimension Build(S)

 

Your Valuable Comments will be highly appreciated.

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share