sg_sec

8/17/2019 SG_sec

1/158

not for distribution

Tivoli Service Quality Manager /Customer Experience Manager

Installation & Configuration SPVC

8/17/2019 SG_sec

2/158

not for distribution1-2

Workshop Objectives

Perform a complete installation of – Tivoli Netcool Service Quality Manager (TNSQM) – Tivoli Netcool Customer Experience Manager (TNCEM)

Install and configure two Service Solutions – TNSQM Module for IP VPN Services – TNCEM Module for UMTS Voice Services

Configure utilities to generate synthetic data for eachService Solution

Learn how to demonstrate key features and functions ofTNSQM and TNCEM

Configure the integration with Tivoli Business Service

Manager (TBSM)

8/17/2019 SG_sec

3/158


Workshop Logistics

Self Paced Virtual Classroom (SVPC) format

Recorded Presentations

Hands-on Exercises – Detailed lab workbooks for each exercise – Performed using a dedicated remote server

Total Time is Approximately 36-48 Hours – Each lab exercise is labeled with the approximate time

– The exercises do not have to be completed in a single sitting

8/17/2019 SG_sec

4/158


Workshop 1 – System Prerequisites

Goal – verify all system prerequisites – Operating System – Memory (real and virtual)

– Disk – Filesystem – Host Name – Domain Name

– Prepare system for installation• Create directories• Move installation software

Approximate time – 45 minutes

8/17/2019 SG_sec

5/158


Workshop 2 – Platform Software Installation

Goal – install platform software components

– Oracle

– SunOne Directory Server

– Java Message Queue

– WebSphere

Approximate time – 1:15 minutes

8/17/2019 SG_sec

6/158not for distribution1-6

Workshop 3 – TNSQM / TNCEM Installation

Goal – install TNSQM and TNCEM

– Install TNSQM

– Install TNCEM

– Validate system

– Configure system to forward SNMP traps

Approximate time – 3 hours

8/17/2019 SG_sec


Workshop 4 – IP VPN Installation

Goal – install TNSQM Module for IP VPN Services

– Install GOM (Global Object Module)

– Install IP VPN

– Configure IP VPN demo data generation

– Validate installation


8/17/2019 SG_sec


Workshop 5 – UMTS Voice Installation

Goal – install TNCEM Module for UMTS Voice Services

– Install UMTS Voice

– Configure UMTS Voice demo data generation

– Validate installation


8/17/2019 SG_sec


Workshop 6 – Client Installation

Goal – Configure and validate client access

– Configure Socks Proxy – Download & install TNSQM thick client

– Configure student workstation thick client for proxy use – Configure student workstation browser for proxy use – Create new TNSQM user – Validate client access to TNSQM and CEM


8/17/2019 SG_sec


Workshop 7 – TNSQM Demo

Goal – demonstrate key features and functions ofTNSQM

– Create SLA (Service Level Agreement) Template – Create custom SLA – Monitor state changes of SLA

• Using TNSQM thick client• Using SLA WebView

– Create custom KQI (Key Quality Indicator) – Monitor the KQI using KQI Analyzer

Approximate time – 1 hour

8/17/2019 SG_sec

11/158


Workshop 8 – TNCEM Demo

Goal – demonstrate key features and functions ofTNCEM

– Demonstrate TNCEM user interface• Investigate customer issues• Investigate group issues• Investigate device issues

– Create custom SLO (Service Level Objective)

– Monitor state changes of SLO


8/17/2019 SG_sec

12/158


Workshop 9 – TBSM / TNSQM Integration

Goal – install and configure the TBSM / TNSQMIntegration

– Add custom rules to NcKL (Netcool Knowledge Library)

– Add custom fields to Object Server

– Configure TBSM• Create service templates

• Define auto-population rules• Configure Data Fetcher • Customize Service Tree• Add custom charts• Configure Single Sign On (SSO)• Configure Launch In Context (LC)


8/17/2019 SG_sec

13/158


Workshop 10 – Custom Reporting Using BIRT

Goal – install and configure BIRT and produce a customreport

– Install BIRT Designer on student workstation

– Configure BIRT Designer for access to TNSQM server

– Create custom report

Approximate time – 45-60 minutes

8/17/2019 SG_sec

14/158


Remote Server

Each student is assigned a dedicated server

“Real” server, not a virtual image

The server is reserved for student use (typically twoweeks)

The lab exercises may be completed any time during theperiod that the server is assigned to the student

8/17/2019 SG_sec

15/158


Workshop 1

To begin the workshop

– Download and view System Pre-requisites

8/17/2019 SG_sec

16/158not for distribution

Workshop 1TNSQM/TNCEM Installation

System Prerequisites

8/17/2019 SG_sec

17/158


Objectives – verify all system prerequisites

– Operating System – Memory (real and virtual) – Disk

– Filesystem – Host Name – Domain Name – Prepare system for installation

• Create directories

• Move installation software


8/17/2019 SG_sec

18/158


Installation Prerequisites

8/17/2019 SG_sec

19/158


General Requirements

Majority of the install performed as root

Install will create 2 additional UNIX users – oracle – saserver

Shared Memory changes may require reboot

Complete installation takes 6-8 hours, including

copying/expanding software

8/17/2019 SG_sec

20/158


Minimum Hardware Requirements - Solaris

Sun SPARC Architecture

Four UltraSPARC IV, IV+ or UltraSPARC T1processors

8GB core memory – NOTE: Release Notes for Service Solutions call for 32 GB

Four 72GB hard disks

IBM Tivoli Netcool Service Quality Manager Server Installation Guide

8/17/2019 SG_sec

21/158


Operating System Requirements - Solaris

Solaris 10 – 6/06 or later – kernel patch 118833-36 or later

– Including patch 122032-05 or later

Total of 16 GB Virtual Memory - MINIMUM – RAM + SWAP = 16 GB

8/17/2019 SG_sec

22/158


Operating System Requirements - Solaris

Shared Memory settings for Oracle – Create a new project (101) for the dba group called Oracle

• projadd –p 101 –c “Oracle” –U oracle –G dba ‘user.oracle’

– Update this project with the necessary settings• projmod –s –K “project.max-shm-memory=(privileged, 32GB, deny)”

‘user.oracle’• projmod –s –K “project.max-shm-ids=(privileged, 1024, deny)”

‘user.oracle’

• projmod –s –K “project.max-sem-ids=(privileged, 4096, deny)”‘user.oracle’• projmod –s –K “project.max-sem-nsems=(privileged, 16010, deny)”

‘user.oracle’

– Verify that the changes were applied correctly• /usr/bin/projects –l

– Does NOT require a reboot

8/17/2019 SG_sec

23/158


3rd Party Software – Platform Dependencies

AIX Solaris

Database Oracle 10g,Enterprise w/

Partitioning

Oracle 10g,Enterprise w/

Partitioning

JMS WebSphere IMQ

LDAP Tivoli Directory

Server 6.1

SunOne DS

Server JRE J2RE 1.5.0 IBM J92.3

Java HotSpot(TM)

Server VM

8/17/2019 SG_sec

24/158


Filesystem Requirements (production grade)Filesystem Software Size (Mbytes) Disk Location

/ Operating system 8192 c1t0d0s0 [ 1 ]

Swap Operating system 8192 c1t0d0s1 [ 1 ]

/var Operating system 4096 c1t0d0s3 [ 1 ]

/appl Oracle & TNSQM 30720 c1t0d0s4 [ 1 ]

/export/home Users Home 2048 c1t0d0s5 [ 1 ]/oradata01 Oracle storage 1 34816 c1t1d0s0 [ 2 ]

/oradata02 Oracle storage 2 34816 c1t1d0s1 [ 2 ]



/oralogs1 Oracle Redo log loc 1 10920 c1t3d0s0 [ 4 ]

/oralogs2 Oracle Redo log loc 2 10920 c1t3d0s1 [ 4 ]

/oratemp Oracle temp space 10920 c1t1d0s3 [ 2 ]

/oradump Oracle dump space 4096 c1t3d0s7 [ 4 ]

/data/cache TNSQM cache 8192 c1t3d0s3 [ 4 ]

/data/download1 Downloaded data 1 8192 c1t3d0s3 [ 4 ]

/data/download2 Downloaded data 2 8192 c1t3d0s4 [ 4 ]

