1 / 26

Solutions for evolving IDMSX applications Adrian Thompson and Richard Halsey

Solutions for evolving IDMSX applications Adrian Thompson and Richard Halsey. Who are Xitec. Founded 1994 Based in UK and USA Work with over 30 companies worldwide Partnerships include ICL, EDS, HPS… Solutions include Off Mainframe Development Data Mining Pathway Visualisation

benito
Download Presentation

Solutions for evolving IDMSX applications Adrian Thompson and Richard Halsey

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. Solutions for evolving IDMSX applicationsAdrian Thompson and Richard Halsey

  2. Who are Xitec • Founded 1994 • Based in UK and USA • Work with over 30 companies worldwide • Partnerships include ICL, EDS, HPS… • Solutions include • Off Mainframe Development • Data Mining Pathway • Visualisation • Migration

  3. Off Mainframe Development Benefits • People • Increase productivity • Boost morale • Value • Enhance application quality • Improve return on investment • Skills • Move towards modern technology • Retain existing skills

  4. Off-mainframe development TPMS Service + Screen Painter Productivity VME Mainframe Open Systems C2 COBOL Pre-processing to High functionality Test/Animation/ Debug Environment OpenSCL Partnership with EBE Computing DDCL CLUC Application Source Copy Libraries TP Parameter Files SCL Data Xitec Distributed System Dictionary Visual Application Master Jackson Style Structure Diagram IDMSX on a Relational Database Visual

  5. Xitec Dictionary • Graphical dictionary • Central repository for all definitions • Complete fast import • DDCL, CLUC, TPMS parameter files • Latest, intuitive interface • Fast dynamic, familiar, full function definition entry • Tree structure, tabbed property pages • Syntax checks and prepares TPMS/IDMSX/AM in seconds • Holds relational database mapping definitions • Stored in a relational database

  6. Database Structure Diagram Produced from IDMSX database definitions in the dictionary Select from drop down menu

  7. View Record Structure From DDCL structure At the click of a mouse To COBOL structure

  8. Automatic RDBMS Mapping Graphical Dictionary Interface Windows Explorer Style Visual Flexible Application (program interface) System Dictionary Definitions Schema Storage-schema Subschema Records Keys Pointers Run-Time Transparent Access Relational Database

  9. IDMSX Loader • Populate IDMSX db from mainframe block dump of data files • Structure taken from Xitec Dictionary • EBCDIC <-> ASCII conversion, integrity check, partial load • Very fast, easy to use and effective • Re-run anytime, saves time, costs and help meet schedules Auto Conversion EBCDIC - ASCII Mainframe IDMSX RDBMS

  10. IDMSX Explorer • Display data • Explorer style or DML navigation • Modify data • Check results

  11. TPMS Emulation Application Virtual Machine Control Virtual Machine Client Processes Network Routing Reply Handler AVM Control Application Virtual Machine Created from current definitions Application Virtual Machine Source Line Debug

  12. TPMS Screen Painter Drag and drop Alignment From dictionary definitions Prototyping

  13. AM - Dictionary • Load from mainframe • Easy to visualise • Fast and intuitive to use • Tabbed property pages • Easy to edit

  14. Visual AM • Modern tools for fast AM programming • Understand AM structures and flows • Click to edit current structures • Add new structures • Updates dictionary

  15. AM Debug • Fast debug tools for TP and batch • Step through AM • View variables • Conditional breaks

  16. Summary of Benefits • People • Increase productivity • Boost morale • Value • Enhance application quality • Improve return on investment • Skills • Move towards modern technology • Retain existing skills

  17. Business Benefits Provide more accurate and timely management information about your customers, products and business performance Spin-offs Production of ad-hoc reports, reducing the IT burden Investigation of mainframe database issues Store archive data with faster access on cheaper medium Merge some flat files into the database Data Mining Pathway

  18. Tables Data Mining Pathway Transfer Data Xitec Loader Mainframe e-business applications Transfer Definitions Load / Convert Data Business Intelligence Tools Graphical Dictionary Interface RDBMS Automatically create Programs Open Systems Flexibility

  19. From this … Customer Orders Alpha 15 Bravo 14 Charlie 56 Delta 3 Echo 26 Data Mining Pathway To this …

  20. Data Mining Pathway • Xitec dds populated from mainframe ddcl • Relational model generated from IDMS database • Mapping mechanism established to define data migration rules • Scripts to create relational tables, indexes etc automatically created

  21. Data Mining Pathway • 1 table created for each IDMS record • 1 column for each item • 1 relationship per set • Sequence & foreign key columns generated • Integrity rules replicated

  22. Data Mining Pathway • Input from mainframe database dump for bulk load, or IDMS journal for updates • Full or partial load • Output to bulk load files • Reformats EBCDIC to ASCII • Allows remapping of data in-flight • drop records / fields • split / merge records • concatenate / split fields • Configurable - session based

  23. Summary Data Transfer Process Image Copy File transfer Alternative input Compressed Format Loader Files IDMSX Loader Export Relational database load files File transfer RDBMS Relational Database Load

  24. Retain familiarity of existing database Faster, flexible access to mainframe data Little or no additional mainframe loading Choice of modern reporting and interrogation tools Take advantage of relational database technology Reduced filestore costs > increased data capacity Easy scalability Summary of Benefits

  25. Questions?

  26. For further information… www.xitec-software.com

More Related