Platform Hosting - Database - Db2

z Systems Database has quickly evolved into the premier performer with Db2 providing unparalleled scalability, delivering extreme levels of access as well as hybrid solutions. Db2 scales beyond the conventional workload managed systems where it leads the industry for on-premises and on the cloud.

Off the shelf, Db2 unlocks so much potential it allows most applications to analyze data across platforms, languages, and data types whenever required.

CDT provides full stack Db2 support on the z Systems platform. In addition to classic deployment scenarios, CDT also provides advanced technologies, such as Advanced Server with enhanced security, replication, clustering, and load balancing, to meet Customer’s business requirements.

Massive Scalability

Adapt and grow your business without constant reinvestment

Flexible Deployment

Store, manage and analyze data wherever and whenever it is most useful, efficient, and economical

Availability

Continuously scale and change as Customer’s needs evolve

Integration

Liberate users to work across platforms, languages, and data types in the environment they choose

The following are included in the z Systems Db2 service:

  • Installation
  • Upgrade
  • Patching
  • Configuration
  • Backup
  • Restore
  • Migration
  • Maintenance
  • Monitoring
  • Performance tuning
  • Disaster recovery
  • IBM Db2 for z/OS – An enterprise database for mission-critical data that provides secure, seamless integration for analytics, mobility, and cloud. Our team provides the system level IT infrastructure for Db2, allowing the Customer to manage, leverage, and support the application data
  • IBM QMF for z/OS – Provides a zero-footprint, mobile-enabled, highly secure business analytics solution delivering modern analytics by using visual reports and dashboards, available across all current interfaces, including mobile devices, web browsers, workstations, and IBM TSO and IBM CICS® clients.
  • IBM Omegamon for z/OS – Provides real-time and historical performance management for IBM Z mainframe and key middleware subsystems. By leveraging OMEGAMON, you can reduce blind spots within complex hybrid cloud environments, avoid costly system outages, and arm operations and system experts with the ability to efficiently react and fix issues when they occur.
  • IBM Db2 Administration Tool for z/OS – Provides the Customer with the day-to-day tasks associated with managing Db2 environments efficiently and effectively by displaying and interpreting objects in the Db2 catalog, as well as executing dynamic SQL statements, performing table editing, and many more features.
  • IBM Db2 Automation Tool for z/OS – Automates regular backup creation, object recovery and other everyday tasks required to maintain data in Db2.
  • IBM Db2 Cloning Tool for z/OS – Automates the cloning process for Db2 subsystems by moving enterprise data across the IT landscape quickly. The tool allows Customers to clone entire Db2 systems or table spaces and indexes, using fast or slow copy replication methods.
  • IBM Db2 High-Performance Unload for z/OS – Provides a high-speed Db2 utility for unloading Db2 tables from either a table-space or from an image copy.
  • IBM Db2 Object Comparison Tool for z/OS – Compares two sets of Db2 objects called source and target objects and then generates the jobs that are required to apply any changes to the target.
  • IBM Db2 Table Editor for z/OS – Provides access to update and delete Db2 table data securely and easily.
  • IBM Db2 Query Monitor for z/OS – Provides current and historical views of query activity throughout Db2 subsystems giving the ability to efficiently customize and tune SQL workload and Db2 objects to validate the effectiveness of Db2 subsystems and improve overall performance.
  • IBM Db2 Recovery Expert – A backup and recovery solution that can protect mission-critical data by helping avoid accidental data loss or corruption via a fast, inexpensive method of recovery.
  • IBM Db2 Sort – Provides high-speed utility sort processing for data stored in Db2 databases.
  • IBM Db2 SQL Performance Analyzer for z/OS – Provides Db2 application programmers and database designers with resource usage information and costs associated with SQL queries without having to run them in Db2.
  • File Manager for Db2 – Provides flexible, user-friendly tools for enhanced file processing when working with Db2 tables.
  • BMC Log Master for Db2 – Enables access and use of the Db2 log for purposes beyond restart and recovery. With Log Master, easily retrieve information stored in Db2 log records to support data migration and audit tasks.
  • IBM Db2 Connect – Used to connect applications that run on Linux, UNIX, and Windows operating systems to IBM mainframe Db2 databases.
  • IBM QMF for Windows – Desktop application that provides an environment within business intelligence objects such as queries, reports, and dashboards.
  • JAVA Database Connectivity (JDBC) – A vendor-neutral dynamic SQL interface that provides data access to  applications through standardized Java methods. JDBC is similar to Db2 CLI without having to precompile or bind a JDBC program.
  • IBM Db2 Analytics Accelerator – A combined hardware and software solution that accelerates database queries  allowing for all users to take advantage of high-speed analysis of their enterprise data for real-time insight under the control and security of Db2.
  • IBM Db2 Loader – A tool that provides capabilities and options for loading data into Db2 and the accelerator.
  • IBM Data Virtualization Manager (DVM) – Allows for creating real-time, virtual views of enterprise data, both for mainframes and non-mainframes. Data remains securely in place, ready when needed, in the right format wherever it resides. DVM widely leverages API interfaces supporting SQL, JSON, SOAP, HTTP, and REST.
  • REST Services API / Db2 Feature – RESTful services fully integrates applications into the world of mobile applications. These services allow mobile, web, and cloud applications to securely access business-critical data in the Db2 subsystems backend.
  • Data Server Manager (DSM) – An integrated database management tool platform for Db2, allowing DBAs the capability to monitor performance, track configuration changes, administer databases, and proactively or reactively optimize the database environment in one integrated end-to-end tool.
  • IBM Tivoli Omegamon XE for Db2 Performance Expert on z/OS (OMPE) – A single tool to monitor, analyze and tune the performance of IBM Db2 for z/OS and IBM Db2 applications. It helps to detect performance problems so they can be isolated and resolved more quickly.

