Adabas v7'4 Technical Update

1
Adabas v7.4 Technical Update

• Your cost efficient, high performance enterprise
  database

Becky Albin Database Architect
2
Agenda

• Roadmap/Release Schedule
• Supported Levels
• Whats relatively new in Adabas
• 64-bit Exploitation (v7.1.3)
• IBM Parallel Sysplex Exploitation (v7.2.2)
• Adabas v7.4 Conversion
• Adabas v7.4 New Features and Enhancements
• Adabas Parallel Services v7.4
• Installation
• How it works
• Adabas Cluster Services v7.4
• Installation
• How it works

3
2004
2005
Adabas 8 (Mainframe)
Adabas SQL Solution

• The next major version
• No limits on MU, PE fields, logical and physical
  extents
• Large Object support
• Spanned DS records
• Date/Time formats
• Many enhancements to the nucleus
• Integrated infrastructure for Adabas Manager
  options

• SQL solution provided by SAG partner CONNX
• Includes ODBC, JDBC drivers
• Access to Adabas on MF, Unix, Windows with VSE
  and BS2000 planned
• Pre-compilers in 2H 2004

Adabas Add-ons v 7.5

• Support of IBMs 64-bit virtual shared storage
  in
• Adabas Transaction Manager
• Adabas Parallel Services
• Adabas Cluster Services

Adabas 5 (Open Systems)

• The next major version
• No limits on logical and physical extents
• Long Alpha fields (16K)
• Subtransactions
• Date/Time formats
• Non-descriptor search capability

Adabas Replication Solution

• Replicate Adabas data in real-time to any target
• Product and services solution
• Availability in 2H 2004

4
Released in 2003

• Adabas 7.4 (mainframe)
• Including add-ons, particularly
• Adabas Parallel Services (new)
• Adabas 3.2 (Open Systems)
• Adabas 3.3 (Open Systems)

5
Adabas mainframe versions

• Adabas supported versions
• Adabas v7.1.3 Released 9/2001
• (last sm for Adabas v7.1) Drops support 5/2005
• Adabas v7.2.2 Released 1/2002 IBM Parallel
  Sysplex
• Add-ons v7.3.1 Released 12/2001 - for v71/v72
• Adabas v7.4.1 Released 12/2002
• Adabas v7.4.2 Released 7/2003
• Current/Upcoming releases
• Adabas v8.1.1 tbd/1st half 2005

6
The Context
Current
Version
Adabas 7.1
Adabas 7.1
Add
-
ons
7.3
Add
-
ons
7.3
Adabas 7.4
Adabas 8
Adabas 7.4
Adabas 8
For
Sysplex
users only
Adabas 7.2
Adabas 7.2
7
7
New since Adabas v71

• v7.1.3
• 64-bit Real Storage Exploitation
• OS/390 v2r10 ARCHLEVEL2 or z/OS 1.2 and above
• Max. 128 GB Real Storage
• 2 GB size limitation for allocation
• 64-bit Virtual Storage Exploitation
• z/OS 1.2 and above
• 2 GB size limitation removed
• data caches only
• other structures in later versions of z/OS

8
Adabas 64-bit Virtual Storage Support for High
Performance Caching
Main Memory
64-bit

• Adabas was first !Adabas was the first database
  to exploit IBMs 64-bit Virtual Storage
  architecture for mainframes
• Availability in parallel with IBMs introduction
  of the architecture
• High Performance!!!

Adabas Cache gt 2 GB
Virtual Storage
Adabas Buffer Pool max 2GB
32-bit
Adabas Cache max. 2GB
Adabas Server
Adabas Buffer Pool max. 2GB
9
Adabas Cluster Services v7.2.2

• Adabas specifically designed for IBMs Parallel
  Sysplex
• OS/390 or z/OS only
• Multiple Adabas nuclei updating/reading the same
  physical database
• Optimized performance features
• Automated peer level recovery
• Robustness
• Extensibility
• 24 x 7 availability
• Production sites
• Test sites in the U.S.
• More on this later

10
Adabas v7.4 Features and Enhancements
11
Adabas v7.4

• Released available for OS/390 and z/OS
• Re-merging of Adabas v7.1 and v7.2 code
• New SQL solution for desktop access to Adabas
• Adabas Parallel Services
• Cluster support of an Adabas DB on a single
  machine
• Multiple update nuclei
• Adabas Cluster Services
• Support for IBM Parallel Sysplex environment
• Coupling Facility used for 24 x 7 support
• Other new enhancements

