Software AG ADABAS Update

(1)

Becky Albin

Chief IT Architect

Software AG US

Software AG

(2)

Now Available…

(3)

Software AG Book on Application Modernization

Coming Soon!

• Complete book on modernization

• Experts sharing best practices

• Focusing on Adabas and Natural

• Walks you through all steps of a

successful modernization project

• Available Q3/2013

Application

Modernization

Unlock the Value of

(4)

(5)

• Database

Management

System

• Application

Development

• Application

Modernization

Transaction

PLATFORMS

• Business

Process Analysis

• Enterprise

Architecture

• Governance,

Risk and

Compliance

Management

Business Process

PLATFORMS

• In-Memory Data

Management

• In-Memory

Intelligent

Action

Big Data

PLATFORMS

• Integration

• Business

Process

Management

Integration

PLATFORMS

(6)

(7)

Adabas Natural running large-scale Applications

40.000+

Concurrent

End-users

18+ Billion

Transactions

per Day

Sub-second

Response

Times

4+ Million

Replications

per Day

50+ Mill

Lines of Code

20+ Million

Service Calls

Per Day

(8)

Challenges for Enterprise Applications

• End-user friendly and self-service

Web and Mobile frontends

• Simple integration with distributed systems

• Growing demand in big data processing

and data analytics

• Standardize development tools

and runtime platforms

• Deliver faster on changing business demands

_Unique

High-performance

Mission critical

(9)

Adabas and Natural and the 4 Digital Forces

Adabas and Natural as the

reliable and high-performance

transactional backbone

(10)

(11)

Adabas the fastest transactional database

More than

1 Million

calls/second

Triple performance

since 2006

(12)

Dynamic Data Integration with Adabas

Oracle, SQL Server, DB2,

SAP HANA, mySQL, Sybase, Teradata, …

JDBC

ODBC

SQL

Production

Mainframe,

UNIX, Linux,

Windows

Reporting DB

Disaster Recovery

Data Warehouse

Business Intelligence

RDBMS

webMethods

Middleware

Reporting, BI Clients, Dashboards

Non-Prodcution

Reporting DB

Other RDBMS and

non-relational DBMS

REST

SOAP

In-Memory

Java Applications

Web &

Mobile-scale

Applications

Event Replicator

for Adabas

Adabas SQL Gateway

(13)

Modernize Government

• Event Replicator for Adabas with EntireX

• Real-time propagation of transactional

data from ADABAS to RDBMS

• Offload data reporting processing

• Make Adabas data available to Web apps

• Adabas SQL Gateway

• Modernizing government technology

• Improve IT service delivery

• Making government more transparent

and accountable

• 120 agencies, 8 million residents,

300.000 employees, 230000 businesses

and 50 mill. visitors.

• 2 Billion Adabas calls per day

Largest city in the USA

Opportunity

Result

Replication

transactions per day

(14)

Adabas meets Big Data

Adabas Data

Other Existing Data

New Data Sources

Sensor, Social Media, Mobile, etc.

Manage

Risks & Frauds

Run Customer

Loyalty Analysis

Identify Sales

Opportunities

High-value

Business Data

(15)

Adabas meets Big Data - Hadoop

Adabas

Data Warehouse

RDBMS and

Non-relational

DBMS

Business Intelligence

Applications

Application

Developer

Business

Analyst

Data

Scientist

Java & SQL Access

Real-time Replication

Log Extraction

Adabas SQL Gateway and Event Replicator for Adabas

Cloud, Sensor Events, Social Media,

Mobile, Internet of Things

New Data Sources

Framework that supports the processing and analysis

of large data sets in a distributed computing environment

(16)

Adabas meets Big Data - Terracotta

Hadoop

Adabas

Application

Users

Java & SQL Integration

Real-time Replication

Log Extraction

Adabas SQL Gateway

Event Replicator for Adabas

Cloud, Sensor, Social Media,

_{Mobile, Internet of Things}

New Data Sources

Existing

Data Sources

RDBMS, etc.

Business

Analyst

Delivers real-time business insights from any "Big Data" source

to any type of device for immediate action

DB2

Application

Developer

(17)

Adabas Add-on Portfolio

Integration

Event Replicator for Adabas

Adabas SQL Gateway

Adabas SOA Gateway

Entire Net-work

Adabas Transaction Manager

Optimization

Adabas Cluster Services

Adabas Parallel Services

Adabas Caching Facility