Software

  • BM Encryption Tool for Db2 – Data encryption tool for z/OS Db2 databases enabling Customers to protect sensitive and private data at the table level.
  • IBM Optim Move for z/OS – Manages enterprise data throughout every stage of the information lifecycle. Optim will assess, classify, subset, archive, store, and access enterprise application data. Move includes Optim Legacy where both are relational copy facilities that migrate relationally intact sets of data from multiple sources to corresponding destinations.
  • InfoSphere Data Replication (IIDR) – Provides a way to replicate and publish data to external applications by using the Q Replication and SQL Replication technologies.
  • Replication Center (part of IIDR) – Replication tool required to generate the DDL to register tables, and define and build registrations to perform replication of data between two environments.
  • IBM Db2 Data Studio – Provides an integrated, modular environment to enable database development and administration of IBM Db2® for Linux, UNIX, and Windows.
  • Db2 for z/OS Testbase by Softbase – An integrated toolset for Db2 application development and analysis. Provides a revolutionary new patented technology for test data management called Slice, which enables all Application Developers and QA personnel in a shop to test together within one set of Db2 objects without impacting each other’s results.
  • RAI Tools – Smart / RRSAF – Allows Db2 batch programs to run with regular JCL, so they look and behave like standard OS jobs. Smart/RRSAF enables applications to update Db2, MQ, IMS and/or any other RRS compliant resources within a single unit of recovery.
  • RAI Tools – Smart / Restart – Provides batch applications with robust and symmetric COMMIT and ROLLBACK services whose scope encompasses changes to all resources a batch application may access. In its role as a resource manager and syncpoint coordinator, Smart/RESTART guarantees that updates to RRS compliant resources (such as Db2 and WebSphere MQ) stay ‘in sync’ with the application’s sequential file and cursor position, program storage, and random VSAM updates.
  • RAI Tools – Thread/SENTRY – Provides automated monitoring and policy enforcement for Db2 threads. Thread/SENTRY makes it unnecessary to manually identify Db2 problem threads or to explicitly cancel them. Simply define what constitutes a ‘problem thread’ in terms of threshold measurements such as elapsed time, CPU time, the number of SQL statements executed, the number of locks held, etc. Thread/SENTRY detects such problem threads automatically based on pre-defined criteria.
  • RAI Tools – Thread Stopper – Lets authorized users cancel such threads gracefully — before they impact your system and disrupt large numbers of users. It can also clear the way for critical applications and utilities to run without contention.