/data/trace_log1 Trace log 8192 c1t3d0s5 [ 4 ]

/data/trace_archive1 Trace Archive 8192 c1t3d0s6 [ 4 ]

8/17/2019 SG_sec

25/158


Software Preparation

8/17/2019 SG_sec

26/158


TNSQM Software Packages

TNSQM Packages on XL Download site – CZS0GEN – IBM Tivoli Netcool Service Quality Manager V4.1.3

for Solaris (1300 MB)

– CZS0EEN – IBM Tivoli Netcool Service Quality Manager V4.1.3for WAS Solaris (628 MB)

– CZS0DEN – IBM Tivoli Netcool Service Quality Manager V4.1.3Documentation Multiplatform (34 MB)

– NOTE: TNCEM is included in the TNSQM eAssembly(CZS0GEN)

– Total disk (compressed) = 2.0 GB

8/17/2019 SG_sec

27/158


TNSQM Service Solutions

C1W3YEN - Tivoli Netcool Service Quality Manager Service Solution Blackberry V5.2.1 (48 MB)

CZ95NEN - Tivoli Netcool Service Quality Manager Module for Blackberry Logs Service V1.1 (99 MB)

CZC7GEN - Tivoli Netcool Service Quality Manager Service Solution DSL Broadband V1.2.2 (2 MB)

CZ3TIEN - Tivoli Netcool Service Quality Manager Service Solution GPRS V1.4 (4 MB)

CZ3TJEN - Tivoli Netcool Service Quality Manager Service Solution GSM V1.4.1 (2 MB)

CZF36EN - Tivoli Netcool Service Quality Manager Module for HSPA PM Service V1.1 (2 MB)

CZ0UPEN - Tivoli Netcool Service Quality Manager Service Solution IPTV V3.2 (1 MB)

C1L5DEN - Tivoli Netcool Service Quality Manager Service Solution IP-VPN V3.2 (1 MB)

CZQT6EN - Tivoli Netcool Service Quality Manager Module for Mobile User Plane Service V1.1 (2 MB)

CZ183EN - Tivoli Netcool Service Quality Manager Service Solution Roaming V1.2.1 (5 MB)

CZ0ULEN - Tivoli Netcool Service Quality Manager Service Solution Short Messaging System V2.3 (3 MB)

CZK64EN - Tivoli Netcool Service Quality Manager Module for UMTS HSPA Trans Service V1.1 (2 MB)

CZQ87EN - Tivoli Netcool Service Quality Manager Module for UMTS Voice PM Service V1.1 (2 MB)

CZQ86EN - Tivoli Netcool Service Quality Manager Module for UMTS Voice Trans Service V1.1 (2 MB)

CZ0UMEN - Tivoli Netcool Service Quality Manager Service Solution Voice Mail V2.2 (2 MB)

CZ0UNEN - Tivoli Netcool Service Quality Manager Service Solution VoIP V2.3 (2 MB)

New / Updated Service Solutions are distributed quarterly

The above list was current as of November, 2010

8/17/2019 SG_sec

28/158


TNCEM Service Solutions

CZ95QEN - Tivoli Netcool Customer Experience Manager Module for Evdo Service V1.2 (.5 MB)

CZ95VEN - Tivoli Netcool Customer Experience Manager Module for GPRS Service V1.3 (1 MB)

CZ95UEN - Tivoli Netcool Customer Experience Manager Module for GSM Voice Service V1.2 (1 MB)

CZ95REN - Tivoli Netcool Customer Experience Module for MMS Service V1.2 (.5 MB)

CZIX7EN - Tivoli Netcool Customer Experience Manager Module for Mobile User Plane Service V1.1 (1

MB)

CZ95TEN - Tivoli Netcool Customer Experience Manager Module for Roaming Service V1.2 (2 MB)

CZ95SEN - Tivoli Netcool Customer Experience Manager Module for SMS Service V1.2 (1 MB)

CZC7IEN - Tivoli Netcool Customer Experience Manager Service Solutions iUMTS-HSDPA V1.3 (1 MB)

CZIX6EN - Tivoli Netcool Customer Experience Manager Module for UMTS HSPA Trans V1.1 (1 MB)

CZC7HEN - Tivoli Netcool Customer Experience Manager Service Solutions iUMTS Voice V1.2 (.5 MB)



8/17/2019 SG_sec

29/158


Global Object Module Service Solutions

CZ0FEEN - Tivoli Netcool Service Quality Manager Service Solution GOMV1.4 for Solaris and AIX (.5 MB)

CZ0FEEN - Tivoli Netcool SQM/CEM Global Object Module (GOM) V1.5

Multiplatform (.5 MB)

CZF77EN - Tivoli Netcool SQM/CEM Global Object Module (GOM) V1.6Multiplatform (.5 MB)

CZQ85EN - Tivoli Netcool SQM/CEM Global Object Module (GOM) V1.7Multiplatform (.5 MB)



8/17/2019 SG_sec

30/158


Oracle Packages

Oracle 10g: – 10gr2_db_sol.cpio.gz (873 MB)

Oracle Patch Set 4 for Oracle 10g:

– p6810189_10204_Solaris-64.zip (1.2 GB)

Oracle “one off” patches: – p6396242_10204_Generic

– p7306915_10204_SOLARIS64

Total disk (compressed) = 2.0 GB

8/17/2019 SG_sec

31/158


LDAP & JMS

SunOne Directory Server (LDAP) – ds.5.2.P4.Solaris.SPARC.full.tar.gz (77 MB)

Sun Java Message Queue System (JMS)

– mq3_7ur2-ent-solsparc.zip (38 MB)

8/17/2019 SG_sec

32/158


Workshop 1

To begin the hands-on exercises

– Download workbook number 1 – Follow all the steps to complete the exercises – When complete, continue on to workshop 2

To begin Workshop 2 – Download and view the presentation – Platform Installation

8/17/2019 SG_sec

33/158


Workshop 2TNSQM/TNCEM

Platform Software Installation

8/17/2019 SG_sec

34/158


Objectives

Goal – install platform software components

– Oracle

– SunOne Directory Server

– Java Message Queue

– WebSphere

Approximate time – 1:15 minutes

8/17/2019 SG_sec

35/158


Installation – Platform PackageApproximate Time – 10 mins

8/17/2019 SG_sec

36/158


Platform Package

Installs custom “helper scripts” in /var/install/sbin

These are used to install: – Oracle – SunOne – JMS – WebSphere

Platform package found in CZS0GEN – IBM Tivoli NetcoolService Quality Manager v4.1.3 for (1.3 GB)

8/17/2019 SG_sec

37/158


Platform Package Installation

Do the following as root

Expand the installation files for the base TNSQM software – cd /appl/INSTALLFILES – tar –xvf CZS0GEN.tar

Expand the platform tar file: – cd core.solaris64-sparc.install – cp –R * /appl – cd /cem.solaris64-sparc.install

– cp –R * /appl – cd /appl – gunzip ibm-tn-plat-install-PLAT1.0.0.49.tar.gz – tar –xvf ibm-tn-plat-install-PLAT1.0.0.49.tar

Run the platform installation script – ./ibm-tn-plat-install.install now

8/17/2019 SG_sec

38/158


Server Preparation

Create users, groups – cd /var/install/sbin – ./setup_users –product serviceassure

Set file permissions – chown oracle:dba /ora*

