IBM R2E2 manual YourDataSource1 Driver=PVmsss20.so

Page 53

Chapter 4: Configuring the technology pack

5.CCM environment only: Configure the Data Direct SQL Server Bridge

The Tivoli Netcool/Proviso Cisco IP Telephony Technology Pack collects data from SNMP devices and, through SQL for Call Detail Records, from each CCM database.

The technology pack UBA is responsible for retrieving CCM data, using the Data Direct SQL server bridge to do so. This bridge is part of the UBA installation. No additional software is required.

You need to set up the Data Direct SQL server bridge to get Call Detail Records from each CallManager Publisher. The complete configuration is done by editing the $DC_HOME/conf/odbc.ini file as user pvuser.

[ODBC Data Sources]

Your_Data_Source1=DataDirect 4.20 SQL Server Wire Protocol Your_Data_Source2=DataDirect 4.20 SQL Server Wire Protocol Your_Data_SourceN=DataDirect 4.20 SQL Server Wire Protocol

[Your_Data_Source1] Driver=PVmsss20.so

Description=DataDirect 4.20 SQL Server Wire Protocol Address=xx.xx.xx.xx,1433

AnsiNPW=Yes

Database=CDR

QuoteId=No

[Your_Data_Source2] Driver=PVmsss20.so

Description=DataDirect 4.20 SQL Server Wire Protocol Address=xx.xx.xx.xx,1370

AnsiNPW=Yes

Database=CDR

QuoteId=No

[Your_Data_SourceN] Driver=PVmsss20.so

Description=DataDirect 4.20 SQL Server Wire Protocol Address=xx.xx.xx.xx,1433

AnsiNPW=Yes

Database=CDR

QuoteId=No

[ODBC]

IANAAppCodePage=4

InstallDir=/opt/datachannel/

Trace=0

TraceDll=/opt/datachannel/lib/odbctrac.so

TraceFile=odbctrace.out

UseCursorLib=0

All fields above which appear in italics must be configured according to your CallManager Publisher environment, as follows:

Field

Description

 

 

 

 

[ODBC Data

One entry per CallManager Publisher.

Sources]

 

 

Note:

 

The data source name must match the data source name specified in the corresponding

 

URI (Uniform Resource Identifier) parameter in the dc.cfg file. Each line in this

 

section should also be associated with a subsection that configures the data source.

 

 

IBM Tivoli Netcool/Proviso Cisco IP Telephony 2.4.0.0 Technology Pack

49

Image 53
Contents IBM Copyright IBM Corp Contents Contents Organization AudienceTivoli Netcool/Proviso documentation Tivoli Netcool/Proviso product suiteSummary of Device Technology OverviewCategories of Service Reporting Source of Collected Data Collection Type Sources of Collected DataPort for SQL Access Troubleshooting Note for SQL RequestsDevices and Services Prerequisites Snmp AccessBulk input file formats Supported MIBsBulk input file name Bulk input file schemaBulk adaptor design files Devices and Services Reporter sets Supported Reports and KPIsReporter set summary Reporter set tree Reporter set contents Cluster Call Distribution Group Cluster Quality ResourceCluster Call Distribution Resource Cluster Utilization Group Top 10 Cluster Call CompletionCluster Quality Group Top 10 Cluster Number of Calls Top 10 Cluster Number of ErrorsCluster VoiceMail Usage Resource Cluster IP vs Legacy ResourceCluster Erlang-B Group Cluster Utilization MLH ResourceExtension CDR Utilization Resource CDR Quality ResourceTop 10 CDR Number of Calls Top 10 CDR Number of ErrorsCDR Call Distribution Resource Top 10 CDR Call Completion CDR VoiceMail Usage ResourceTop 10 CDR Call Duration CDR Quality GroupFactor Group CDR Call Distribution GroupFactor Factor Resource Top 10 CDR K-Factor Codec Errors on Cluster by CodecCCM Sql Server Group CallManager Server CCM Server Quality ResourceCCM Sql Server Resource Pstn Gateway E1/T1Availability Resource Pstn Gateway Interface Top 10 E1/T1 Utilization ResourcePstn Gateway E1/T1 Interface Utilization Resource Device Pstn Gateway Device Quality ResourceDSP Card Pstn Gateway DSP Card Resource Pstn Gateway Availability ResourceMedia Devices Media Device Resource Media Device GroupGatekeeper Device Quality Resource Gatekeeper Availability Resource Gatekeeper Availability Resource Detail ChartGatekeeper Interface Availability Resource Gatekeeper Interface Utilization Resource Detail ChartGatekeeper Interface Utilization Resource Perfmon Perfmon Active Calls ResourcePerfmon Security Resource Perfmon Active Calls GroupPerfmon Security Group Perfmon Pstn Group Perfmon Pstn ResourcePerfmon MOH Resource Perfmon MOH GroupKey performance indicators Key performance indicatorsCCR Supported Reports and KPIs Key performance indicators ClusterLocalCall Key performance indicators ICR Unknown or unsupported protocol Mlqk MOS SCS Key performance indicators Before you begin Configuring the technology packCd /opt/datamart Configure the technology packOpt/datamart/dataMart.env Pvm YourDataSource1 Driver=PVmsss20.so Generates output from a CDR file and its associated CMR file If true, ProvisoCUCM requests CDR and CMR data from the Cucm Request DataChannel host that requested them Report navigation by customer Name you pass to the object Tivoli Netcool/Proviso v4.4.3 and later Where Datachannelhome Specifies the channel number for example, 1 that you Success message Meaning Syntax item Verifying resources Device.instance.schema.parametername Description InstancesComponent ValueVoipciscoipt Instances VOIPCISCOIPT.CCMINPUT.DELETEONACQUIRE VOIPCISCOIPT.CCMINPUT.URI VOIPCISCOIPT.CDRINPUT.DELETEONACQUIRE VOIPCISCOIPT.CDRINPUT.URI VOIPCISCOIPT.DESIGNFILE VOIPCISCOIPT.DESIGNFILE VOIPCISCOIPT.INPUTDIRECTORY VOIPCISCOIPT.INPUTDIRECTORY VOIPCISCOIPT.INPUTFTPPASSWORD VOIPCISCOIPT.INPUTFTPUSERNAME VOIPCISCOIPT.INPUTHOST VOIPCISCOIPT.INPUTHOST VOIPCISCOIPT.INPUTUSESECUREFTP VOIPCISCOIPT.INPUTUSESECUREFTP VOIPCISCOIPTPERFMON.DESIGNFILE VOIPCISCOIPTPERFMON.INPUTDIRECTORY VOIPCISCOIPTPERFMON.INPUTFTPPASSWORD VOIPCISCOIPTPERFMON.INPUTFTPUSERNAME VOIPCISCOIPTPERFMON.INPUTHOST VOIPCISCOIPTPERFMON.INPUTUSESECUREFTP VOIPCISCOIPTPERFMON.PERFMON.DELETEONACQUIRE VOIPCISCOIPTPERFMON.PERFMON.URI Pack-specific UBA parameters Template file name and locationUBA Parameter Value Meaning Additional information about UBA parametersDbusername URIExample UBA.1.101.VOIPCISCOIPT.CCMINPUT.DELETEONACQUIRE=false Page Page Trademarks Copyright IBM Corp Page Tcl 8.3.3, Combat/TCL 0.7.3, Combat/TCL 0.7.5, TclX 8.3, TK Additional Copyright InformationAdditional Copyright information Scotty 2.8, incrTCL 3.0, incr TCL BLT 2.4uUCD Snmp Regex 1.1a JdomXwpick Page IBM