Adabas Fastpath

Security

Data Masking for Adabas

Adabas SAF Gateway

Governance

Data Archiving for Adabas

Adabas Vista

Adabas Delta Save

Operation

Adabas Review

Optimize for Infrastructure

Adabas Online Services

Adabas Manager

(18)

What‘s new in Adabas

Mainframe

• Less database stops on DBA tasks

• Dynamic container handling – add and

remove on the fly

• Run check and file maintenance

utilities in parallel

• Dynamic parameters to adjust buffers

and queues

• Multi-target replication

Open Systems (LUW)

• New Adabas system fields to track

record and field updates

• Extend hold/lock logic

• Partial large object processing

• Up to 3000 fields per record

• Enhanced replication to Adabas,

RDBMS and JMS middleware

Data Security and Archiving

• Archiving rules supporting file dependencies

(19)

Future Direction of Adabas

• Performance

• Leverage new hardware

• Database nucleus optimization

• Monitoring and statistics

• High-availability

• Dynamic parameter and utilities

• Enhanced restart and recovery

• Big Data Integration

• Real-time analytics

• Large data volume mining

(20)

Software AG provides no commitment to deliver any

of the features described herein, and reserves the

right to change its product roadmap from time to

time in its sole discretion.

Remember – this is not written in stone –

EVERYTHING

_{presented here is subject to CHANGE.}

(21)

Adabas v8.3 – Sneak Peek

• 64-bit / Above the Bar

• NWORK1BUFFERS, NPLOGBUFFERS, ADACACHE, LFIOP – v8.2

• Replication Pool – LRPL=

new to v8.3

— Adabas Source and ‘Reptor’

• Adabas REVIEW

• Changes to duplicate APAS features

• ADASCR – Adabas Security

• > 191 Files per Password

(22)

Adabas v8.3 – Sneak Peek

• ADAFRM – Enhanced / Fast Format –

• All parameter validation is done before formatting begins

• Multiple datasets maybe formatted simultaneously

• In event of failure, rerun ADAFRM in its entirety

• ONLINCREASE: Increasing Existing Data Set While Nucleus Is Active

• ASSOFRM, DATAFRM,

• z/OS only

• VOLIOCOUNT: Number of Concurrent I/Os per Volume per Data Set

• Default = 4, Max = 256, Min = 1

(23)

Adabas v8.3 – Sneak Peek

• Dynamically Increase ASSO/DATA

• Adabas active, processing updates

• z/OS only

• Last dataset only

• New dataset

Steps:

• ADAFRM ONLINCREASE

(24)

Adabas v8.3 – Sneak Peek

• ADACHK – Adabas Check Utility

• Can replace ADAACK, ADADCK, ADAICK, ADAVAL and ADAPRI

• Adabas Database or File level – Active w/Updates

• If File level check

(25)

Adabas v8.3 – Sneak Peek

• ADADRU – Adabas Database Resource Usage utility

• Similar to ADAREP – but all about disk storage

• Asso/Data

• DB or File(s

)

— Spanned Records

— Padding Factors

— Reorders

— Records per Block

— Free Space/Blocks

— Block Space

— Average Record Length

— Average Record Counts

— Sampling

(26)

Adabas v8.3 – Sneak Peek

• Security User-id (SECUID) – RACF/ACF/TSS User-id used in CQ

• z/OS and z/VSE

• Does NOT require ADASAF

• No external security permission checked

• SECUID support

• System Fields

• CLOGs & PLOGs

• Link Globals Table (CICS)

• New ADARUN parameter SECUID=ALLOW/REQUIRE/WARN

(27)

Adabas v8.3 – Sneak Peek

• Security User-id (SECUID) – RACF/ACF/TSS User-id used in CQ

(continued)

• Adabas Nucleus and Utility support:

• ADACDC

• ADASEL

• ADAWRK

• PRILOG

• ADADBS

• ADABAS Session Stats

• Operator Command output

• DPARM

• DCQ

• DFILES

• DUQ

(28)

Adabas v8.3 – Sneak Peek

• Security User-id (SECUID) – RACF/ACF/TSS User-id used in CQ

(continued)

• New Operator Commands

• STOPSU

– Stop & Delete user w/specified ID

• BT, Delete UQE, No response code

• STOPSUR

- Stop user w/specified ID

(29)

Adabas v8.3 – Sneak Peek

• INDEXCROSSCHECK

• New ADARUN parameter INDEXCROSSCHECK=YES/NO

• Operator Command to Dynamically change: ADADBS INDEXCROSSCHECK=

• As DATA Record is retrieved extracts Descriptor Value and check Normal

Index structure

— If Values Not Equal, check for parallel update

(30)

Adabas v8.3 – Sneak Peek

• REFSTPRT – Refresh Statistics Print

• New ADARUN parameter REFSTPRT=YES/NO

• Operator Command to Dynamically change: ADADBS REFSTPRT=

• Used with REFRESH STATISTICS

— Prints current content of statistics/high-water marks

— Then performs Refresh

(31)

Adabas v8.3 – Sneak Peek

• LTZ – Time Zone Pool

• New ADARUN parameter LTZ=0,12288/2147483647/32768

• Approximately 1000 bytes per Time Zone

(32)

Adabas v8.3 – Sneak Peek

• ASSO and DATA Space Warnings

• New ADARUN parameters:

— ASSOSPACEWARN=0-100, 1-99

Default 0,5

— DATASPACEWARN=0,100, 1-99

Default 0,5

• Warns if Adabas database is running out of ‘space’

— Threshold and Increment

• ADARUN DATASPACEWARN=50,10,80,5,95,1

— Maximum of 3 pair

• Operator Command to Dynamically change:

(33)

Adabas v8.3 – Sneak Peek

• NISNHQ – Maximum Number of ISNs on Hold per User

• Adabas v8.2 max value is 65,535:

• Adabas v8.3 max value is 16,777,215

— Default is (NH/NU) x 2

• In case you didn’t know – ADARUN parm values can be made more ‘readable’

— ADARUN LBP=600000000 or LBP=600

M

(34)

Adabas v8.3 – Sneak Peek

• Event Replicator for Adabas - Mainframe

• ADADBS OPERCOM RPLCHECK

(35)

Adabas – LUW – Linux/Unix/Windows

• Similar new functions as Mainframe v8.3

• High-Availability

(36)

Event Replicator for Adabas - LUW

Replication

Administration

CDD for SQL & Replication

Replication to

-

Adabas

-

JMS

-

RDBMS

Targets

JMS

RDBMS

Event

Producer

Adaptors

SQL

Administration

(CDD Manager)

Adabas

Nucleus

Source

CONNX

Adabas Data

Server

Adabas

Utilities &

(ADABCK)

Adabas

Replication

Server

Adabas

Entire

Network

Event

Controller

&

Consumer

Adabas

SQL

Gateway

SQL Engine

Adabas

Nucleus

CONNX

Adabas Data

Server

Adabas

Utilities &

(ADABCK)

(37)

Adabas v8.3 – Sneak Peek

• Adabas Parallel Services (ASM)

• Multiple ‘Update’ Adabas nuclei in the

same LPAR

• ‘New’ ASM customer

— State of TX – Office of Attorney General

— New mainframe: z196-406

— More CPUs, fewer MSU/MIPs per

processor

— 700 volumes for ASSO/DATA

— ~ 10 Billion calls per month

ASSO

DATA

Operating system

Shared Database Disks

Global Buffer Pool

Update

Nuc

Update

Nuc

Update

Nuc

Update

Nuc

(38)

Data Masking – Current Status

-

General Availability end of 1

st

_{quarter 2012}

-

Production shops

-

Supported Source Databases:

Adabas

Oracle

DB2 (UDB and z/OS)

Microsoft SQL Server

MySQL

Sybase

Ingres

SQLAnywhere

Informix

Cache

VSAM

Flat Files

(39)

Data Masking for Adabas Architecture

Production

Masked

Production

Rules

Run-time Options

Copy

Production

Meta-data

Repository

Adabas Tools

to create

Adabas

SQL

Gateway

Data Server

Adabas

SQL

Gateway

SQL Engine

Adabas

Nucleus

Masking

Engine

Mapping

Tool

Production

Application

Test

Application

Adabas

Nucleus

(40)

Getting familiar with the SDM Environment

Define Rules - Main Functions

Select a Table

Select a Column

Select a Rule

Open an existing File

or

(41)

Data Archiving for Adabas

Employees

Vehicles

Miscellaneous

Database ID

File number

…

No

information

Database ID

File number

…

Sales-Book

NEW: Support of complex objects and related files

Natural Applications

Production

Database

Vaults/Files

X

Extractor

Recall

Vaults

Search

Monitor

Control

Extractor

Move/Copy

(42)