• S310 - Mining the IMS Catalog: Practical SQL for Metadata Insight

    Session Evaluation

    With the introduction of the IMS catalog, IMS has embraced a modern, metadata-driven approach to managing database and application definitions. The catalog stores metadata for DBDs, PSBs, and other critical resources in a structured format that can be queried using SQL. This opens new opportunities for developers, DBAs, and system programmers to access IMS metadata in a dynamic and flexible way—without relying on traditional static source libraries or manual navigation.

    This session will focus on how to effectively retrieve and analyze IMS catalog data using SQL. Attendees will learn how to construct SQL queries to access DBD and PSB definitions, explore program-to-database relationships, and extract metadata to support auditing, DevOps pipelines, and system documentation. Real-world examples will demonstrate how SQL-based access to the IMS catalog streamlines system management, improves transparency, and enhances automation efforts in modern mainframe environments.

  • S606 - Programming Mainframe Assembler Today and in the future

    Session Evaluation

    Mainframe Assembler programming remains a crucial skill for maintaining and enhancing legacy systems in industries such as finance, government, and transportation. Despite the availability of newer programming languages, Assembler continues to be valued for its efficiency and control over system resources. This paper explores how Assembler is utilized today, the challenges and opportunities it presents for the future, including the growing need for Assembler programmers, advancements in automation, and how Assembler can integrate with emerging technologies such as AI and cloud computing. Additionally, it addresses how organizations can continue to rely on Assembler while tackling the shortage of skilled professionals in this field.