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 AdministrationSimple 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.
  • ReliableWell known for iron-clad reliability and failover protection.
  • Scalable Handles any volume of data regardless of workload.
  • High Transaction SpeedCapable of processing 1+ million ADABAS commands per second.
  • SecuritySecure both data at rest and data in motion, as well as mask your sensitive data.
  • ReplicationReal-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-enable 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:

Gold Camp
Profile Backup Frequency Retention
Large Databases Offline Full Delta Save Sat or Sun 62 days
Offline Equivalent DSF as needed 62 days
Online Incremental Mon – Sat 15 days
Offline Merge Mon – Sat 35 days
Smaller Databases ADASAV (ADAWKxx) Sat or Sun 62 days
ADASAV (ADABKxx) Mon-Sat 35 days
Protection Logs Mon-Sun 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 Mon-Sun 6 days

The backup schedule is determined by the Customer.

DBA Mentoring – The ADABAS unit is available to assist Customers in mentoring their DBA’s. This would be a billable service and requires a Service 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 service 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.

RoleResponsibility
Review and approval of submitted information prior to beginning workCDT
Notify Customer of submittal flaws, if anyCDT
ADABAS 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, test the database and maintain its interaction with application(s)Customer
Submit complete information for requestsCustomer
System-level administrationCDT
Manage contract and licensing for ADABAS softwareCDT
Perform off-line scheduled database backupsCDT
Assist customers upon request to restore a databaseCDT
Monitor free disk space and alert Customer when disk space is below threshold levels determined by customerCDT
Maintain database and Plog backupsCDT
Assist in resolution of database application-level problemsShared
Create database DBA user account(s) within ADABAS and assign permissionsCDT
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/configurationsCDT
Resolve database system problems or seek vendor support for issues through authorized escalation processesCDT
Define database availability requirementsCustomer
Document database design and application architectureCustomer
Maintain database dictionariesCustomer
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
Additional charges for CDT intervention, troubleshooting and correction of unauthorized changesCustomer
Create and maintain database objectsCustomer
Load database data via access provided by CDTCustomer
Application design, development, testing and migration adhering to supported software versionsCustomer
Code modificationCustomer
Application design and maintenance adhering to supported software versionsCustomer
Maintain application and database statistics current 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 cleansingCustomer

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.

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 service request submitted 10 days prior to the requested date and may incur additional charges.

Service CodeService DescriptionUnit of MeasurementRateNotes
C106CPU Adaptable DAta BAse System (ADABAS)Hour$499.00
S103Disk Storage - ADABASGB/Month$4.48

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

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

Request TitleRequest DescriptionRequest Link
Add new ADABAS databaseThis 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 Now
Remove/Decommission an ADABAS databaseDecommission an ADABAS databases. Please provide the name or DBID of the ADABAS region to be decommissioned.Request Remove/Decommission an ADABAS Database Now
Expand/Increase the size of an ADABAS databaseAdditional 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 Now
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 Now
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 Now
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 Now
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 Now
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 Request Access to AOS Now