70 -- MAINTENANCE ON DB2 UTILITY SOFTWARE

Notice Date

June 27, 2001

Contracting Office

Department of the Treasury, Bureau of the Public Debt (BPD), Division of Procurement, UNB 4th Floor 200 Third Street, Parkersburg, WV, 26101-5312

ZIP Code

26101-5312

Solicitation Number

Reference-Number-cbd527

Response Due

July 12, 2001

Point of Contact

Wayne Jeffers, Contracting Officer, Phone (304) 480-7141, Fax (304) 480-7203, Email procurement@bpd.treas.gov -- Orlando Yaconis, Contracting Officer, Phone (304) 480-7137, Fax (304) 480-7203, Email procurement@bpd.treas.gov

Description

Subject to final approval, the Bureau of the Public Debt intends to award a contract on a sole-source basis to BMC Software, Inc., of Sugarland, 6901 Rockledge Drive, Bethesda, MD 20817, for license upgrades and maintenance for a base year and nine option years, for currently-licensed DB2 utility software tools and a new DB2 utility software tool: All software products shall meet the following mandatory functional requirements: shall operate on an IBM 9672 Model R45, or compatible mainframe system with OS/390, VTAM, JES2, CICS, DB2, and CA-ACF2; shall provide access through panels under Interactive Systems Productivity Facility (ISPF); shall allow restriction of abilities via CA-ACF2; utilities shall be compatible and work in conjunction with each other and IBM's OS/390 system utilities; i.e., dynamic allocations and database recovery control (DBRC); shall be menu-driven and provide online help functions; shall provide 24-hour support, seven days per week; shall be seamlessly integrated (within an environment) so as to allow data to be shared between all applications; shall have the capability to support Parallel Sysplex by early calendar year 2002; shall be compatible with IBM's DB2 utilities; shall be able to use backup datasets that were created using BMC's DB2 products; shall support DB2 V6 or higher. (Note: Public Debt has scheduled DB2 Version 7 for the production environment by December 2001.); and shall function at an average rate that is equal to, or faster than, the currently employed BMC DB2 utilities. Currently-licensed software tools and their specific mandatory requirements are as follows: The COPY PLUS utility for DB2 shall have the capability to: make multiple copies with one pass of the data; support the remote copies function of DB2; provide incremental image copies (only image pages that were modified since the last image); update the DB2 catalog with recovery information; and allow for parallel images on a partition table space. The REORG PLUS utility shall have the capability to: reorganize multiple partitions; reorganize indexes as well as table spaces; provide restart capability; rebuild associated indexes; analyze resources for specific reorganizations; and provide data for tuning reorganization performance. The database administrator tools (ALTER, CATALOG MANAGER, and DASD MANAGER) shall have the capability to: query the DB2 Catalog; audit the activities performed against the DB2 Catalog; perform DDL functions (i.e., create, drop, grant, revoke, alter, and to recover dropped objects); execute DB2 Commands and DB2 Utilities; change, copy, and migrate DB2 data structures; produce a work list of required tasks to perform the DB2 structure changes; execute commands to produce changes; ensure proper security is maintained on the changes; produce statistical reports; provide performance reports; provide space and volume estimates; and provide tuning information. The LOADPLUS FOR DB2 utility shall have the capability to: perform highspeed data loads of multiple input format data sets; provide for discard processing, and statistic reporting; and allow for multiple key indexes and for partitioned tablespace loading. The RECOVER PLUS FOR DB2 utility shall have the capability to: perform highspeed DB2 Tablespace recovery; support tablespaces greater than 2.2 gigabytes; support 32K page size; support forward recovery at the volume or dataset level; and rebuild and index using an outspace option (building it in other datasets rather than using the main dataset). The RESOLVE LOG MASTER utility shall have the capability to: audit the log; allow users to backout incorrect updates; identify problems with data integrity when backout processing will affect updates performed later; provide quick easy access for viewing reports, SQL data sets, load files and logical log files; allow on-going migration without having to impact application availability; migrate data changes; ?quiet? points in the log; generate LOAD format output files; allow the user to control whether or not updates resulting from referential integrity are included in the output SQL; provide extensive filtering options; allow the users to determine the columns to be included in the output SQL; and provide statistical reports. The CHECK PLUS utility shall have the capability to: verify data online; shall allow DBA?s to check system-defined and user-defined referential structures; process at a minimum, up to four (4) times faster than IBM?s DB2 check utility and use significantly less CPU space; verify the physical structure of table spaces and index pages; provide comprehensive capability to monitor and control consistency of DB2 databases; and increase data availability. The UNLOAD PLUS utility shall have the capability to: move and/or copy data from a DB2 table to a different subsystem, to a sequential file for external processing, or to another relational database system or platform; allow the user to extract a subset of rows from a table; allow the user to unload a DB2 table for DB2 object definition changes; run outside of DB2; unload the ?keys? part of the data for a desired index; and provide a comprehensive set of data type conversions to eliminate the need for special application code. The R+/RESOURCE MAXIMIZER utility shall have the capability to: recover a table space after it has been dropped; migrate data within the same DB2 subsystem or to a DB2 subsystem at a different site; create copies from prior copies and the DB2 log; allow the user to evaluate the data on an image copy data set; and interface with BMC?s Recover Plus software functionalities. The R+/CHANGE ACCUM utility shall have the capability to: allow the user to create recovery resources that can be used with BMC?s Recover Plus; extract updates from the DB2 log for a designated group of objects and store the updates in a file; provide an alternative recovery resource to accessing specific sets of log records; and modify change accumulation groups and file attributes. The EXTENDED BUFFER MANAGER utility shall have the capability to: dynamically optimize online and batch DB2 performance; improve response time for DB2 end users and batch processing by utilizing high-speed caching technology; provide real-time monitoring; and minimize host resource consumption through Storage Systems integration. The RECOVERY MANAGER utility shall have the capability to: automate the disaster recovery process; increase recovery accuracy; reduce outages by optimizing job streams; provide control over full subsystem backup and recovery; provide exclusive recovery avoidance features; and support high-speed transaction recovery. The C+/MODIFY utility for DB2 shall have the capability to: allow for selective deleting of the syscopy information; allow synchronization of the ICF catalog and the syscopy tablespace for maintaining information on only those image copies that are available for recovery; ensure that all tablespaces are recoverable; and provide audit capability to determine the number of logs used since the last image copy and the number of days since processed. The MAINVIEW utility shall have the capability to: provide a single system image (or view) for monitoring a group of DB2 systems; summarize data from multiple systems in a single line; enable views to span multiple Parallel Sysplexes; provide the functionality to detect potential processing problems and issue warnings so that corrective actions can be taken before they affect productivity; provide a comprehensive set of system monitoring tools; and provide an audit log of exception messages. Specific mandatory functional requirements for the new DB2 utility software tool, OPERTUNE, are as follows: Shall have the capability to: ensure increased DB2 availability; reduce DB2 outages; dynamically modify over 100 DB2 subsystem parameters; increase performance of application programs; increase availability of subsystem data; increase data integrity; improve DB2 system performance; and prevents over-allocation and under-allocation of resources. No solicitation document is available. Public Debt will consider all affirmative responses received no later than July 12, 2001. Affirmative responses shall be accompanied by sufficient documentation to clearly show compliance with all mandatory requirements. Requests for more information or a copy of the solicitation will not be considered affirmative responses. If no affirmative response is received that clearly demonstrates ability to meet all requirements and that it is more advantageous to the Government, we will make a sole-source award to BMC Software, Inc., of Sugarland. =20

Web Link

Visit this URL for the latest information about this (http://www.eps.gov/spg/TREAS/BPD/DP/Reference-Number-cbd527/listing .html)

Record

Loren Data Corp. 20010629/70SOL004.HTM (D-178 SN50Q2F3)