– chown saserver:sa /data/*

8/17/2019 SG_sec

39/158


Installation – Oracle ProductApproximate Time – 30 mins

8/17/2019 SG_sec

40/158


Oracle Installation

Use custom “helper script” in /var/install/sbin

Installs the Oracle software and patches

Oracle base installation package and patch4 package must

be expanded before use

Oracle one-off patches must be expanded before use

Oracle is installed (by default) into /appl/oracle

8/17/2019 SG_sec

41/158


Oracle Installation – Software Preparation

Perform the following as root

Expand Oracle base software – cd /appl/oracle/base

– gzip –d 10gr2_db_sol.cpio.gz – cpio –idm < 10gr2_db_sol.cpio

Expand Patch Set 4 software

– cd /appl/INSTALLFILES/oracle/patch4 – unzip p6810189_10204_Solaris-64.zip

Expand the one-off patches

– cd /appl/INSTALLFILES/oracle/one-off – unzip p6396242_10204_Generic.zip – unzip p7306915_10204_SOLARIS64.zip

8/17/2019 SG_sec

42/158


Oracle Installation


Run the Oracle Installation script – cd /var/install/sbin – ./oracle10gR2_install – Select the type of install you wish to execute

• Enter: 1

– Please enter the location of the Oracle 10.0.2.0.1 software• Enter: /appl/INSTALLFILES/oracle/base

– Please enter the install location of the Oracle base [/appl/oracle]• Accept the default

– Please enter the value of ORACLE_HOME

• [/appl/oracle/product/10.2.0/db_1]• Accept the default – Please enter the value of ORACLE_HOME_NAME [OraDBHome1]

• Accept the default

Installation runs …

– Enter the full pathname of the local bin directory [/usr/local/bin]• Accept the default

8/17/2019 SG_sec

43/158


Oracle Installation - cont

Would you like to install the Oracle companion software? – Enter: n

Please enter the location of the Oracle 10.0.2.0.4 patch set – Enter: /appl/INSTALLFILES/oracle/patch4/Disk1


Enter the full pathname of the local bin directory [/usr/local/bin] – Accept the default

The file “dbhome” already exists in /usr/local/bin. Overwrite it? (y/n) – Enter: y

The file “oraenv” already exists in /usr/local/bin. Overwrite it? (y/n) – Enter: y

The file “coraenv” already exists in /usr/local/bin. Overwrite it? (y/n) – Enter: y

Please enter the location of the Oracle 10.0.2.0.4 one-off patches – Enter: /appl/INSTALLFILES/oracle/one-off

Oracle Installation complete

8/17/2019 SG_sec

44/158


Installation – Directory Server Approximate Time – 10 mins

8/17/2019 SG_sec

45/158


Directory Server Installation


Installs the SunOne Directory Server software

Installation package can be left compressed

Package is installed (by default) into /appl/ds

NOTE: the lab server uses a logical link for /appl. Theinstallation requires the “real” path to /appl

8/17/2019 SG_sec

46/158


Directory Server Installation


Run the installation – note the directory path on the install command – cd /var/install/sbin – ./ds_install –base /storage/appl –product serviceassure

– Enter the full path of the DS package• Enter:/appl/INSTALLFILES/sun/ldap/ds[1].5.2.P4.Solaris.SPARC.full.tar.gz

– Please, Enter the LDAP Port: [1389]• Accept the default

– Please, Enter the LDAP Admin Port: [16762]• Accept the default

– Please, Enter the LDAP Root: [dc=comnitel, dc=com]• Accept the default – Please, enter the password for cn=Directory Manager: [Dirmgr01]

• Accept the default – Please, enter the password for ldapadm: [Ldapadm01]

• Accept the default


8/17/2019 SG_sec

47/158


Installation – Java Message

QueueApproximate Time – 5 mins

8/17/2019 SG_sec

48/158


JMS Installation


Installs the Java Message Queue software


Package is installed (by default) into /appl/

8/17/2019 SG_sec

49/158


JMS Installation


Run the installation

– cd /var/install/sbin – ./imq_install –product serviceassure – Enter the full path of the IMQ package – Enter: /appl/INSTALLFILES/sun/jms/mq3_7ur2-ent-

solsparc.zip


8/17/2019 SG_sec

50/158


Installation – WebSphereApproximate Time – 10 mins

8/17/2019 SG_sec

51/158


WebSphere Installation


Installs the WebSphere software


Package is installed (by default) into /appl/IBM

Requires CZS0EEN – IBM Tivoli Netcool Service Quality Managerv4.1.3 WAS for Solaris (608 MB)

8/17/2019 SG_sec

52/158


WebSphere Installation


Unpack the WebSphere installation file – cd /appl/INSTALLFILES – tar –xvf INSTALLFILES/CZS0EEN.tar

Move the new WebSphere installation file to /appl – cd /appl – mv INSTALLFILES/WAS_61027_CIP.tar.gz .

Run the installation – cd /var/install/sbin – ./was_install –base /appl – Enter the full pathname of the WAS package

• Enter: /appl/WAS_61027_CIP.tar.gz – Installation runs …

8/17/2019 SG_sec

53/158


Summary

8/17/2019 SG_sec

54/158


Installation Summary

Platform package installed

Oracle software installed

SunOne Directory Server software installed

Sun Java Message Queue software installed

WebSphere Application Server software installed

8/17/2019 SG_sec

55/158


Workshop 2 Exercises


– Download workbook number 2 – Follow all the steps to complete the workshop exercises – When complete, continue on to workshop 3

To begin Workshop 3 – Download and view the presentation – TNSQM Installation

8/17/2019 SG_sec

56/158


Workshop 3TNSQM / TNCEM Installation

8/17/2019 SG_sec

57/158


Objectives

– Install TNSQM

– Install TNCEM

– Validate system

– Configure system to forward SNMP traps


8/17/2019 SG_sec

58/158


Installation – TNSQM / TNCEMApproximate Time – 2-3 Hours

8/17/2019 SG_sec

59/158


TNSQM Installation

Use custom “helper script” in /appl

Installs the TNSQM software – Starts Oracle

– Creates core Oracle database and tables – Provisions LDAP – Starts WebSphere – Configures WebSphere

Installation runs as a sequential script – Make sure that the process cannot be interrupted – Restarts may not be successful

Package is installed (by default) into /appl/sa

8/17/2019 SG_sec

60/158


TNSQM Installation

The installation is performed as the saserver user – Use root to change file ownership of /appl to the saserver user

The installation files were already unpacked previously

Run the installation as saserver – cd /appl – ksh sqm_install –wmcr /appl/sa

This installation script will install the IBM Tivoli Netcool Service QualityManagement software version SQM4.1.3.57.10 on your system.

Do you wish to continue?

Enter: Y – The license agreement is displayed. Press to get to the end.

Do you agree with the terms of this license?

Enter: Y

What Type of Service Quality Manager System are you installing?

Enter: 1 (All Inclusive)

8/17/2019 SG_sec

61/158


TNSQM Installation – cont.

Business Objects Version – Business Objects is not being used, reply with none

Please enter the installed Business Objects version

(6.5/XI/none): []---->

Enter : none

Service Quality Manager CoreThe following is a list of the default Service Quality Manager

Variables:

NOTE: review the list and adjust any that are required.

If changes are required, enter: N

The list of parameters appear in a “vi” window

Adjust as necessary

Enter: :w! (save changes)

Enter: :q! (exit vi)

Is the configuration OK (y[es]/n[no]/s[ee the configuration])?

Enter: y

8/17/2019 SG_sec

62/158



Configure Directory Server Do you want to install Directory Server Configuration ? [Yes]

Accept the default

The following is a list of the default Service Quality Manager Variables :

1. LDAPROOT=dc=comnitel,dc=comTo accept these values enter 'Y' else enter 'N' to modify the values (Y/N)

Enter: YPlease enter the password for 'cn=Directory Manager', theDirectory Server User [Dirmgr01]:

Accept the defaultPlease enter the password for 'system', the Directory Server User

[Saserver01]:Accept the default

Please enter the password for 'useradm', the Directory Server User

[Useradm01]:Accept the default

Please enter the password for 'swvadm', the Directory Server User[Swvadm01]:Accept the default

8/17/2019 SG_sec

63/158



Configure Message QueueDo you want to install Sun Java System Message Queue

Configuration ? [Yes]

Accept the defaultThe following is a list of the default Service Quality Manager

Variables :

1. BROKER1HOST=tsedev20

2. BROKER1PORT=76813. BROKER2HOST=tsedev20

4. BROKER2PORT=7680

5. OMPORT=9008

To accept these values enter 'Y' else enter 'N' to modify the values(Y/N)Enter: Y

8/17/2019 SG_sec

64/158



Configure Socks ProxyThe following is a list of the default Service Quality Manager

Variables :

1. SERVER_IP_ADDRESS=192.168.1.225

2. SHORT_IP_ADDRESS=192.168.1

To accept these values enter 'Y' else enter 'N' to modify the values(Y/N)

Enter:Y

The following is a list of the default Service QualityManager Variables :

1. SHORT_IP_ADDRESS=192.168.1

To accept these values enter 'Y' else enter 'N' to modify the values(Y/N)

Enter: Y

8/17/2019 SG_sec

65/158



Configure Web Server The following is a list of the default Service Quality Manager

Variables :

1. TOMCAT_SERVER_PORT=8093

2. HTTPS_PORT=8094

3. WSPORT=9060

4. WSHOST=tsedev20.tivlab.austin.ibm.com

To accept these values enter 'Y' else enter 'N' to modify the values

(Y/N)Enter: Y

Configure WebSphere

Please enter the LDAP swvadm password: [Swvadm01]Accept the default

NOTE: this step will run for several minutes (could be 15-20 minutes or longerdepending upon server speed), and the WebSphere application components

will be stopped and started multiple times.

8/17/2019 SG_sec

66/158



Build SQM Database - sadbWould you like to perform task SA_DB_INSTALL ? [yes/no] >Enter: yes

Please, Enter the required Database Type (sadb/repos):---->sadbAccept the default

Please, Enter your Database SID (8 character maximum):---->sadbAccept the default

Please, Enter your Database Size

(sml(10G)/med(20G)/lge(50G)/xlg(100G)/xxl(200G)/custom):---->lgeChange the default value to sml

Please, Enter the sys user password:---->Sysdb01Accept the default

Please, Enter the system user password:---->Sysdb01Accept the default

NOTE: this step may take 1 hour to complete.

8/17/2019 SG_sec

67/158



Build SQM Database - reposWould you like to perform task REP_DB_INSTALL ? [yes/no] >

Enter: noNOTE: Only required if using Business Objects. The workshopdoes NOT use Business Objects

Build Core Database SchemaWould you like to perform task CORE_SCHEMA_INSTALL ? [yes/no]>Enter: yes

8/17/2019 SG_sec

68/158



Create CRON tasks for log file maintenanceWould you like to perform task CORE_CRON_INSTALL ? [yes/no] >

Enter: yesWhat Type of Service Quality Manager System Are you Installing ?


Please enter the location of the ORACLE_HOME Directory[/appl/oracle/product/10.2.0/db_1]:Accept the default

Please enter the location of the sadb Database Archive Directory [/oradump]:Accept the default

Please enter the location of the repos Database Archive Directory [/oradump]:

Accept the defaultPlease enter the location of the IMQ Software Directory [/]:

Accept the defaultPlease enter the location of the Directory Server Software Directory [/appl/ds]:

Accept the defaultPlease enter the location of the ServerAssure Log Directory [/appl/sa/logs]:

Accept the defaultPlease enter the location of the ServerAssure Archive Logs Directory[/data/trace_archive1]:Accept the default

8/17/2019 SG_sec

69/158



TNCEM InstallationWould you like to perform task CEM_INSTALL? [yes/no] >

Enter: yesWhat Type of Service Quality Manager System Are you Installing ?


Please enter the location of the Service Quality Manager Softwarepackages [/appl]:Accept the default

The following is a list of the default Service Quality Manager Variables :1. MAIL_USERNAME=saserver

2. MAIL_PASSWORD=Saserver013. SADB_USERNAME=saserver 4. SADB_PASSWORD=Saserver01

To accept these values enter 'Y' else enter 'N' to modify the values (Y/N)Enter: Y

8/17/2019 SG_sec

70/158



CEM Installation (cont.)The following is a list of the default Service Quality Manager Variables :

1. OMPORT=9008To accept these values enter 'Y' else enter 'N' to modify the values (Y/N)

Enter: YPlease enter the LDAP swvadm password: [Swvadm01]

Accept the defaultPlease enter the LDAP Directory Manager password: [Dirmgr01]

Accept the defaultNOTE: this step could take 15-20 minutes to complete. The WebSphere application will

stopped and started multiple times.

Encode PasswordsWould you like to perform task ENCODE_PASSWORDS ? [yes/no] >

Enter: yes

Installation is complete!!

8/17/2019 SG_sec

71/158



Verify that all core services are onlinesvcs | grep serviceassureonline 19:34:22 svc:/application/serviceassure/ldap-sa:saonline 19:49:26 svc:/application/serviceassure/imq2-sa:saonline 19:49:26 svc:/application/serviceassure/imq1-sa:saonline 12:16:47 svc:/application/serviceassure/traprouter-sa:saonline 15:14:10 svc:/application/serviceassure/database-sa:globalonline 15:56:24 svc:/application/serviceassure/socks-sa:sa

online 15:56:33 svc:/application/serviceassure/sapmon-sa:saonline 15:56:39 svc:/application/serviceassure/sapmgr-sa:saonline 15:56:39 svc:/application/serviceassure/wp-sa:sa

8/17/2019 SG_sec

72/158


Post Installation

Enable Time Zone support – Become the saserver user

su – saserver

– Edit the time zone property file

cd /appl/sa/conf/adapter/

vi timezone.properties – Set timezone.enabled to true:

# enable/disable global timezone support

com.comnitel.timezone.enabled= true

8/17/2019 SG_sec

73/158


Post Installation – Platform Stop

Stop platform processes (as root) – if necessarysvcadm disable sapmgr-sasvcadm disable sapmon-sasvcadm disable traprouter-sasvcadm disable imq2-sasvcadm disable imq1-sa

svcadm disable wp-sasvcadm disable ldap-sasvcadm disable database-sa

8/17/2019 SG_sec

74/158


Post Installation – Platform Start

Start platform processes (as root) – if necessarysvcadm enable database-sasvcadm enable ldap-sasvcadm enable wp-sasvcadm enable imq1-sa

svcadm enable imq2-sasvcadm enable traprouter-sasvcadm enable sapmon-sasvcadm enable sapmgr-sa

8/17/2019 SG_sec

75/158


Post Installation – System Verification

Start the TNSQM components (as saserver)sap start domainsap start clientsap start cem

NOTE: Leave the “monitoring” components disabled untilafter the installation of the Service Solutions. Once one or

more Service Solutions are installed, there will be additional“adapter” components to start

8/17/2019 SG_sec

76/158


Summary

TNSQM is installed

TNCEM is installed

Oracle is configured for TNSQM, TNCEM and is running – database-sa

SunOne Directory Server is configured for TNSQM, TNCEM and isrunning – ldap-sa

Java Message Queue is configured for TNSQM, TNCEM and isrunning – imq1-sa – imq2-sa

WebSpshere is configured for TNSQM, TNCEM and is running

– wp-sa

W k h 3

8/17/2019 SG_sec

77/158


Workshop 3


– Download workbook number 3 – Follow all the steps to complete the workshop exercises

– When complete, continue on to workshop 4

To begin Workshop 4

– Download and view the presentation – Service Solution Overview

8/17/2019 SG_sec

78/158


Workshops 4 & 5Service Solutions

8/17/2019 SG_sec

79/158


Objectives

Workshop 4 – Install TNSQM Module for IP VPN Services – Install and configure synthetic data generator

Workshop 5 – Install TNCEM Module for UMTS Voice Services – Install and configure synthetic data generator

Service Solution Overview – Describe components of a Service Solution – Describe the Global Object Model – Describe differences in Service Solution packaging – Describe options for data generation

8/17/2019 SG_sec

80/158


TNSQM/CEM Service Solution Overview

What is a Service Solution? – It is an installable component designed to enable service providers to monitor

and report on the service quality delivered to their end customers for a specificservice offering (e.g. VOIP, Blackberry email, IP-VPN).

Data Persistence

Root Cause Analysis

Historical Trending

SLA/Service Monitor ing

SLA/Service Reporting

V O I P

I P - V P N

I P T V

Tivol i Netcool Service Quality Manager (TNSQM)

VOIP

IP-VPN

IPTV

Blackberry

SMS

Voice Mail

GPRS

…

IBM Service Solut ionLibrary

B l a c k B

e r r y

Service Solutions can easily be added over time to deliver immediate value across the service provider organization

S i S l ti

8/17/2019 SG_sec

81/158


Service Solutions

Strategy – Put in place a framework to allow the development of service models (and

associated components) which have been designed in a generic manner toenable high volume sales as pre-packaged solutions, delivering immediatebusiness value.

Objectives – Easy to install – Immediate Value to end customer – Standalone and independent Service Solution Components

Bundle Service Solutions into manageable, modular entities

– Models (SLA, KQI, Adapter) – Reports – Mediation* – Documentation

Vendor-Neutral ModelsVendor-Specific Mediation

8/17/2019 SG_sec

82/158


Service Solution Components

CSV input format,to feed adapter layer

Vendor Specific Mediationtransforms raw data intoa predefined format.

Vendor mRaw Data

Vendor 1Raw Data

Vendor 2Raw Data …

Adapter (s)

Combiner

SLA (s) SLAT (s)

Reports

KPI & KQI

DB Tables

Data Sheet

Vendor-Specific

Agent (1)Vendor-Specific

Agent (2)

Vendor-Specific

Agent (m)…

Unchanged for

each deployment

Vendor specific

mapping done

Via project deployment

Vendor neutral data recordspresented to adapter layer

User

Documentation

Scope ofService Solution

Mediation done on A pro ject basis

S S

8/17/2019 SG_sec

83/158


Service Solution Evolution

Service Solutions have been evolving over time

Elements of “evolution”

– Global Object Model (GOM) Support – Packaging – Documentation – Features and functions

This results in significant differences between various ServiceSolutions – Older ones may or may not support the GOM – Older ones may or may not have complete documentation

Service Solutions will eventually evolve to the same format andcontent

8/17/2019 SG_sec

84/158


Global Object Model

The Global Object Model (GOM) defines Resource Types that are generic toone or more Service Solution

Gl b l Obj t M d l t

8/17/2019 SG_sec

85/158


Global Object Model - cont

There is one “Global” GOM that contains Resource Types for allService Solutions

There are typically Service Solution specific GOMs, that provide

Resource Types unique to each Service Solution

The contents of the GOM have been evolving over time – Version 1.5 was recently released

Not all Service Solutions are currently compatible with the latestGOM – Overlapping Resource Types

Release Notes for each Service Solution indicate if the GOMis required and which version is supported

P k i ( GOM 1 3)

8/17/2019 SG_sec

86/158


Packaging (pre-GOM v1.3)

Service Solutions are distributed as a single tar file, e.g., IPVPN v3.1 – C1F5SEN.tar

When expanded, it produces the following:Generic Installation GuideOverview GuideRelease Notesibm-tn-sqm-vpn-gom-3.1.0.2.tar.gz

ibm-tn-sqm-vpn-ipvpn-pm-3.1.0.2.tar.gzibm-tn-sqm-vpn-ipvpn-pm-demo-3.1.0.2.tar.gz

Expanding the “pm” file produces the following:ibm-tn-sqm-vpn-ipvpn-pm.install - a script

ibm-tn-sqm-vpn-ipvpn-pm.license - text license fileibm-tn-sqm-vpn-ipvpn-pm.remove - a scriptibm-tn-sqm-vpn-ipvpn-pm.sw - tar file

8/17/2019 SG_sec

87/158


Packaging – cont.

Expanding the “sw” file produces the following: – sa/admin

• oracle/schema/vpn_ipvpn_pm_3.1o nc - sql definitions for Network Configuration

Tables

o pm - sql definitions for KPI table, views, etc• provision/install

o service - Business Objects report definitions forTNSQM

o technology - KQI and Resource Type definitions• report/bo/reports/vpn/ipvpn/pmo logos - These directories contain

o reports - various files that must be copied

o universes - to the BO server

• smp/vpn/ipvpn/pmo loader - property file and csv definition

o report.zip - more BO stuff • vpn_ipvpn_pm/install/environment

o vpn_ipvpn_pm_env - properties for adapter

P k i t

8/17/2019 SG_sec

88/158


Packaging – cont.

The initial “install” step performs three basic functions – Copies files to various directories – Configures adapter property file – Adds an entry to /etc/software

– Basically places files in various directories to be used in the remainderof the install process

The rest of the installation is completed manually – Provisioning – Database table creation – Adapter installation

N P k i (GOM 1 3 +)

8/17/2019 SG_sec

89/158


New Packaging (GOM v1.3 +)

Service Solutions are distributed as a single tar file, e.g., IPVPN v3.2 – C1L5DEN.tar

When expanded, it produces the following:Generic Installation GuideOverview GuideRelease Notesibm-tn-sqm-ip_vpn-gom-3.2.0.4.tar.gz

ibm-tn-sqm-ip_vpn-pm-3.2.0.4.tar.gzip_vpn-pm-test-3.2.zip

Expanding the “pm” file produces the following:ibm-tn-sqm-ip_vpn-pm.install - a scriptibm-tn-sqm-ip_vpn-pm.license - text license fileibm-tn-sqm-ip_vpn-pm.remove - a scriptibm-tn-sqm-ip_vpn-pm.sw - tar file

8/17/2019 SG_sec

90/158


New Packaging – cont.

Expanding the “sw” file produces the following: – sa/packages/ip_vpn_pm_3.2

• admin

o deploy

» adapter.propertieso oracle/schema/ip_vpn_pm

» sql definitions for KPI table, views, etco provision

» Various xml files for reports, resources,KQIs, etc

• bin

o adapter.env• conf

o processes

» processes.properties

o adapter » data

Ne Packaging cont

8/17/2019 SG_sec

91/158


New Packaging – cont.

The initial “install” step performs three basic functions – Copies files to various directories – Configures adapter property file – Adds an entry to /etc/software – Basically places files in various directories to be used in the remainder of

the install process

The installation process is different than it was under GOM v1.2 – Provisioning

• package_mgmt –I

– Database table creation – • /appl/sa/packages/adp_deploy.xml do-schema

– Adapter installation• cd /appl/sa/packages• wmc_ant -Dsa.package=__ -f adp_deploy.xml do-deploy

Documentation

8/17/2019 SG_sec

92/158


Documentation

Service Solutions contain documentation – Generic Installation Guide

• Installation instructions that are generic to all Service Solutions – Overview Guide

• Description of the functional aspects of the Service Solution – Release Notes

New Service Solutions also contain the Interface Control Guide – Detailed description of input requirements

Eventually, all Service Solutions will have the ICG

Features and Functions

8/17/2019 SG_sec

93/158


Features and Functions

TNSQM v4.1 introduced the Visual Service Model feature

The newer Service Solutions come with a pre-configuredVisual Service Model – Blackberry v5.2 – DSL Broadband v1.1 – GPRS v1.3 – GSM v1.2

– IP VPN v3.1, v3.2 – Roaming v1.1, v1.2

– others

Eventually, all Service Solutions will come that way

Options for Data Generation

8/17/2019 SG_sec

94/158


Options for Data Generation

Bundled “demo” capability – Comes with each Service Solution – Requires additional installation step(s) – Data generated every 15 minutes – DOESN’T vary

IP VPN Demo Package

– Not bundled with the Service Solution – Generates data at 5 minutes granularity – Data varies by time – good for showing SLA transitions

CEM Simulator – Generates user and group definitions

– Generates data every 15 minutes – Data contains variations

Create custom csv file – Content has to match requirements of Service Solution – Possible, but not likely

IP VPN Demo

8/17/2019 SG_sec

95/158


IP VPN Demo

Package contained in one tar file

Expand in home directory for saserver

Requires custom provision step to create required Resources

Script MakeCSIPVPNfiles.sh – Generates individual csv files for every 5 minutes of the current day – Can be run via crontab for continuous data generation

Script loadIPVPNdata.sh – Copies one csv file every 5 minutes to adapter input directory – Processed normally by the standard adapter – Requires crontab entry to guarantee success

CEM Simulator

8/17/2019 SG_sec

96/158


CEM Simulator

Requires a separate installation file that is not included with the system

Requires a separate installation step and provision step – Run the install – Run topology_gen to create custom provisioning file – Run provision step

Run the data_gen step – New data is generated every 15 minutes – This data is moved to the adapter input directories (Gb and Gn) – Processed normally by the standard adapters

Produces a complete CEM configuration – Users – Groups – Services – Devices

Workshop Lab Exercise 4 & 5

8/17/2019 SG_sec

97/158




– There are two lab exercises for Service Solution installs• Lab 4 – IP VPN Service Solution (for TNSQM)

• Lab 5 – UMTS Voice Service Solution (for TNCEM) – Download lab workbooks numbers 4 and 5 – Follow all the steps to complete both lab exercises – When complete, continue on to workshop 6

To begin Workshop 6 – Download and view the presentation – Client Overview

8/17/2019 SG_sec

98/158


Workshop 6

Client Overview

Objectives

8/17/2019 SG_sec

99/158


Objectives

– Configure Socks Proxy – Download & install TNSQM thick client – Configure student workstation thick client for proxy use

– Configure student workstation browser for proxy use – Create new TNSQM user – Validate client access to TNSQM and CEM


Client Types

8/17/2019 SG_sec

100/158


Client Types

TNSQM thick Client – Software installed on user workstations – TNSQM administrative interface

User Administration – Browser-based

Web Portal – Browser-based – TNSQM SLA WebView• Read-Only access to TNSQM SLA Monitoring

– Cellular CEM• Primary CEM interface for investigating user issues

– SLO Management• Interface for creating CEM Service Level Objectives (SLOs)

– SLO Monitoring• Interface for monitoring state of SLOs

– Access to all user functions is controlled by individual LDAP roles

TNSQM thick Client Installation

8/17/2019 SG_sec

101/158


SQ c C e s a a o

Typical Production Install – Open a browser and connect to URL

http://:8092/webstart

– Select the link to download and install client

Lab Install

– Lab servers are situated behind a firewall• Network Address Translation (NAT) is used• Restricted port forwarding

– Necessitates modified installation process• Download the client software manually• Run the install manually

Socks Proxy Configuration

8/17/2019 SG_sec

102/158


Socks Proxy Configuration

Socks Proxy required for client access to Lab servers – Compensates for Network Address Translation (NAT) – Compensates for restricted port forwarding

• Proxies all access thru one user-defined port

Configuration Steps – TNSQM Server

• Change default port from 1080 to 3389

o Lab firewall is configured to allow this port number • Change “client pass …”

from: 192.168.35.0/24 port 1-65535 to: 192.168.35.0/24

To

from: 9.0.0.0/8 port 1-65535 to: 192.168.35.0/24

• Restart Socks Proxy

Student Workstation Configuration

8/17/2019 SG_sec

103/158


Student Workstation Configuration

The default browser on the student workstation must beconfigured to use a proxy server – Details listed in Workshop 6

TNSQM thick Client on the student workstation must beconfigured to use the socks proxy – Details listed in Workshop 6

Workshop Lab Exercise 6

8/17/2019 SG_sec

104/158


p


– Download lab workbook number 6 – Follow all the steps to complete the lab exercise

– When complete, continue on to workshop 7

To begin Workshop 7

– Download and view the presentation – How to Demo TNSQM

8/17/2019 SG_sec

105/158


Workshops 7 & 8How to demo TNSQM / TNCEM

Demo Resources

8/17/2019 SG_sec

106/158


Demo Resources

Tivoli Integrated Demo Environment-TIDE-AGhttp://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74

– TNCEM v4.1.2• CEM w/ GPRS & UMTS

• 3 scenarios covering: Congestion, Roaming, and Tracking Handsets• Storyboard documents available

– TNSQM v4.1• Blackberry & VoIP demos• Storyboard documents available

• TBSM Integration• Integration w/ Business Objects

VMWare Images – Work-in-Progress

– Check Tivoli demo library for current statushttp://depot.tivlab.raleigh.ibm.com/

Demo Startup / Verification - Troubleshooting

http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74http://depot.tivlab.raleigh.ibm.com/http://depot.tivlab.raleigh.ibm.com/http://depot.tivlab.raleigh.ibm.com/http://depot.tivlab.raleigh.ibm.com/http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74http://w3-103.ibm.com/software/xl/portal/viewcontent?type=doc&srcID=T9&docID=S405499Y99141E74

8/17/2019 SG_sec

107/158


Demo Startup / Verification Troubleshooting

The vast majority of issues with components not starting aredue to TIME – not waiting long enough for components toactivate

It takes a fair amount of time for the components to startcompletely

Even though TIDE says the demo is ready, it may take

additional time for the TNSQM / TNCEM components toactivate completely

Make sure to schedule the demo to start well before it’s needed

– Note: for the TNCEM demo it is recommended to schedule the demo atleast one hour prior to when it’s needed

Types of Demos

8/17/2019 SG_sec

108/158


Types of Demos

Two basic categories of demos – Static Demo

• Show feature and function based upon static (old) data

• Very good for demonstrating diagnostic capabilities• TIDE-AG demos are both static

– Active Demo• Synthetic data being processed periodically• Good for showing workflow in a semi-realistic manner • Able to demonstrate customization and results• This SPVC provides active demos

Lab 7 – TNSQM Demo Exercises

8/17/2019 SG_sec

109/158


Lab 7 TNSQM Demo Exercises

Create SLA Template

Create Custom SLA

Monitor SLA State – TNSQM thick Client – SLA WebView

Create Custom KQI

Monitor custom KQI using KQI Analyzer

NOTE: make sure the VPN simulated data is being generatedand processed before starting this workshop

Lab 8 – CEM Demo Exercises

8/17/2019 SG_sec

110/158


Lab 8 CEM Demo Exercises

Basic CEM User Interface Functions

Simulated Troubleshooting of a specific Customer

Evaluating a Group of Customers

Configuration of a custom Service Level Objective

(SLO)

Monitoring the State of that SLO

NOTE: make sure the CEM simulated data is beinggenerated and processed before starting this workshop


8/17/2019 SG_sec

111/158



– There are two lab exercises for the How to Demo workshop• Lab 7 – TNSQM Demo Exercises

• Lab 8 – TNCEM Demo Exercises – Download lab workbooks numbers 7 and 8 – Follow all the steps to complete both lab exercises

To begin the next video – Download and view the presentation – Troubleshooting

8/17/2019 SG_sec

112/158


Troubleshooting Techniques

Platform Products

8/17/2019 SG_sec

113/158


Platform products - Oracle, LDAP, JMS, WebSphere

Installation Issues – Messages displayed on console – Individual log files for each product install

Startup Issues – svcs | grep assure – shows current status – If “offline” or “maintenance”

• svcs –x | grep assure• Check displayed log file for issues

– If “maintenance”• svcadm clear xxxx-sa

TNSQM Components

8/17/2019 SG_sec

114/158


Installation Issues – Messages displayed on console – Individual log files for each component

• /appl/sa/logs//

Startup Issues – sap start – sap disp – Failed or Restarting

• Check component log for issues

Service Solutions

8/17/2019 SG_sec

115/158


Use KQI Analyzer feature to check for KQI data in TNSQM

NO Data in TNSQM – Is the loader running?

• sap disp adapters – Any issues with the running loader?

• cd /appl/sa/logs/• more -server.log

– Is the source data getting to the loader?• cd /appl/sa/var/adapater/• C20080917.1325-20080917.1330 _demo.csv

– Is the data being processed by the loader?• C20080917.1325-20080917.1330_demo.csv.20080917133500.processed

TNSQM thick Client Issues – Unable to discover server

8/17/2019 SG_sec

116/158


Verify server name

Verify server name resolves

to correct IP address on thelocal workstation

Is the TNSQM server locatedbehind a firewall?

– Ports could be blocked byfirewall

– May need to use Socks Proxy

TNSQM thick Client Issues – Additional Debug data

8/17/2019 SG_sec

117/158


Unexplained client errors mayrequire additional debug

Open Webstart property settings

– Start => Programs => IBM TivoliNetcool => Service QualityManager => Utilities => ServiceQuality Manager • Enable Trace Management

• Set Trace Level to DEBUG4

Review output in trace log – C:\Program Files\IBM Tivoli

Netcool\Service QualityManager\trace\sadesktopsadesktop-server.log

TNSQM thick Client Issues – Clear Client Cache

8/17/2019 SG_sec

118/158


Unexplained client errorsmay be caused by cacheissues

Open Cache Browser – Start => Programs => IBM

Tivoli Netcool => ServiceQuality Manager => Utilities

=> Cache Browser • Highlight the entry for the

server • Select Purge

part_admin Utility

8/17/2019 SG_sec

119/158


p y

CLI utility to report on various aspects of Oracle Partition usage

List all Tablespaces and their current used/free space – part_admin –listspace

TABLESPACE NAME TOTAL SIZE(MB)

8/17/2019 SG_sec

120/158


p

Oracle fails to start – svcadm enable database-sa – svcs | grep assure – offline …. svc:/application/serviceassure/database-sa:global

Places to look: – /appl/oracle/product/10.2.0/db_1/startup.log – /appl/oracle/admin/sadb/bdump/alert_sadb.log

Attempt to start manually – su – oracle – sqlplus / as sysdba – startup – Error messages will be displayed on screen

Oracle Enterprise Manager

8/17/2019 SG_sec

121/158


g

Start OEM – run as oracle user – $ORACLE_HOME/bin/emctl start dbconsole

Stop OEM – run as oracle user – $ORACLE_HOME/bin/emctl stop dbconsole

Status OEM – run as oracle user

– $ORACLE_HOME/bin/emctl status dbconsole

Access OEM – http://:1158/em

– Login as saserver

OEM – Performance TAB

8/17/2019 SG_sec

122/158


OEM – Administration TAB

8/17/2019 SG_sec

123/158


OEM – Maintenance TAB

8/17/2019 SG_sec

124/158


8/17/2019 SG_sec

125/158


Workshop 9

TBSM / TNSQM Integration

Workshop 9 – TBSM / TNSQM Integration

8/17/2019 SG_sec

126/158


Goal – install and configure the TBSM / TNSQM Integration – Configure OMNIbus Event Integration

– Configure TBSM Service Auto-Population

– Configure TNSQM Metrics in TBSM Service Trees

– Configure Single Sign On (SSO)

– Configure TNSQM KQI Charting in TBSM Dashboards

– Configure Launch-in-Context


TBSM – TNSQM / TNCEM Integration Overview

8/17/2019 SG_sec

127/158


Event Based Integration – SNMP traps produced by TNSQM and TNCEM – MTTrapd Probe produces OMNIbus events – OMNIbus events feed TBSM auto-population rules – TBSM Service Instances produced dynamically

Data Integration – TBSM Data Fetcher retrieves metrics from TNSQM / TNCEM database – Metrics published in TBSM Service Trees – KQI Charting tools embed TNSQM /TNCEM graphs in TBSM dashboards

Tool Integration – Single Sign On (SSO) between Tivoli Integrated Portal (TIP) and TNSQM Web

Portal – Common LDAP repository – Launch-in-Context between TIP and TNSQM Web Portal

DocumentationTivoli Netcool Service Quality Managemet Center Integration Guide

Event Based Integration

8/17/2019 SG_sec

128/158


SNMP traps produced by TNSQM and TNCEM – TNSQM Service Level Agreement (SLA) conditions – TNSQM Service Level Objective (SLO) conditions – TNCEM SLO conditions

MTTrapd Probe produces OMNIbus events – Custom rules files bundled with TNSQM and TNCEM – Sql files provided to create custom OMNIbus event columns

TBSM Service Instances produced dynamically – TBSM Service Templates

– TBSM auto-population rules

TBSM Integration Details:Event Based Integration

8/17/2019 SG_sec

129/158


TNSQM

OMNIbus

SLA Violation Alarms

TBSM

Auto-Population

rule

Manage SQM(IP-VPN SLA,

SLA conformance reports etc)

Visualize SQM violations Visualise SQM service hierarchyand violation status

Event Based Integration

VOIP

IP-VPN

IPTV

Blackberry

SMS

Voice Mail

GPRS

…

IBM Service Solution

Library

I P - V P N

V O I P

Alarms will contain:

•Customer

•Service

•Service Element

•KQI

•Resource

TBSM GUI Act ive Event List

Data Integration

8/17/2019 SG_sec

130/158


TBSM Data Fetcher retrieves metrics from TNSQM /TNCEM database – Metrics come directly from the database (Oracle)

– Specific metrics are configurable – Frequency of retrieval configurable

Metrics published in TBSM Service Trees – Service trees generated by event-based integration (service

auto-population) – Extend the contents by adding metrics retrieved by data fetchers – Enhances the value of the service tree

KQI Charting tools embed TNSQM /TNCEM graphs inTBSM dashboards – Charting tools bundled with TNSQM / TNCEM – Copy them to TBSM – Configure parameters to determine content of graphs

TBSM Customized Service Tree

8/17/2019 SG_sec

131/158


Service Tree generated by event-based integration – Technical Enablement

• VoiceVPNo Enterprise

» ibm

Additional metrics produced by data fetchers – Jitter – Latency

– Packet Loss

Displaying KQI History Charts in TBSM … SQM SLA

8/17/2019 SG_sec

132/158


KQI Value

KQI Weight

Clause

Thresholds

Clause / Resource details

Click anywhere on chart

to launch associated URL

(e.g. default Business

Objects report)

Multiple

charts

Tool Integration

8/17/2019 SG_sec

133/158


Single Sign On (SSO) between Tivoli Integrated Portal (TIP) andTNSQM Web Portal – TIP is based on WebSphere – TNSQM Web Portal is based on WebSphere

– Enable SSO in each copy of WebSphere

Common LDAP Repository – TNSQM / TNCEM use LDAP for user authentication

• Solaris – SunOne Directory Server • AIX – Tivoli Directory Server

– TNSQM Web Portal already configured to use LDAP – Configure TIP to use TNSQM LDAP

SSO enables launch-in-context between TIP and TNSQM WebPortal – Multiple launch points available

• TBSM Service Instance• TBSM Service Tree• WebGUI event list

– SSO & common LDAP eliminates need for secondary authentication – TNSQM/TNCEM Web Portal opens in context

TBSM / TNSQM Launch-In-Context

8/17/2019 SG_sec

134/158


SLA Violation Event

Tool launch from WebGUI event list

TNSQM Web Portal opens

SSO & common LDAP eliminatesecondary authentication

Web Portal opens to SLA Monitorview based upon context passed

TBSM Lab Configuration

8/17/2019 SG_sec

135/158


Required products already installed – TBSM v4.2.1 with FixPack 2

– OMNIbus v7.3 – WebGUI v7.3

– MTTrapd Probe

– Netcool Knowledge Library (NCKL) v3.0

Worshop Overview

8/17/2019 SG_sec

136/158


MTTrapd Probe Configuration

Auto-populating TBSM Service Instances based upon TNSQMSLA Events

Integrating TNSQM metrics into TBSM Service Trees

Single Sign-On (SSO) Configuration

Launching KQI History Charts

Launch-in-Context Configuration


8/17/2019 SG_sec

137/158



– Download lab workbook number 9 – Follow all the steps to complete the lab exercise

To begin Workshop 10 – Download and view the presentation – TNSQM Custom Reporting

Using BIRT

8/17/2019 SG_sec

138/158


Workshop 10

TNSQM Custom Reporting using BIRT

Workshop 10 – Custom Reporting Using BIRT

8/17/2019 SG_sec

139/158


Goal – install and configure BIRT and produce a custom report – Install BIRT Designer on student workstation

– Configure BIRT Designer for access to TNSQM server

– Create custom report

Approximate time – 45-60 minutes

Agenda

8/17/2019 SG_sec

140/158


Data Aggregation Overview

Data Retention Overview

TNSQM Oracle Tables

BIRT Installation

BIRT Report Generation

Why Data Aggregation?

8/17/2019 SG_sec

141/158


Performance management data is collected continuously – 24x7

Data is collected at fairly low granularity – typically every 5-15minutes

Data is typically collected from many devices

Data is typically collected from many elements within thesedevices – Device-specific – memory, CPU, buffers

– Interfaces – Virtual Interfaces – ATM PVCs, Frame Relay DLCIs

The volume of data collected every day can be considerable

Collection Example Assume 50 routers with 20 interfaces each

8/17/2019 SG_sec

142/158


Assume 50 routers with 20 interfaces each – 50 x 20 = 1000 interfaces

Assume data is collected for each interface once every 10 minutes – 1000 data samples every 10 minutes – 6000 data samples every hour (6 x 1000) – 144,000 data samples every day (24 x 6000) – 1,008,000 data samples every week (7 x 144,000) – 4,320,000 data samples every month (30 x 144,000) – 51,840,000 data samples every year (12 x 4,320,000)

Service Providers will typically have many hundred thousand interfaces – Assume 30 times the above example – 1,555,200,000 data samples per year

Over 1 BILLION data samples per year !!

Why care? Storage is cheap!!

8/17/2019 SG_sec

143/158


More data means more administration – Longer to backup – Longer to restore

More data means more database “overhead”

– More time required for inserts / deletes

More data means that reports run longer!

Something must be done to manage the volume of data

effectively

Data Aggregation

Data Retention

What is Data Aggregation?

8/17/2019 SG_sec

144/158


Technique for managing large volumes of data

Utilizes statistics to summarize data – MIN, MAX, AVG, SUM, COUNT

Statistical summaries reduce the volume of data

TNSQM maintains 5 levels of data granularity

– RAW – data as initially collected – HOUR – summarized data for each hour of each day – DAY – summarized data for 1 calendar day – WEEK – summarized data for 1 calendar week – MONTH – summarized data for 1 calendar month

How does it work? Assume 50 routers with 20 interfaces each

8/17/2019 SG_sec

145/158


– 50 x 20 = 1000 interfaces

Assume data is collected for each interface once every 10 minutes – 1000 data samples every 10 minutes – 6000 data samples every hour (6 x 1000) – 144,000 data samples every day (24 x 6000) – SAME !!

Compute summaries by HOUR – 144,000 RAW data samples => 24000 summary records per day (24 x 1000) – One record for each interface per hour with MIN, MAX, AVG, SUM, COUNT

Compute summaries by calendar DAY – 144,000 RAW data samples => 1000 summary records – One record for each interface per day with MIN, MAX, AVG, SUM, COUNT

Compute summaries by calendar WEEK – 1,008,000 data samples => 1000 summary records – One record for each interface per week with MIN, MAX, AVG, SUM, COUNT

Compute summaries by calendar MONTH – 4,320,000 data samples => 1000 summary records – One record for each interface per month with MIN, MAX, AVG, SUM, COUNT

With and Without Aggregation

8/17/2019 SG_sec

146/158


Data Granularity Without Aggregation With Aggregation

RAW (every 10 mins) 1,000 1,000

Hour 6,000 / hour 1,000 / hour

Day 144,000 / day 1,000 / day

Week 1,008,000 /week 1,000 / week

Month 4,320,000 / month 1,000 / month

Year 51,840,000 / year 12,000 (12 x 1000) /year

Data Retention

8/17/2019 SG_sec

147/158


Don’t need to keep data forever !

Save data at each “aggregation level”

– 62 calendar days of RAW level * – 62 calendar days of HOUR level * – 104 calendar weeks of DAY level * – 104 calendar weeks of WEEK level * – 36 calendar months of MONTH level *

Data that exceeds the calendar retention “AGES” out – deleted !

The volume of data is automatically managed to apredictable limit

* TNSQM default retention levels

Physical Implementation - Partitions

8/17/2019 SG_sec

148/158


Individual database partitions for each level of granularity and each“calendar” interval – RAW - day 1, day 2, day 3, … – HOUR – day 1, day 2, day 3, … – DAY - day 1, day 2, day 3, …

– WEEK – week 1, week 2, week 3, … – MONTH – month 1, month 2, month 3, …

Number of partitions at each level = retention level – 62 days of RAW = 62 partitions

AGE out of data – Drop oldest partition – Create new one to replace the one dropped

VERY Efficient

– Not necessary to “walk” all the data and issue individual deletes

TNSQM v4.x – Default Retentions KPI Data (individual tables per data source)

8/17/2019 SG_sec

149/158


( p )

– RAW – 62 days retained

KQI Data (common tables for all KQIs) – RAW – 62 days retained – HOUR – 62 days retained – DAY – 104 weeks retained

– WEEK – 104 weeks retained – MONTH – 36 months retained

Aggregation Schedule * – HOUR – updated every hour – DAY – once per day at midnight

– WEEK – every Monday at midnight – MONTH – the 1st of each month

Aging Schedule * – Old partitions dropped daily at 2:00 AM

* Implemented as Oracle Jobs

8/17/2019 SG_sec

150/158

Oracle Jobs – Daily Aggregation

8/17/2019 SG_sec

151/158


KQI_ADMIN_PKG.HST_KQIV_DAILYSUMMARY – Runs every day at 00:00 – Reads data from SA_HST_KQIVHOURAGG – Hourly Summaries – Selects records that are 3 days old, based upon the current day – Summarizes hourly KQI summaries into daily summaries

• COUNT

• SUM• MIN (minimum raw value)• MAX (maximum raw value)• AVG (average of the hourly average – NOT weighted)• STDDEV - NONE

– Inserts new records into SA_HST_KQIVDAYAGG – Newest data in this table is 3 DAYS OLD (by default)• If it runs on 2/7, it summarizes data for 2/4• /appl/sa/admin/oracle/schema/core/sqm/packages• kqi_admin_pkg_pkb.sql

Oracle Jobs – Weekly Aggregation

8/17/2019 SG_sec

152/158


KQI_ADMIN_PKG.HST_KQIV_WEEKLYSUMMARY – Runs every Monday at 00:00 – Reads data from SA_HST_KQIVHOURAGG – Hourly Summaries – Selects records that are more than 7 days old, based upon the

current day – Summarizes daily KQI summaries into weekly summaries

• COUNT• SUM• MIN (minimum raw value)• MAX (maximum raw value)• AVG (average of the hourly average – NOT weighted)

• STDDEV - NONE – Inserts new records into SA_HST_KQIVWEEKAGG – Newest data in this table is more than 7 DAYS OLD (by default)

• If it runs on 2/23, it summarizes data for 2/7-2/13• /appl/sa/admin/oracle/schema/core/sqm/packages• kqi_admin_pkg_pkb.sql

Oracle Jobs – Monthly Aggregation

8/17/2019 SG_sec

153/158


KQI_ADMIN_PKG.HST_KQIV_MONTHLYSUMMARY – Runs the 1st of each month at 00:00 – Reads data from SA_HST_KQIVHOURAGG – Hourly Summaries – Selects records for the month before the previous month – Summarizes hourly KQI summaries into monthly summaries

• COUNT

• SUM• MIN (minimum raw value)• MAX (maximum raw value)• AVG (average of the hourly average – NOT weighted)• STDDEV - NONE

– Inserts new records into SA_HST_KQIVMONTHAGG – Newest data in this table is 2 months OLD (by default)• If it runs on March 1st it summarizes data for January• /appl/sa/admin/oracle/schema/core/sqm/packages• kqi_admin_pkg_pkb.sql

Oracle Tables – KQI Data SA HST KQIVALUE

8/17/2019 SG_sec

154/158


SA_HST_KQIVALUE – Raw KQI values, at the same interval as processed by the adapter – Data is current as of the last adapter processing

SA_HST_KQIVHOURAGG – Hourly KQI summaries – Newest data is 24 hours old – Yesterday

SA_HST_KQIVDAYAGG – Daily KQI summaries – Newest data is 3 days old

SA_HST_KQIVWEEKAGG

– Weekly KQI summaries – Newest data is 7 days old – not the “past week”, but the week before that

SA_HST_KQIVMONTHAGG – Monthly KQI summaries – Newest data is 30 days old – not the “past month”, but the month before that

Oracle Tables – KPI Data Individual tables based upon Service Solution Data Source(s)

8/17/2019 SG_sec

155/158


– IP VPN v3.2, e.g.• KPI_VPN_IPVPN_PM

– VoIP v1.3, e.g.• KPI_VOIP_CDR_PSTN_GW

• KPI_VOIP_CDR_BAD_DATA• KPI_VOIP_CDR_SBC• KPI_VOIP_CDR_SIPPROXY• KPI_VOIP_PM_MEDIASERVER• KPI_VOIP_PM_SBC

• KPI_VOIP_PM_APPSERVER• KPI_VOIP_PM_BAD_DATA• KPI_VOIP_PM_PSTN_GW• KPI_VOIP_PRB_PROBE

Data retained at raw level – default 62 days

NO aggregation performed

BIRT Overview

8/17/2019 SG_sec

156/158


Business Intelligence Reporting Tool – BIRT

Available for free from Eclipse – http://www.eclipse.org/birt/phoenix/

General-purpose Reporting Tool

Report Creation Overview

http://www.eclipse.org/birt/phoenix/http://www.eclipse.org/birt/phoenix/

8/17/2019 SG_sec

157/158


Install BIRT on laptop / workstation

Install Oracle JDBC drivers

Report Creation – Define project – Create a datasource

• Connection to specific Oracle database (host, port, user, password) – Create a dataset

• Connection to Oracle table and/or view• Select statement to define filter criteria and desired columns

– Report format• Column contents, headings, output formats

Generate report


8/17/2019 SG_sec

158/158

To begin the hands-on exercises – Download lab workbook number 10 – Follow all the steps to complete the lab exercise

sg_sec

Documents