IBM NETCOOL 4.3-W - Manual (Page 136)

Chapter 3: Devices and Services
114 Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W
The following figure illustrates the technology pack’s data collection architecture in a CCM environment:
Port for SQL Access
CallManager Publisher runs on an MS-SQL2000 server. To collect SQL data from the CallManager Publisher, an
SQL bridge must be set up on the machine where Netcool/Proviso DataLoad resides. This bridge is provided as
part of the Netcool/Proviso Cisco IP Telephony Technology Pack.
The connection between the Data Direct SQL server bridge and the MS-SQL2000 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:
• 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
$DC_HOME/log
— for example,
/opt/datachannel/log
.