Platform Hosting - Database - DB2 (LUW)
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-temperature storage
Lower storage cost, efficient storage manage and consistent database performance
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
- Maintainance 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
- Maintainance 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 |
.
- Disaster Recovery
- Consulting Services
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.
| Role | Responsibility |
|---|---|
| Provide contract and licensing for DBMS software | Customer |
| Define database availability requirements | Customer |
| Document database design and application architecture | Customer |
| Submit services request(s) to purchase DBMS licenses or renew maintenance | Customer |
| System-level administration | CDT |
| Manage contract and licensing for DBMS software | CDT |
| Perform on and off-line scheduled database backups | CDT |
| Assist customers upon request to restore a database | CDT |
| Monitor free disk space and alert Customer when disk space is below threshold levels | CDT |
| Maintain data and log file backups | CDT |
| Assist in resolution of database application-level problems | CDT |
| Create database user account(s) within PostgreSQL and grant privileges | CDT |
| Monitor and modify DBMS software | CDT |
| Maintain database dictionaries | Customer |
| Respond to threshold limit notifications provided by CDT staff with mitigating action | Customer |
| Maintain application and database statistics | Customer |
| Test new maintenance and software releases at user and application levels | Customer |
| Review and recommend optional configurations that may better meet capacity and performance requirements | CDT |
| Perform DBMS version migrations, upgrades, and patches | CDT |
| Create and maintain database objects | Customer |
| Provide database user account and desired privileges | Customer |
| Load database data via assistance from CDT | Customer |
| Application design, development, testing and migration adhering to supported software versions | Customer |
| Code modifications | Customer |
| Application design and maintenance adhering to supported software versions | Customer |
| Maintain application development tools | Customer |
| Ongoing monitoring of database growth in relation to disk space | Customer |
| Perform data archival | Customer |
| Identity database application related problems or database system problems and report them | Customer |
| Determine when a restore is needed | Customer |
| Data cleansing | Customer |
| Additional charges for CDT intervention, troubleshooting and correction of unauthorized changes | Customer |
| Maintain database administration tools and utilities | CDT |
| Maintain DBMS software/configurations | CDT |
| Resolve database system problems or seek vendor support for DBMS issues through authorized escalation processes | CDT |
| Service Code | Service Description | Unit of Measurement | Rate | Notes |
|---|---|---|---|---|
| D101-Pass | CDT Processing Fee on Pass-through Products | % of Direct Pass-Through Costs - Per Purchase Order | Pass-through + 2.71% CDT Processing Fee | |
| M627 | DB2 Database Support | DB Instance | $975.00 | |
| M631 | Enterprise Linux - DB2 Database Support | DB Instance | $975.00 | |
| M632 | Enterprise Linux - DB2 Database Instance Installation | One-Time/Instance | $690.00 | |
| M635 | DB2 Database Instance Set-up Fee for Database Support - Tier 2 | One-Time/Instance | $690.00 |
Subscriptions to this service are available. Rates may also be referenced in the CDT Rate Schedule.
To submit a service request for a new database or database environment, please go to the Enterprise Services Delivery Process page.
To request a change to a current database, or to decommission, go to: Request a Change to a Current DB2-LUW Database or Decommission Now