On this page
Description
IBM DB2 is supported across the Linux, Unix, and Windows (LUW) operating systems, fluidly adapting to changing needs while integrating with multiple platforms, languages, and workloads. DB2 is able to adapt and grow without constant reinvestment.
Adaptive compression
Savings in storage, no more reorgs to compress tables, improve buffer pool usage, reduce I/O request to read the same amount of data and deliver better performance
Continuous data ingest
Load large data sets using CDI without sacrificing performance, concurrency and/or recoverability
Multi-tier storage
Lower storage cost, efficient storage manage and consistent database performance
Included
The following are included in the DB2 LUW service:
- Installation, upgrades, patches, fixes, and standard configuration of the database software
- Incident resolution associated with application configuration changes
- Contract management and licensing for DB2 software
- Assistance with requests for database restores
- Monitoring of free disk space
- Alert when disk space is below threshold levels determined by the customer
- Maintenance of the database and log backups
- Monitoring and modifications of the DB2 software
- Review and recommendations of optional configurations that may enhance capacity and performance requirements
- Maintenance software/configurations
- Resolution of database system problems or facilitation of vendor support for issues through authorized escalation processes
| DB2 | DB2 Version 11 | DB2 Version 10 | Hosting Advantages |
|---|---|---|---|
| DB2 Advanced Enterprise Server Edition DB2 Enterprise Server Edition DB2 Advanced Workgroup Server Edition DB2 Workgroup Server Edition DB2 Direct Advanced Edition DB2 Direct Standard Edition DB2 Developer Community Edition DB2 Express-C Edition | DB2 v11.1 for Linux Unix, Windows, and DB2 Connect | DB2 v10.5 for Linux Unix, Windows, and DB2 Connect | Installation Patching Upgrades Migrations Monitoring Backups Restores File Maintenance Performance Management |
Database Backup Schedule
| What | When |
|---|---|
| Full Backup | Weekly |
| Incremental backup | Daily |
| Archive log backup | Multiple times every day |
| Backup retention | 28 days |
Availability
The core business hours for DB2 technical support are Monday through Friday from 0700 – 1700. State holidays and mandated schedule alterations are observed and may impact staff availability. After hours, on-call technical support may be requested through a service request submitted 10 days prior to the requested date and may incur additional charges.
Optional
- Disaster Recovery
- Consulting Services
Roles & Responsibilities
| Role | CDT | Customer |
|---|---|---|
| Provide contract and licensing for DBMS software | X | |
| Define database availability requirements | X | |
| Document database design and application architecture | X | |
| Submit services request(s) to purchase DBMS licenses or renew maintenance | X | |
| System-level administration | X | |
| Manage contract and licensing for DBMS software | X | |
| Perform on and off-line scheduled database backups | X | |
| Assist customers upon request to restore a database | X | |
| Monitor free disk space and alert the customer when disk space is below threshold levels | X | |
| Maintain data and log file backups | X | |
| Assist in resolution of database application-level problems | X | |
| Create database user account(s) within PostgreSQL and grant privileges | X | |
| Monitor and modify DBMS software | X | |
| Maintain database dictionaries | X | |
| Respond to threshold limit notifications provided by CDT staff with mitigating action | X | |
| Maintain application and database statistics | X | |
| Test new maintenance and software releases at user and application levels | X | |
| Review and recommend optional configurations that may better meet capacity and performance requirements | X | |
| Perform DBMS version migrations, upgrades, and patches | X | |
| Create and maintain database objects | X | |
| Provide database user account and desired privileges | X | |
| Load database data via assistance from CDT | X | |
| Application design, development, testing and migration adhering to supported software versions | X | |
| Code modifications | X | |
| Application design and maintenance adhering to supported software versions | X | |
| Maintain application development tools | X | |
| Ongoing monitoring of database growth in relation to disk space | X | |
| Perform data archival | X | |
| Identity database application related problems or database system problems and report them | X | |
| Determine when a restore is needed | X | |
| Data cleansing | X | |
| Additional charges for CDT intervention, troubleshooting and correction of unauthorized changes | X | |
| Maintain database administration tools and utilities | X | |
| Maintain DBMS software/configurations | X | |
| Resolve database system problems or seek vendor support for DBMS issues through authorized escalation processes | X |
Rates
The rate schedule represents standard CDT services. If a customer requires technology solutions that are not part of the standard, CDT will review the customer’s request and provide customized pricing as necessary.
| Service Description | Service Identifier | Product Name | Unit of Measurement | Rate | Service Code | Notes |
|---|---|---|---|---|---|---|
| CDT Processing Fee on Pass-through Products | Pass-through Fee | Dedicated Expenses | % of Direct Pass-Through Costs - Per Purchase Order | Pass-through + 2.79% CDT Processing Fee | D101 - Pass-Through | Plus the CDT Processing Fee of 2.79% |
| DB2 Database Support | Tier 2-Database Support | Database Support | Monthly/Per DB Instance | $1,680.00 | M627 | |
| Enterprise Linux - DB2 Database Support | Tier 2-Database Support | Database Support | Monthly/Per DB Instance | $1,024.00 | M631 | |
| Enterprise Linux - DB2 Database Instance Installation | Tier 2-Database Support | Database Support | One-Time/Per Instance | $725.00 | M632 | |
| DB2 Database Instance Set-up Fee for Database Support - Tier 2 | Tier 2-Database Support | Database Support | One-Time/Per Instance | $1,900.00 | M635 |
Subscriptions to this service are available.
Request service
| Service Request Name | Link |
|---|---|
| New Database or Database Environment Go to the Enterprise Services Delivery Process page for order information. | Enterprise Services Delivery Process |
| Change to a Current DB2-LUW Database or Decommission | Order a Change or Decommission of a Current DB2-LUW |