• No results found

Software AG ADABAS Update

N/A
N/A
Protected

Academic year: 2021

Share "Software AG ADABAS Update"

Copied!
42
0
0

Loading.... (view fulltext now)

Full text

(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

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

Archive

Database

Archive

Vaults/Files

X

Extractor

Recall

Archive

Vaults

Search

Monitor

Control

Extractor

Move/Copy

(42)

References

Related documents