12
Adabas v7.4

• Adabas Early Warning 1 AN742037
• Supported Operating Systems
• OS/390 version 2, releases 10
• z/OS version 1, releases 1-4
• z/VM version 4.2, 4.3 and 4.4
• VSE/ESA version 2, releases 5-7
• http//www.softwareag.com/corporat/prodstat/ibm/de
  fault.htm

13
Adabas v7.4.1

• SAG Product Level Compatibility
• Adabas v7.4 is downward compatible with Adabas
  v7.1
• Natural v3.1 or above
• Entire Net-Work v5.8.1 or above
• WM58028
• Entire Net-Work X-Hub v1.2.1 or above
• Adabas SQL Server v5.1
• Entire Adabas SQL (ESQ) v1.4 or above

14
Adabas v74 Conversion

• Conversion Adabas v7.1 to v7.4
• ADASAV - database backup
• ADAEND v7.1 database
• ADARES PLCOPY - copy PLOG datasets
• ADACNV CONVERT TOVERS74
• Input PLOG datasets to ADACNV
• ADASAV - database backup
• ADANUC - start v7.4 nucleus

15
Adabas v74 Conversion

• What happens during conversion to v7.4
• GCB
• XGCBSTATxC8
• XPPTA First PPT RABN
• XPPTE Last PPT RABN
• PPT (Parallel Participant Table) blocks allocated
• 32 contiguous ASSO blocks (ADACNV or ADADEF)
• Taken from FST and cleared
• Used by Adabas Parallel Services or Adabas
  Cluster Services
• One block per participating ASM/ALS nucleus
• Keeps track of WORK, PLOG and CLOG datasets
• Set DSF DLOG to v74 (if using Adabas Delta Save
  Facility)

16
Adabas v74 Conversion

• What happens during conversion to v7.4 (cont.)
• FCB
• New field in FCB added and reset
• YFSTAT1 x80 (YFSTQALO) set by AQA via CREATE
  TABLE and therefore can be deleted by AQA
• If needed, clears BUB (ASSO RABN 2) and MIRTAB
  (ASSO RABN 7)
• Possible to convert back to v7.1 with ADACNV
  REVERT
• Release PPT
• Reset XGCBSTATxC7
• Reset DLOG/DSF to v71

17
Adabas v7.4

• Single SVC for Adabas, Parallel Services and
  Cluster Services
• Hot standby
• via IBMs Automated Restart Manager (ARM)
• OS/390 and z/OS
• Automatically restarts failed servers
• ADARUN PROGRAMADANUC.ARMNAMEarm policy
• Policy defined by Systems programmer, controls
  when, where and how often to attempt automatic
  restart
• Adabas does not invoke ARM on intentional abend,
  like parameter error

18
Adabas v7.4

• DASD volume backup product(s) support
• Support the Snapshot / Flashcopy /
  TimeFinder/TDMF, feature while nucleus is
  active
• Does NOT replace ADASAV!!!
• ADADBS TRANSACTIONS SUSPEND (TTSYN)
• ET-sync point, SYNC-73 checkpoint
• Suspends Update commands
• Allows/processes Read commands
• and then. Run volume backup process of your
  choice
• ADADBS TRANSACTIONS RESUME
• SYNC-74 checkpoint
• Resumes Update processing
• Also available through AOS

19
How it works
Pre-defined time window
Suspend
Resume
Read only
Read / update
Read / update
snap
Physical Backup
Snapshot
Source Data
Read only update requests are queued in this
phase execution after Resume Suspend all open
transactions are finished and data are
transferred to the disk
20
Adabas v7.4

• Enhanced Backup and Restore Performance
• Exploits IBMs large block (gt32,760 bytes)
  support for sequential access methods BDAM and
  QSAM
• OS/390 v2 r10 and above
• ADAIOR supports tape drives with a blocksizes of
  up to
• 256k for 3590 devices
• 64k for 3490/3490E devices
• Provides performance benefits for any Adabas
  utility writing to tape, such as ADASAV
• If shipping tapes to off-site facilities, the
  off-site center must support these large blocks

21
Adabas v7.4

• Multifetch/Prefetch
• INCLUDE parameters
• PREFICMD and PREFIFIL
• Used in PAIRS like EXCLUDE (PREFXCMD/PREFXFIL)
• ADARUN PREFIFIL8,PREFICMDL3
• ADARUN PREFIFIL12,PREFICMDL3
• ADARUN PREFIFIL12,PREFICMDL9
• or
• ADARUN PREFIFIL8,12,12,PREFICMDL3/L3/L9
• If both INCLUDE and EXCLUDE parameters used,
  EXCLUDE is used

