SQLite is a popular open-source database management system that is widely used in the software industry. Despite being developed for use on small-scale applications, SQLite has proven to be a versatile and reliable solution for larger applications. One area where SQLite can offer unique benefits is in mainframe environments, where traditional relational database systems such as Db2 can be expensive and resource intensive. This presentation will explore the benefits of using SQLite on z/OS. We will cover the basics of SQLite and its capabilities, as well as the challenges and benefits of running SQLite on z/OS. We will also discuss best practices for setting up and managing SQLite on z/OS, including performance tuning, security considerations, and integration with other mainframe applications. We will describe our own experiences implementing SQLite in a z/OS product. Performance metrics of SQLite under real world conditions will be shown including DASD and CPU usage. By the end of this presentation, attendees will have a clear understanding of the advantages of using SQLite on z/OS, and will be equipped with the knowledge and tools needed to start implementing SQLite solutions in their own mainframe environments.

z/OS V2.5 introduced a new feature called IBM z/OS Change Tracker. z/OS Change Tracker is designed to deliver real-time, system-wide software configuration change tracking and control for system libraries across all LPARs in a sysplex, automatic versioning of identified system control data sets, including customization of the number of backups, and member-level recovery and reporting […]

It's probably been a while, thanks to COVID, since we were reminded howbrilliant and relevant ISPF still is to many of IBMs customers. Join one of the Perth based ex-ISPF team members as he resurrects an ISPF Hidden Treasures session. He will remind old users, and introduce new users, to some of the hidden or […]