DARSTRAN - CA-IDMS to Relational Replication
DARSTRAN enables data replication from CA-IDMS mainframe databases to relational databases such as Oracle, DB2/UDB or Microsoft SQL/Server that run on IBM mainframe, UNIX, AIX, Linux or Microsoft Windows NT/2000 Server Operating Systems and their related hardware platforms.
NO CA-IDMS database access is performed except to extract the CA-IDMS data for Initial Load of the target RDBMS.
The core DARSTRAN Replication Engine© and Journal Image Processor© have been designed and written to run on a full range of popular target platforms, including the mainframe. Common code for all platforms ensures high performance, reliablility and identical replication on all platforms.
The core DARSTRAN Replication Engine© and Journal Image Processor© provide superior performance and reliablilty when capturing updates from the Active CV Journals. Updates are processed at COMMIT and/or FINISH and sent to the target platform using the guaranteed delivery provided by IBM's MQSeries®. No application or CA-IDMS® system modifications are required.
The innovative design allows ISP to offer optional components to CA-IDMS® users who require data replication to an RDBMS on mainframe, Windows NT® and/or AIX®/Unix/Linux based platforms.
The user may optionally generate XML to process the replicated data with a variety of third party software products or generate data in a format suitable to the Ab Initio software.
There is no requirement to copy the client's database files for processing off site. All CA-IDMS data processing is performed at the client's site under the client's scrutiny and security control.
Transforms CA-IDMS® Schema syntax to RDBMS DDL or proprietary Ab Initio software syntax.
Addresses CA-IDMS® Schema changes that affect an already-configured DARSTRAN©.
Eliminates the manual updating of replication definitions after CA-IDMS® Schema changes.
Accepts updated Schema syntax, compares it to the original, reports on the differences and automatically incorporates the changes into the replication definition.
Provides complete data formatting on the mainframe or target platforms.
Reassembles and transforms Initial Load CA-IDMS® extract data and CA-IDMS® Journal images into either Fast Load syntax, SQL statements or XML.
Implemented as a Service for Windows NT® and as a Daemon for AIX®/Unix/Linux to eliminate the need for scripting on the target platform.
Invokes DARSTRAN© to perform the required data transformations and manages the application of the data to the target RDBMS or Ab Initio software.
Configurable to facilitate multiple simultaneous Initial Data Loads to greatly reduce target RDBMS run times.
Incorporates ERROR logging facilities.
Will support SNMP (Simple Network Management Protocol) in the near future as an interface to monitoring the DARSTRAN© software with tools such as CA-Unicenter® and HP-Openview®.
Cost Savings and Performance
DARSTRAN© reduces the impact on mainframe resources through highly optimized code and, optionally, by moving the Archive Journal processing to the target platform.
Near Real-Time target updates are achieved using the sophisticated Active Journal facility in conjunction with the speed, reliability and guaranteed message delivery of IBM'S MQSeries© software running on the mainframe and target platforms.
Dramatic performance improvements may be realized if the parallel processing features of DARSLOAD© are fully exploited in installations where the available CPU cycles on the target platform exceed those available on the mainframe.
Note: Journal processing which requires invoking the CA-PRESSPACK® software is only supported on the mainframe. This is a limitation of the CA-PRESSPACK® code and not DARSTRAN®.
Resolution of SET OWNER Relationships
Built-in logic dynamically computes OWNER pointer values for a SET where OWNER pointers are not defined in CA-IDMS® by using the SET’s NEXT pointer within the replica. Absolutely NO access to the CA-IDMS® application database is required to formulate the relationship.
Predictable response times plus elimination of “dirty reads” of the CA-IDMS® application database result in substantial performance benefits.
Comprehensive Error Logging
Extensive Error logging facilities.
Formatted for loading into an RDBMS table for query and analysis.
Includes logging of invalid Dates and Elements that contain data that does not match the defined Data Type.
Flexible error detection provides logging of information at the Schema, Record, or Element level.
DARSTRAN is provided in collaboration with our software development partner - International Software Products inc