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-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:
| Rancho Cordova | |||
| 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.
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 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.
| 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 service request submitted 10 days prior to the requested date and may incur additional charges.
| Service Code | Service Description | Unit of Measurement | Rate | Notes |
|---|---|---|---|---|
| C106 | z/OS CPU Adaptable DAta BAse System (ADABAS) | Hour | $495.00 | |
| S103 | ADABAS Disk Storage | GB/Month | $2.95 |
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 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 Request Access to AOS |