search cancel

SQL Database Connections for Web Reporter

book

Article ID: 51455

calendar_today

Updated On:

Products

Activator eTrust ALERT eTrust ALERT for CICS ALERT Archiver ASM/ARCHIVE VSE-ESA OPTION ASM/Archive AutoAction AutoSys Job Management Adapter for AutoXfer Process Automation Manager Portal ARCserve Backup Client CICSORT Clipper COBOLVISION Analyzer CTO Distributed Dart Datesolver/2000 Distribulink EUREKA:Object EPIC VM Enterprise Endevor Change Manager for Unix Archiver Disk Option EPIC Backup EPIC Access Option EPIC SUPER SYS EPIC for CMS System EPIC TAPE MANAGEMENT eTrust Antivirus Gateway for CVP eTrust Content Inspection Gateway eTrust Content Inspection Gateway Option for MSP/ISA EE eTrust Antivirus Gateway for Netscape eTrust VPN Enterprise Edition FAQS VM FAQS Automated Systems Operation Global Subsystem (GSS) ANDYNE MAINFRAME MISCELLANEOUS Inventory Discovery Server ARS Resource Management JARS Resource Management ACC Option JOBDOC JOBWATCH Look MAZDAMON Service Management Affiliate Technology Partner Fee Service Management Basic Technology Partner Fee Metanet MF - MISC OLD CODES Omniguard for CICS Omniguard Opera Connect PREVAIL Paramount XP CAM FOR DIST SYS Paramount FOR NAVIGRAPH/HOST Research Planmacs Unlimited Project Planner Remote Console PREVAIL/XP-AUTOMATION PHASE 1 Remote Console PREVAIL/XP AUTOMATION-RDF/SSM Raps Research Raveler Generic Non Product SOLVE:EPS Unicenter NetMaster Network Management for SNA Alexandria Sort System SPOOLMAN Storage Mainframe SYSTEM/SCHEDULER SYSTEM/SCHEDULER VSE-ESA OPTION System/Manager Tape/Manager VSE-ESA OPTION Output Management Document Server TNG Network and Systems Management Agent for CA-Datacom DFSMShsm Workstation Network and Systems Management UNIX SMTP Unicenter Management for Microsoft Exchange SMTP Option UNICENTER II Unicenter Network and Systems Management Database Performance Monitor Option UNICENTER OSM Database Command Center Mnt VM:DBA VM:DB Admin VM:DB Center VM:DB Developer VM:DB Editor VM:DB Monitor VM:DB Reorganizer VM:DB Reporter VM:DB Restore VM:DB REXX VM:DB SQLMAP VM:DB Suite VM:Migrate VM:Monitor VM:Notekeeper V/Solver VM:Webserver for Officevision VM:Webserver Secure VM:Webgateway VM:Webserver XMENU for z/VM VISION:COMBO for TSO VISION:DAGER VISION:ELEVEN VISION:EIGHTY VISION:Online VISION:IQ for Informix Automate STORAGE RESOURCE MANAGEMENT SUITE

Issue/Introduction

Description:

CA SRM Web Reporter uses a certain number of SQL connections out of which some are fixed and rest are temporary connections.

Solution:

Web Reporter Server:

  1. Web Reporter Control Panel (WRCP): This component uses one SQL connection to the SQL Central database when it is up and running.

  2. Trend Service: This uses one fixed connection to SQL Central database on Web Reporter Server machine.

SRM Application Server:

Web Reporter Data Bridge (WRDB): Each managed object in SRM make one SQL connection during bulk/delta data upload to Central database and based on the number of managed objects in SRM server, this can reach a maximum of 40 concurrent connections.

Once the data upload is completed, all connections will be closed by the WRDB process.

Business Objects (BO):

BO Universe uses one connection to SQL Central database for InfoView and Central Management Console sessions when BO services are up and running.

Example:

If you plan to have 1 Web Reporter Server managing 3 SRM Application Servers, you would need 3 + 40x3 = 123 connections.

(WRCP -1, Trend Service -1, Business Objects -1, WRDB - 40 temporary)

Environment

Release:
Component: XSX