SOURCES SOUGHT
70 -- Software Monitoring Product
- Notice Date
- 9/16/2003
- Notice Type
- Sources Sought
- Contracting Office
- Social Security Administration, Deputy Commissioner for Finance, Assessment and Management, Office of Acquisition and Grants, 1710 Gwynn Oak Avenue, Baltimore, MD, 21207-5279
- ZIP Code
- 21207-5279
- Solicitation Number
- Reference-Number-SSA-04-01
- Response Due
- 10/1/2003
- Archive Date
- 10/16/2003
- Point of Contact
- Tina Honey, Contract Specialist, Phone 410-965-9483, Fax 410-965-9560, - Linda Phipps, Contract Specialist, Phone (410) 965-9493, Fax (410) 965-9560,
- E-Mail Address
-
tina.honey@ssa.gov, Linda.Phipps@ssa.gov
- Description
- The Social Security Administration (SSA) is seeking sources capable of providing a software monitoring product, that would, on an ongoing basis, monitor performance, data collection, generate reports, etc. SSA utilizes DB2 UDB, provided by IBM, as a repository for the Content Manager data. The required software monitoring product will be installed on a minimum of one UNIX distributed platform system at the National Computer Center in Baltimore, Maryland. The monitoring software must meet the following requirements: Presentation of summarized diagnostic information for performance analysis on a single screen -Ability to graphically illustrate a real time status of buffer pools, event log, tablespaces, I/O, logging and sorting -Enterprise view of all instances and databases, with the ability to drill down to summarized and detailed levels - Ability to generate database reports including buffer pool locks, tablespaces and activity reports for I/O, logging and sorting -Provide system and application statistics in both real-time and historical displays -Historical data should be stored in a relational DBMS (i.e., Oracle, UDB, or MS SQL server) - Detailed data should be stored for both statistical and application, along with summary tables who?s summarization levels are customizable - Detailed data collected for CPU, Memory, Disk I/O, File System, Processes, Users, and correlate system and database data - Reports can be based on real-time data -Ability to place filter on reports (i.e., only show connections that encountered ?X? number of I/O waits) - Ability to summarize UDB statistical data for an instance or database by day, hour or 15 minute interval. Plus, the ability to summarize application data by connection, plan and or packages - Contain all attributes that are produced by the SNAPSHOT traces. If additional attributes are being collected specify how - Provide standard exception and trending reports - Provide standard DBA ratios for all tunable UDB parameters such as buffer pool hit ratio. The tool should not add excessive overhead - Specialized training should not be required to generate custom reports - Space management: Provide space calculator, report space used by tablespaces, tables and indexes -User definable thresholds, identify tables needing reorganization, tablespaces low on free space, contention between objects, and low cardinality Support both SMS and DMS tablespaces - Display top SQL statements, applications, users, transactions, connections - The display should be based on CPU, elapsed time, sort time and rows retrieved - Threshold and Alerts should be able to be set on all tunable parameters that can affect performance or availability - The alerts should also provide recommendations for resolutions - Must be able to monitor database for deadlocks and provide DBA with notification - Space issues, UDB Instance Level, Database Level, db2diag.log keywords, Latency of backups, tables needing reorganization, excessive CPU consumers, timeout threshold reached, device freespace threshold, when object statistics differ from catalog statistics by ?X? percent - Ability to email multiple recipients and maintain a log of alerts Ability to set different thresholds and message text - Ability to enable changes color and/or beep when an issue occurs - Explain SQL - Ability to produce SQL explain plans that allow the user to work with multiple concurrent scenarios for comparison - Ability to modify the database optimizer class, table and index statistics without having to make permanent changes to the database - Execute and compare SQL - Compare, based on CPU, elapsed time, sort time and rows retrieved - Ability to compare the performance of different versions of a SQL statement - Ability to report the number of automatic rebinds or recompiles attempted Ability to view/capture and produce statistics on SQL in buffer pool - Ability to sort SQL in buffer pool based on execution statistics for quickly identifying issues - Display top SQL statements, applications, users, transactions, connections - Display should be based on CPU, elapsed time, sort time and rows retrieved - Support Version 7.2 FixPack 10 - Support Version 8.1 FixPack 2 - Section 508 Compliant - Install server agents/software from a centralized server should eliminate the need to visit every server that is monitored in order to get the product functional during the upgrade process - Upgrade server agents/software from a centralized serve should eliminate the need to visit every server that is monitored in order to get the product functional during the upgrade process. Vendors having the capability to meet the above requirements are invited to submit complete details. Responses must clearly state the ability to meet these requirements. Vendors responding should indicate whether their services are available on the GSA schedule. Pricing data may be submitted. Respondents will not be notified of the results of the evaluation of the data received. No contract award will be made on the basis of responses received; however, this information will be used in SSA?s assessment of capable sources. Responses to this notice should be submitted in duplicate within 15 calendar days of this publication and should refer to Reference No. SSA-04-01. Requests for copies of a solicitation will not be honored or acknowledged.
- Place of Performance
- Address: Social Security Administration, 6401 Security Blvd., Baltimore, MD
- Zip Code: 21235
- Country: USA
- Zip Code: 21235
- Record
- SN00435862-W 20030918/030916213443 (fbodaily.com)
- Source
-
FedBizOpps.gov Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |