Title: Adabas v7'4 Technical Update
1Adabas v7.4 Technical Update
- Your cost efficient, high performance enterprise
database
Becky Albin Database Architect
2Agenda
- 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
32004
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
4Released in 2003
- Adabas 7.4 (mainframe)
- Including add-ons, particularly
- Adabas Parallel Services (new)
- Adabas 3.2 (Open Systems)
- Adabas 3.3 (Open Systems)
5Adabas 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
6The 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
7New 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
8Adabas 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
9Adabas 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
10Adabas v7.4 Features and Enhancements
11Adabas 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
12Adabas 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
13Adabas 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
14Adabas 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
15Adabas 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)
16Adabas 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
17Adabas 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
18Adabas 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
19How 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
20Adabas 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
21Adabas 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
22Adabas 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
23Adabas 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
24Adabas 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
25Adabas 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)
26Adabas 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
27Adabas 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
28Adabas 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)
29Adabas 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
30Adabas 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
31Adabas v7.4
- Other Enhancements (cont.)
- AOS changes
- New console/operator messages during nucleus
autorestart - New generic message for internal error in nucleus
w/abend
32Adabas 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
33Adabas Parallel Services v7.4replacement of
ADASMP
34What 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
35Adabas Parallel ServicesToday and Tomorrow
36Adabas 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
37Adabas 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
38Adabas 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
- //
39Adabas 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
40Adabas Parallel Services Implementation
- User Exit 2/12
- ADARES PLCOPY/CLCOPY and MERGE
- Two intermediate datasets (input/output)
- USEREX2P or USEREX12P (sample jcl)
41Adabas 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
42Adabas 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
43Adabas 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
44Adabas 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
45Adabas in an IBM Parallel Sysplex
EnvironmentAdabas Cluster Services v7.4
46IBMs 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
47Parallel Sysplex
Coupling Facility
OS/390
OS/390
OS/390
48Adabas 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
49The Coupling Facility
- Cache Structure
- Data consistency and high speed
- Organization of shared data
- Lock Structure
- Resource Serialization
Cache Structure
Lock Structure
Coupling Facility
WLM
50Adabas 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
51Features
- 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
52Features
- 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)
53Adabas 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
54Adabas 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
- //
55Adabas 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
56Adabas Cluster Services Implementation
- User Exit 2/12
- ADARES PLCOPY/CLCOPY and MERGE
- Two intermediate datasets (input/output)
- USEREX2P or USEREX12P (sample jcl)
57Multi 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
58Adabas 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
59The 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
60Cluster 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
61Coupling 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
62Log Merge Utility
OS/390
OS/390
Command Manager
Nucleus
Command Manager
Nucleus
Coupling Facility
CLOG
PLOG
CLOG
PLOG
ADARES
ASSO
Merged LOG DSNs
63Adabas 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
64Adabas 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
65Adabas 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
66Adabas 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
67Each 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
68Cluster 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
69Log Merge Utility (ALS)
OS/390
OS/390
Command Manager
Nucleus
Command Manager
Nucleus
Coupling Facility
PLOG
PLOG
ADARES
ASSO
70Adabas - The Big Picture
Application
- SQL Access
- SQL Server
- (JDBC ODBC)
- Native SQL
- 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
71Adabas - 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