IBM CISCO R2E2 - Manual (Page 10)

Chapter 2: Devices and Services
6 IBM Tivoli Netcool/Proviso Cisco IP Telephony 2.4.0.0 Technology Pack
The following figure illustrates the technology pack’s data collection architecture in a CCM environment:
Port for SQL Access
CallManager Publisher runs on a Microsoft SQL Server 2000 server. To collect SQL data from the CallManager
Publisher, an SQL bridge must be set up on the machine where Tivoli Netcool/Proviso DataLoad resides. This
bridge is provided as part of the Tivoli Netcool/Proviso Cisco IP Telephony Technology Pack.
The connection between the Data Direct SQL server bridge and the SQL Server 2000 server is made through
TCP port number 1433 or 1370, according to the Cisco CallManager Publisher configuration.
Troubleshooting Note for SQL Requests
If you have problems issuing SQL queries to the Cisco CallManager (CCM) Publisher, check the following list:
• Ensure that tempdb has been set to an adequate size (at least 100Mb) in order to correctly receive the SQL
result set, as recommended in the Cisco CallManager Installation Guide.
• Check the log file ( proviso.log by default) for any SQL error messages. By default, the log file is in the
$DC_HOME/log directory — for example, /opt/datachannel/log .