IBM CISCO R2E2 ユーザーズマニュアル

ページ / 110
Chapter 2:  Devices and Services
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
.