AI and Analytics

AI on IBM Z & IBM LinuxONE

AI on IBM Z & IBM LinuxONE

Leverage AI on IBM Z & LinuxONE to enable real-time AI decisions at scale, accelerating your time-to-value, while ensuring trust and compliance

 View Only
Back to discussions
Expand all | Collapse all

Best practice to migrate CA-Realia COBOL ISAM files to PostgreSQL

  • 1.  Best practice to migrate CA-Realia COBOL ISAM files to PostgreSQL

    Posted Tue January 20, 2026 09:16 AM

    Hello,

    I am working with a legacy application with the following profile:

    • CA-Realia COBOL

    • 32-bit environment

    • Data stored in ISAM files

    • Application currently operational and stable

    We are planning to modernize the system by replacing ISAM with PostgreSQL.

    My challenges:

    • Very limited knowledge of COBOL internals and ISAM file handling

    • Large legacy codebase

    • Requirement for high data safety and system stability

    • Preference for minimal changes to business logic

    I would appreciate expert guidance on:

    • Recommended migration architecture (ODBC vs Embedded SQL vs external service layer)

    • Mapping strategy between ISAM files and relational schema

    • Typical changes required in COBOL programs

    • Known tools or frameworks used for ISAM-to-RDBMS migration

    • Risks and limitations when working with 32-bit COBOL runtimes

    • Suggested step-by-step migration approach

    The objective is to modernize storage while keeping the COBOL application functional with minimal refactoring.

    Any best practices or reference architectures would be very helpful.

    Thank you.



    ------------------------------
    mohamad ali echreshavi
    ------------------------------


Related Content