1 / 25

Problems and Solutions with Adabas Replication and Mass Data

Problems and Solutions with Adabas Replication and Mass Data. Dieter W. Storr – www.storrconsulting.com 9 May 2011. Contents. Mirroring and Replication Different Ways to Replicate Replication Scenario and Used Versions Replication Components and their Commands per Second

tacey
Download Presentation

Problems and Solutions with Adabas Replication and Mass Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Problems and Solutions withAdabas Replication and Mass Data Dieter W. Storr – www.storrconsulting.com 9 May 2011

  2. Contents • Mirroring and Replication • Different Ways to Replicate • Replication Scenario and Used Versions • Replication Components and their Commands per Second • Subscription DB: CPU Time With and Without Replication • Batch Jobs: Duration With and Without Replication • Buffers and Communication between Source DB and Reptor • Challenges and Solutions

  3. The REPLICATOR Source: Bruno Bebert/DPA

  4. Mirroring and Replication

  5. Type of Replication – Mainframe to Adabas on Mainframe

  6. Type of Replication – Mainframe to Adabas on LUW

  7. Type of Replication – Mainframe to non-Adabas

  8. Replication Scenario – Enterprise Server to Windows RPL V3.3.1 ADA V6.2.1

  9. Commands per Second During Replication

  10. Commands per Second During Replication

  11. CPU Time and Duration Prod DB ASSO DATA WORK

  12. CPU Time and Duration Reptor Prod DB ASSO DATA WORK SLOG SYS

  13. Duration of 9 Jobs

  14. Buffers and Communication Between Source and Reptor

  15. BufferUsageDuringReplication

  16. Several Tests With 20% of Production Data

  17. STROBE: Buffer Pool Manager – High CPU TimeSource Database MODULE SECTION LINE PROCEDURE/FUNCTION STARTING PROCEDURE CPU TIME NAME NAME NUMBER NAME LOCATION LENGTH SOLO .ADABAS ADANC6 ADANC6 ADABAS BUFFER POOL MNGER 51.49 .ADABAS ADARPN ADARPN ADABAS SYSTEM SERVICES 12.61 .SVC SVC 114 EXCPVR .05 .ADABAS ADANC1 ADANC1 ADABAS THREAD SELECTION .17 .ADABAS ADANC8 ADANC8 ADABAS CMPRESS DVT HNDLR .11 .ADABAS ADANC0 ADABAS USR/HYP EXIT CALL .32 .ADABAS ADAIOS ADABAS I/O PROCESSING .21 .ADABAS ADANC5 ADABAS QUEUE PROCESSING .10 .ADABAS ADANC7 ADABAS FORMAT TRANSLATOR .03 .SUPERVS IGC0024A SUPERVISOR SERVICES .05

  18. STROBE: Buffer Pool Manager – Normal CPU TimeReptor MODULE SECTION LINE PROCEDURE/FUNCTION STARTING PROCEDURE CPU TIME NAME NAME NUMBER NAME LOCATION LENGTH SOLO .ADABAS ADARPS ADARPS ADABAS SYSTEM SERVICES 27.27 .SUPERVS IGC0024A SUPERVISOR SERVICES 13.64 .ADABAS ADANC0 ADANC0 ADABAS USR/HYP EXIT CALL 9.09 .ADABAS ADANC6 ADANC6 ADABAS BUFFER POOL MNGER 8.18 .ADABAS ADANC1 ADANC1 ADABAS THREAD SELECTION 7.27 .SVC SVC 114 EXCPVR .00 .ADABAS ADANC7 ADANC7 ADABAS FORMAT TRANSLATOR 3.64 .ADABAS ADANC5 ADANC5 ADABAS QUEUE PROCESSING 2.73 .NUCLEUS IEAVESLK SUSPEND LOCK SERVICE 2.73 .ADABAS ADAIOS PSHSTK ADABAS I/O PROCESSING 2.73

  19. LBP= ++ LFIOP= -- LRPL= ASYTVS=YES FMXIO=8 Reduce CPU Time and Duration - Solutions Reptor SLOG Prod DB Broker Reptor SLOG Reptor ASSO DATA WORK SLOG

  20. Important Parameters • LBP and LFIOP • LRPL • ADADBS DSBI=OFF • ASYTVS=YES and FMXIO= (6-8, max 16) => SLOG • LOGINPUTTRANS= (50-70)

  21. Challenge with Initial-State A file with 160 million ISNs takes too long using RPL’s initial-state function 160 million READs + 160 million STOREs + 160 million ETs Broker Networks Firewalls Routers Target DB Source DB Reptor ASSO DATA WORK ASSO DATA WORK SLOG SYS

  22. Challenge with Initial-State Solution 1: Broker Networks Firewalls Routers Target DB Source DB Reptor ASSO DATA WORK ASSO DATA WORK SLOG SYS Decompresss FTP Compresss Load

  23. Challenge with Initial-State Solution 2: ADAMAGIC Restore ADASAV backup from the mainframe to Windows or UNIX Why not from SAG?

  24. Efficient Usage of Adabas Replication- A Practical Solution Finder –By Dieter W. StorrISBN 978-3-8348-1730-3 • 11 Chapters • 262 Pages • 221 Figures • Natural Monitor Programs • Assembler Programs

  25. Thank You!

More Related