Chapter 2: Devices and Services
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.
6 | IBM Tivoli Netcool/Proviso Cisco IP Telephony 2.4.0.0 Technology Pack |