22
Adabas v7.4

• PLOG Changes
• 8 byte timestamps
• NUCID
• Up to 8 PLOGs/CLOGs
• ADARUN NPLOGn,PLOGDEVn,PLOGSIZEn
• ADARUN NCLOGn,CLOGDEVn,CLOGSIZEn
• UEX12name
• Or regular dual logging
• ADARUN DUALPLD3390,DUALPLSn
• ADARUN DUALCLD3390,DUALCLSn
• UEX2name
• ADARUN PLOGRQyes/no/sel/FORCE
• Requires UEX2 or UEX12 and PLOG datasets
• Also detects different PLOG datasets and the old
  PLOG datasets have not been copied

23
Adabas v7.4

• PLOG Changes (cont.)
• If all PLOGs are full, Adabas will suspend
  update commands, but continue processing
  access commands
• PLOG/CLOG datasets written and copied in
  numerical sequence
• ADASAV RESTORE/RESTONL no longer resets the
  PLOG/CLOG dataset headers

24
Adabas v7.4

• PLOG/CLOG Changes
• ADARES PLCOPY/CLCOPY
• regular nucleus specify log datasets in JCL
• cluster nucleus log datasets are taken from
  PPT
• Adabas Parallel Services
• Adabas Cluster Services

25
Adabas v7.4

• CLOG Changes
• CLOG write I/Os are now asynchronous
• Allocates two internal buffers during Adabas
  startup
• Each buffer capable of holding one cylinder of
  CLOG data
• Multi-block or cylinder writes are issued
• Up to 8 CLOGs (see previous slide)

26
Adabas v7.4

• Buffer Flush Enhancement
• ASYTVSyes/no
• FMXIO1/gt1) (can be changed via operator
  command/AOS)
• In Adabas v7.1 when specifying ASYTVSYES, the
  FMXIO setting was ignored. Causing one I/O to
  each volume in parallel.
• In Adabas v7.4 for better performance, ASYTVSYES
  and FMXIOgt1, multiple I/Os can be issued to each
  volume in parallel
• FMXIO1-16 if ASYTVSyes
• FMXIO1-100/60 if ASYTVSno

27
Adabas v7.4

• Other Enhancements
• Performance/Tuning note because of changes in
  PLOG processing and volume backup it may be
  necessary to increase setting for ADARUN NC

28
Adabas v7.4

• Other Enhancements (cont.)
• LP2,000,000,000
• WORK dataset can now have 4 byte RABNs
• LWP minimum value is lesser of (NT 25000) or
  80,000
• ADARUN NUCIDn
• regular Adabas nucleus 0
• clustered Adabas nucleus gt0 (more later)

29
Adabas v7.4

• Other Enhancements (cont.)
• Mixed Case messages
• ADARUN MSGCONSLupper/mixed
• ADARUN MSGDRUCKupper/mixed
• ADARUN MSGPRINTupper/mixed
• See FRZ.ADA742.MVSSRCE(ZAPOPT) (AY742001)
• AOS Release Descriptor and NEWFIELD
• In Parallel option

30
Adabas v7.4

• Other Enhancements (cont.)
• CSAs of Replaced SVCs Released
• ADASIP releases SVC code and ID Table
• CSAs released are identified in ADAS20 message
• Helps to reduce number/frequency of IPLs
• Keeps first 8 bytes eye catcher
• See Release Notes and Installation manual
• Link routine changes
• See Release Notes

31
Adabas v7.4

• Other Enhancements (cont.)
• AOS changes
• New console/operator messages during nucleus
  autorestart
• New generic message for internal error in nucleus
  w/abend

32
Adabas v7.4

• Other Changes
• BUB (Alternate RABNs) no longer supported
• ADAREF no longer supported
• ADASMP replaced by Adabas Parallel Services (ASM)
• ADAESI replaced by ADASAF

33
Adabas Parallel Services v7.4replacement of
ADASMP
34
What is Adabas Parallel Services?

• A mechanism which allows for executing an Adabas
  update nucleus on each processor of a
  multi-engine CPU under a single image.
• All nuclei share memory via a Global Buffer Pool
  and access the same physical database/files.
• Replacement for ADASMP

