Platform Hosting - Database - ADABAS

ADABAS is an enterprise database management system (DBMS) designed for reliability, high performance, scalability and low total cost of ownership. ADABAS delivers extremely high transaction levels— over 1 million commands per second—with a fraction of the staff and resources needed for a comparable relational database management system.

ADABAS provides powerful functionality, including support for any type of data structure, data access and replication features, to participate in data warehouse, business intelligence, and big data environments. It offers scalability to meet heavy and unpredictable transaction loads.

ADABAS is available as an add-on component to Customers that subscribe to z Systems platform.



Reliable Transactions

Meet growing demands in data processing, while achieving high availability under any workload.



High Performance

Meet increasing needs for speed and scalability, and satisfy Service Level Agreements with optimal efficiency.



Flexible Data Integration

Implement multiple data integration scenarios while supporting existing and new data architectures.



Low Administration Costs

Reduce total cost of ownership by delaying or eliminating hardware upgrades and program re-writes with high throughput and low system overhead (e.g., CPU, disk space use).

Benefits

Easy Administration – Simple administration and all-inclusive utilities reduce your costs by delivering the highest service level with a fraction of the staff and system resources needed for comparable database management systems.
Reliable – Well known for iron-clad reliability and failover protection.

Scalable – Handles any volume of data regardless of workload.
High Transaction Speed – Capable of processing 1+ million ADABAS commands per second.

Security – Secure both data at rest and data in motion, as well as mask your sensitive data.
Replication – Real-time replication of changed ADABAS data to ADABAS, RDBMS, and messaging.

CDT provides ADABAS administration on equipment within the z Systems Platform Hosting offering. This includes installation, patching, and product maintenance. Staff performs these tasks according to standard procedures and configurations. CDT manages the contract and licensing for DBMS software and serves as the liaison between the Customer and vendor for technical system-level DBMS issues. The below ADABAS components are included in the service offering:

ADABAS Caching Facility – Buffers ADABAS data and indexes in main memory, decreasing the number of physical reads and increasing database performance.
ADABAS Delta Save – Enables administrators to back up only changed blocks in a database from the time of the previous backup.
ADABAS Fastpath – Automatically stores frequently accessed records in a memory space to reduce CPU usage and optimize performance.
ADABAS Online System – Provides a mainframe-based interface to administer ADABAS.
ADABAS Review Performance Monitor – Monitors the performance of applications executing within ADABAS environments.
ADABAS SAF Security – Validates each end-user using RACF®, TOP Secret, or ACF2 security definitions before allowing access to ADABAS.
ADABAS SQL Gateway – Provides standard SQL interface to access ADABAS with SQL queries using standard JDBC® and ODBC interfaces.
Entire Net-Work – Message-based middleware that allows ADABAS databases to be accessed anywhere on the network.
EntireX – Bi-directionally service-enabled Natural applications by providing or calling services in Java®, .NET, Web services, and Software AG’s Digital Business Platform.
Event Replicator – for ADABAS on z Systems, replicates data changes from ADABAS in real-time to other ADABAS, RDBMS, business intelligence, or big data environments.

Backups

CDT performs database backups on the following schedule by campus:

Rancho Cordova

Profile	Backup	Frequency	Retention
Large Databases	Offline Full Delta Save	Saturday or Sunday	62 Days
	Offline Equivalent DSF	As Needed	62 Days
	Offline Incremental	Monday through Saturday	15 Days
	Offline Merge	Monday through Saturday	35 Days
Smaller Databases	ADASAV (ADAWKxx)	Saturday or Sunday	62 Days
	ADASAV (ADABKxx)	Monday through Saturday	35 Days
Protection Logs		Monday through Sunday	15 Days

Vacaville

Profile	Backup	Frequency	Retention
Daily	Offline Full	Daily/DB Down	25 Generations
Weekly	Offline Full (Copy of Daily)	Weekly	8 Generations
Monthly (Production)	Offline Full	Monthly	15 Generations
Protection Logs		Monday through Sunday	6 Days

The backup schedule is determined by the Customer.

Security

ADABAS DBA administration authority is restricted to CDT designated personnel.

The Customer Database Administrator (DBA) account must be approved by the Customer’s management. The DBA’s will have access to ADABAS utilities and update access to the files that compose the database.

All Customer ADABAS databases will be secured with ADABAS SAF which relies on 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.

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

DBA Mentoring – The ADABAS unit is available to assist Customers in mentoring their DBA’s. This would be a billable service and requires a Case/Request.

Stand-by Services – The ADABAS unit is available for standby support at the Customers’ request. This would need to be requested in advance with a Case/Request. In some cases, stand-by services may be billable to the Customer.