Task/RoleResponsibility
Review and approval of submitted information prior to beginning workCDT
Notify Customer of submittal flaws, if anyCDT
Installation, upgrades, patches, fixes, and standard configurationCDT
Assist Customer in specifying design in accordance with information providedCDT
Assist Customer with incident resolution subsequent to application configuration changesCDT
Design, develop, deploy, and test the database, and maintain its interaction with other application(s)Customer
Submit complete information for requestsCustomer
System-level administrationCD
Manage contract and licensing for softwareCDT
Perform scheduled database backupsCDT
Restore customer database objectsCustomer
Maintain system catalog and directory database backupsCDT
Assist in resolution of database application-level problemsShared
Grant DBA user permissions for access to databasesShared
Monitor and modify DBMS softwareCDT
Review and recommend optional configurations that may better meet capacity and performance requirementsCDT
Perform DBMS version migrations and upgradesCDT
Maintain database administration toolsCDT
Maintain software and configurationsCDT
Resolve database system problems or seek vendor support for issues through the authorized escalation processesCDT
Define database availability requirementsCustomer
Document database design and application architectureCustomer
Respond to threshold limit notifications provided by CDT staff with mitigating actionCustomer
Maintain application and database statisticsCustomer
Test new maintenance and software releases at user and application levelsCustomer
Approve additional charges for CDT intervention, troubleshooting, and correction of unauthorized changesCustomer
Create and maintain user database objectsCustomer
Load database data via access provided by CDTCustomer
Application design, development, testing, and migration adhering to supported software versionsCustomer
Code modificationsCustomer
Application design and maintenance adhering to supported software versionsCustomer
Maintain current application and database statistics by running utilitiesCustomer
Maintain application development tools running on attached client(s)Customer
Ongoing monitoring of database growth in relation to disk spaceCustomer
Perform data archivalCustomer
Perform file level maintenance of production dataCustomer
Identity database application related problems or database system problems and report themCustomer
Data cleansing including packages, plans, and database objectsCustomer

IBM Db2 System Administration (SYSADMIN) authority is restricted to CDT designated personnel.

The Customer Database Administrator (DBADM) authority is performed by the account level Database Administrators (DBAs). The DBAs will have access to database objects and utilities to manage all of the Customer’s files that compose the database within Db2.

All Customer database files will be secured by RACF profiles to protect the individual files on a database. The Customer is required to define the RACF access requirements and keep the documentation up to date.

The DBADM will also have access to other objects in Db2 such as tables, packages, plans, stored procedures, etc. Both SYSADMINs and DBADMs will work together to ensure security is maintained for all objects within Db2.

Configuration changes made outside the scope of the service request which require intervention, correction, or troubleshooting by CDT staff may incur additional charges.

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.

Service CodeService DescriptionUnit of MeasurementRateNotes
C101CPU Batch ProcessingHour$499.00
C102CPU Time Sharing Option (TSO)Hour$499.00
C103CPU Started Task (STC)Hour$499.00
C104CPU Open Edition/Multiple Virtual System - Unix System Services (OE/MVS)Hour$499.00
C105CPU Customer Information Control System Transaction Server (CICS)Hour$499.00
C108CPU DB2Hour$499.00

Subscriptions to this service are available. Rates may also be referenced in the CDT Rate Schedule.

To request services or support from the z Systems Db2 Support Unit, submit a service request and choose the Db2 for Mainframe from the drop-down list. Complete all fields prior to submitting the request.  Request Mainframe Db2 Support Now