Operating system
Update
Update
Nuc
Nuc
Global Buffer Pool
Update
Update
Nuc
Nuc
Shared Database Disks
ASSO
DATA
DATA
35
Adabas Parallel ServicesToday and Tomorrow
36
Adabas Parallel Services Architecture
ADACSH ASSO, DATA And Work blocks
Lock Structures
Updated Block Buffer
User Locks
File Locks
UQ Desc
ISN Hold Queue
Update Nucleus
Update Nucleus
Update nucleus
WORK
WORK
Work
PLOG
PLOG
DATA
ASSO
PPT in Asso
37
Adabas Parallel Services Implementation

• APF authorized libraries
• ADASVC/SVCCLU
• Allocate/Format additional WORKs/PLOGs/CLOGs
• For each participating nucleus
• 1 WORK
• 2-8 PLOGs
• 2-8 CLOGs
• Ensure all datasets are allocated on SHARED dasd
• ADACOM
• Controls ASM environment and user information
• Must be started first, before any nucs
• Allocates Global areas
• Via 1st nucleus started ADARUN parameters

38
Adabas Parallel Services Implementation

• //ADACOM JOB
  
• //
  
• // ADACOM ADABAS PARALLEL SERVICES
  
• //
  
• //COM EXEC PGMADARUN,TIME1440
  
• //STEPLIB DD DISPSHR,DSNADABAS.VVRS.LOAD
  lt ADABAS LOAD
• //
  
• //DDDRUCK DD SYSOUTX
  
• //DDPRINT DD SYSOUTX
  
• //COMPRINT DD SYSOUTX
  
• //SYSUDUMP DD SYSOUTX
  
• //DDCARD DD
  
• ADARUN PROGADACOM
  
• //
  
• //DDKARTE DD
  
• ADACOM SVCxxx,DBIDyyyyy,NUzzzzz
  
• //

39
Adabas Parallel Services Implementation

• Start-up JCL for each cluster nucleus
• How many nuclei?
• New ADARUN parameters
• CLUSTERno/sysplex/local
• NUCID0-65000
• CLOGMRGno/yes
• CLUGROUPNAME
• CLUCACHESIZE
• LFIOP nucs directory elements
• CLULOCKSIZE
• Each element is 128 bytes
• (NU 2 NH LDEUQP/16 MAXFILES 4 50)
  240 500,000 bytes

40
Adabas Parallel Services Implementation

• User Exit 2/12
• ADARES PLCOPY/CLCOPY and MERGE
• Two intermediate datasets (input/output)
• USEREX2P or USEREX12P (sample jcl)

41
Adabas Parallel Services Implementation

• Adabas add-on product compatibility
• Adabas Online System
• Adabas Caching Facility
• Adabas Delta Save Facility
• Adabas FastPath
• Adabas Vista
• Adabas SAF Security

42
Adabas Parallel Services - Recovery

• Online Recovery
• ADACOM detects a failed nucleus
• Surviving nuclei quiesce
• finish all commands in threads and command queue
• reinitialize working storage
• compete for recovery lock and perform pending
  autorestart
• open transactions backed out
• sequential/search processes and results
  maintained
• Global cache area discarded
• response codes 9 and 148

43
Adabas Parallel Services - Recovery

• Crash Recovery
• Restore the database
• Use merged Protection Logs (ADARES)
• Backup process
• ADASAV ONLINE
• Merged PLOGs
• ADARES REGENERATE and BACKOUT
• After PLOG merge process, block numbers will not
  necessarily be the same
• To uniquely identify checkpoints, NUCID is added,
  and
• Records old block number prior to merge
• In ADARES specify the NUCID and block number as
  reported in ADAREP

44
Adabas Parallel Services Advantages

• V7.4 ASM SVC can run a v7.1 SMP environment
• Link v71 SMPSVC with the v74 ADASVC
• As well as non-ASM databases (both v74 and v71)
• Users distributed and balanced across multiple
  processors
• Increased throughput
• Better response times for all users
• No need to buy a new machine to improve
  performance
• Maximum scalability
• No changes to applications
• Close to 24 X 7 without having to implement IBMs
  Parallel Sysplex
• No More Skip-A-Turn loops

45
Adabas in an IBM Parallel Sysplex
EnvironmentAdabas Cluster Services v7.4
46
IBMs Parallel Sysplex Technology

• Up to 32 OS/390 boxes coupled together - runs as
  one MVS image
