iConsole Search Definition Reference Guide › Standard SQL Helper Functions › Logging

Logging

The logging functions are used for debugging and problem solving. Because logging requires permission to write to the file system on the database server, additional configuration is required as follows:

Oracle

Logging uses DIRECTORY objects to define the location of the log files. These objects must pre-exist, or the privilege CREATE ANY DIRECTORY must be granted to the CA DataMinder user accounts.

SQL Server

Logging uses the xp_cmdshell system function which must be enabled, permitted to the CA DataMinder users and assigned a proxy to be used when writing to the file system. See the relevant SQL Server documentation for full details.

On SQL Server 2005 for example, the following commands must be executed to enable xp_cmdshell:

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
EXEC sp_xp_cmdshell_proxy_account 'username', 'password'
GO

In addition, the CA DataMinder user needs to be granted execute access to the xp_cmdshell SP.