Consulting Services – The ADABAS unit is available for training Customers’ staff on specific technical items.

Vendor Liaison Services – The ADABAS unit provides liaison communication with vendors to ask questions on behalf of Customers.

Role	Responsibility
Review and approval of submitted information prior to beginning work	CDT
Notify Customer of submittal flaws, if any	CDT
ADABAS installation, upgrades, patches, fixes, and standard configuration	CDT
Assist customer in specifying design in accordance with information provided	CDT
Assist customer with incident resolution subsequent to application configuration changes	CDT
Design, develop, deploy, test the database and maintain its interaction with application(s)	Customer
Submit complete information for requests	Customer
System-level administration	CDT
Manage contract and licensing for ADABAS software	CDT
Perform 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 determined by customer	CDT
Maintain database and Plog backups	CDT
Assist in resolution of database application-level problems	Shared
Create database DBA user account(s) within ADABAS and assign permissions	CDT
Monitor and modify DBMS software	CDT
Review and recommend optional configurations that may better meet capacity and performance requirements	CDT
Perform DBMS version migrations and upgrades	CDT
Maintain database administration tools	CDT
Maintain software/configurations	CDT
Resolve database system problems or seek vendor support for issues through authorized escalation processes	CDT
Define database availability requirements	Customer
Document database design and application architecture	Customer
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
Additional charges for CDT intervention, troubleshooting and correction of unauthorized changes	Customer
Create and maintain database objects	Customer
Load database data via access provided by CDT	Customer
Application design, development, testing and migration adhering to supported software versions	Customer
Code modification	Customer
Application design and maintenance adhering to supported software versions	Customer
Maintain application and database statistics current by running utilities	Customer
Maintain application development tools running on attached client(s)	Customer
Ongoing monitoring of database growth in relation to disk space	Customer
Perform data archival	Customer
Perform file level maintenance of production data	Customer
Identity database application related problems or database system problems and report them	Customer
Data cleansing	Customer

The core business hours for ADABAS technical support are Monday through Friday, 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 Case/Request submitted 10 days prior to the requested date and may incur additional charges.

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
CPU Adaptable DAta BAse System (ADABAS)	Normalized to IBM CPU 2064-116	zSystem Processing	Per Hour	$495.00	C106
Disk Storage - ADABAS		zSystem Storage	Monthly/Per Gb	$2.95	S103

Subscriptions to this service are available.

To request one of the below ADABAS services, please submit a Case/Request and provide the required information in the Case/Request.

Request Title	Request Description	Request Link
Add new ADABAS database	This service request is used for creating a high-performance, scalable, ADAptable DataBASe. This request is also used a ADABAS MPM or ADABAS Event Replicator.	Request Add New ADABAS Database
Remove/Decommission an ADABAS database	Decommission an ADABAS databases. Please provide the name or DBID of the ADABAS region to be decommissioned.	Request Remove/Decommission an ADABAS Database
Expand/Increase the size of an ADABAS database	Additional space for your ADABAS database can be requested here. Please provide the name of the ADABAS region, as well as how much space you wish to add to the following: Data, Associator, Work, or PLOG.	Request Expand/Increase the Size of an ADABAS Database
ADABAS SQL Gateway or ConnX SQL Engine Add a new ADABAS SQL (ACE) database	Add a new CONNX SQL Gateway to open your data to new horizons. CONNX allows for data access, integration, virtualization, and replication and enables quick, secure, and scalable SQL access to ADABAS data wherever it resides, however it is structured, and without any change to your core systems.	Request Add a New ADABAS SQL (ACE) Database
ADABAS SQL Gateway or ConnX SQL Engine Remove an ADABAS SQL (ACE) database	Please provide the name of the ADABAS SQL database to be decommissioned.	Request Remove an ADABAS SQL (ACE) Database
EntireX Broker Add a new EntireX Broker	Set up a secure, robust, high-performance communication infrastructure with a new EntireX Broker! With an EntireX Broker you can create integration architecture to link mainframe assets into new or existing applications.	Request Add a New EntireX Broker
EntireX Broker Remove/Decommission an EntireX Broker	Decommission an EntireX Broker. Please provide the name of the EntireX Broker to be removed.	Request Remove/Decommission an EntireX Broker
ADABAS Online System (AOS) Request access to AOS	Unlock the potential of ADABAS with ADABAS Online System (AOS). With AOS you obtained unparalleled access to ADABAS statistics and analysis as well as control of your major ADABAS resources. Click here to request access now!	Request Access to AOS