• Coupling Facility (cache, lock structures)
• Sysplex timer
• CICS, VTAM, WLMetc, etc.
• Benefits
• True 24 X 7 - Outage persistent (planned or
  unplanned)
• Data sharing across MVS images
• Great performance

47
Parallel Sysplex
Coupling Facility
OS/390
OS/390
OS/390
48
Adabas Parallel Sysplex Support

• Platform
• OS/390 Parallel Sysplex Environment
• Adabas Versions
• Adabas v7.4
• Adabas Cluster Services v7.4
• Natural v3.1 or above
• Entire Net-Work v5.8.1 or above

49
The Coupling Facility

• Cache Structure
• Data consistency and high speed
• Organization of shared data
• Lock Structure
• Resource Serialization

Cache Structure
Lock Structure
Coupling Facility
WLM
50
Adabas Cluster Services v7.4

• Adabas Cluster Services
• better performance
• more stability
• SPaTs
• Online INVERT supported
• Not Online REORDER
• System Managed Processes
• Auto-Rebuild
• Structured Duplexing

51
Features

• All nuclei (up to 32 per cluster) perform updates
• No single point of failure
• Contention handled globally
• Contention handled via XES services
• Multiple nuclei permitted per system
• one or more nuclei may be run locally
• no command re-routing required

52
Features

• Asynchronous process to merge PLOG/CLOG
• Single dataset to do regenerate
• Time sequence - 8 byte timestamp
• Single dataset for application/database logging
• Automatic process restart
• Interface with ARM (Automatic Restart Manager)

53
Adabas Cluster Services Implementation

• APF authorized libraries
• ADASVC/SVCCLU
• Allocate/Format additional WORKs/PLOGs/CLOGs
• For each participating nucleus
• 1 WORK
• 2-8 PLOGs
• 2-8 CLOGs
• ADACOM
• Controls ASM environment and user information
• Must be started first, before any nucs
• Allocates Global areas
• Via 1st nucleus started ADARUN parameters

54
Adabas Cluster Services Implementation

• //ADACOM JOB
  
• //
  
• // ADACOM ADABAS PARALLEL SERVICES
  
• //
  
• //COM EXEC PGMADARUN,TIME1440
  
• //STEPLIB DD DISPSHR,DSNADABAS.VVRS.LOAD
  lt ADABAS LOAD
• //
  
• //DDDRUCK DD SYSOUTX
  
• //DDPRINT DD SYSOUTX
  
• //COMPRINT DD SYSOUTX
  
• //SYSUDUMP DD SYSOUTX
  
• //DDCARD DD
  
• ADARUN PROGADACOM
  
• //
  
• //DDKARTE DD
  
• ADACOM SVCxxx,DBIDyyyyy,NUzzzzz
  
• //

55
Adabas Cluster Services Implementation

• Start-up JCL for each cluster nucleus
• How many nuclei?
• New ADARUN parameters
• CLUSTERno/sysplex/local
• NUCID0-65000
• CLOGMRGno/yes
• CLUGROUPNAME
• CLUCACHENMAE
• Size is specified in CF Policy
• CLULOCKNAME
• Size is specified in CF Policy
• LRDPlfiop
• DIRRATIO
• ELEMENTRATIO

56
Adabas Cluster Services Implementation

• User Exit 2/12
• ADARES PLCOPY/CLCOPY and MERGE
• Two intermediate datasets (input/output)
• USEREX2P or USEREX12P (sample jcl)

57
Multi Update Support
OS/390
OS/390
SVC
SVC
XCF
XCF
Coupling Facility
Update Nucleus A
Update Nucleus B
ADALNC
ADALNC

CICS A
CICS B
Users
Users
58
Adabas Cluster Services
Timer
OS/390
OS/390
Update
Update
Coupling Facility
Work
CLOG
Work
PLOG
PLOG
CLOG
CLOG
PLOG
Asso
Data
Read / Write
Read / Write
59
The Update Nucleus
OS/390
Local Buffer Pool
Read / Write
Update Nucleus
Vector
Buffer Pool Updated Blocks
User Locks
File Locks
ISN Hold Queue
Read
Write
Coupling Facility
ASSO
PLOG
DATA
60
Cluster Example
OS/390
OS/390
Plex SVC
Plex SVC
Command Manager
Nucleus
Command Manager
Nucleus
Coupling Facility
Nucleus
Nucleus
ADARES
OS/390
OS/390
Plex SVC
Plex SVC
Command Manager
Nucleus
Command Manager
61
Coupling Facility
Coupling Facility

• All updated ASSO andDATA Blocks placed in CF
• Castout by Buffer Flush
• Assignment of userscontrolled by locks
• Contention of record updates controlled by locks.
• Exclusive access/update offiles controlled by
  locks

Updated ASSO Blocks
Updated DATA Blocks
Record Locks
File Locks
User Locks
62
Log Merge Utility
OS/390
OS/390
Command Manager
Nucleus
Command Manager
Nucleus
Coupling Facility
CLOG
PLOG
CLOG
PLOG
ADARES
ASSO
Merged LOG DSNs
63
Adabas Cluster Services - Recovery

• Online Recovery
• XES detects failed Adabas nuc
• Surviving nuclei quiesce
• finish all commands in threads and command queue
• reinitialize working storage
• compete for recovery lock
• open transactions backed out
• sequential/search processes and results
  maintained
• coupling facility contents discarded
• response codes 9 and 148

64
Adabas Cluster Services - Recovery

• Crash Recovery
• Restore the database
• Use merged Protection Logs (ADARES)
• Backup process
• ADASAV ONLINE
• Merged PLOGs
• ADARES REGENERATE and BACKOUT
• After PLOG merge process, block numbers will not
  necessarily be the same
• To uniquely identify checkpoints, NUCID is added,
  and
• Records old block number prior to merge
• In ADARES specify the NUCID and block number as
  reported in ADAREP

65
Adabas Cluster Services - Benefits

• Adabas add-on products
• Adabas FastPath Adabas v7.4
• Dynamic Caching v7.4
• Adabas Online System v7.4
• Adabas SAF Security v7.4
• Adabas Delta Save Facility v7.4

66
Adabas Cluster Services (ALS - Adabas v7.4)
Sysplex Timer
OS/390
OS/390
Coupling Facility
Update Nucleus A
Update Nucleus B
Read / Write
Read / Write
ASSO
DATA

Shared DASD
PLOGs
PLOGs
WORK
WORK
PLOG merge
Asynchronous merge
67
Each Update Nucleus (ALS)
OS/390
Local Buffer Pool
Read / Write
Update Nucleus
Vector
Buffer Pool Updated Blocks
User Locks
File Locks
ISN Hold Queue
Read/ Write
Write
Coupling Facility
ASSO
PLOG
DATA
68
Cluster Example (ALS)
OS/390
OS/390
Plex SVC
Plex SVC
Command Manager
Nucleus
Command Manager
Nucleus
Coupling Facility
Nucleus
Nucleus
ADARES
OS/390
OS/390
Plex SVC
Plex SVC
Command Manager
Nucleus
Command Manager
69
Log Merge Utility (ALS)
OS/390
OS/390
Command Manager
Nucleus
Command Manager
Nucleus
Coupling Facility
PLOG
PLOG
ADARES
ASSO
70
Adabas - The Big Picture
Application

• SQL Access
• SQL Server
• (JDBC ODBC)
• Native SQL

• Web Access
• Jadabas

• Administration
• Review
• Online System
• Statistics Facility
• Adabas Manager
• Adabas Utilities

• Distribution
• Vista
• Transaction Manager
• Entire Trans. Prop.

Adabas
Adabas

• Security
• SAF Security Interface
• Adabas Security

• Text Data Management
• Text Retrieval (TRS)

• ClusterSupport
• Cluster Services
• Parallel Services

VSAM

• Migration
• VSAM Bridge
• DL/I Bridge

• Optimizers
• Fastpath
• Caching Facility
• Delta Save
• Triggers Stored Procedures

Adabas
Adabas
Adabas
71
Adabas - The New Open DBMS

• EntireX Communicator
• Tamino
• EntireX Mediator

SQL Tools
XML
Web Services

• Adabas SQL Server v4
• JDBC, ODBC
• Adabas Native SQL
• Partners (Neon, Natworks..)

• - EntireX Communicator
• - Natural v5 for Open Systems
• - Tamino
• Mediator
• Natural Engineer WebStar
• Natural Web Interface

Adabas
.NET

• EntireX Communicator
• Spectrum v4.5 (2003)

Java/J2EE.
Replication to DB2, Oracle, SQL Server
Application Languages VB, C, COBOL, PL1.

• Adabas Replication Tool (future)
• Data Warehouse and Datamarts

• Jadabas
• JDBC through AQA
• EntireX Communicator

• EntireX Communicator
• Spectrum