Db2 for z/OS Workshop
Db2 for z/OS, Everywhere, All at Once!
- Buffer pools – and why you should care
- Applications – plans and packages and why they are important
- DDF applications – this is the single largest growth area for many organizations
- Locking, logging, security, utilities – all critical to your Db2 for z/OS environment; how you manage them can help or hurt
Db2 LUW Workshop
From SQL to Semantic Search: Building AI-Powered Search with IBM Db2 Vector
- Transform your traditional relational database into an intelligent AI-powered search engine—without ever leaving Db2! In this hands-on workshop, you’ll build a complete semantic search system that turns customer data into searchable vector embeddings using Db2’s native vector capabilities and LLM integration. Learn to write natural language queries like “Find customers who frequently buy electronics” and get instant, semantically-relevant results. Through a practical 10-step pipeline, you’ll master the new Db2 capabilities that enable this use case: embedding generation with external AI models, vector indexing with DiskANN, and lightning-fast similarity search—all using familiar SQL. Walk away with a production-ready semantic search system and the skills to bring AI capabilities to any enterprise database. No external vector databases, no complex ETL pipelines—just pure Db2 power!
Building AI Systems with Db2
- IBM Db2 offers a wide range of AI features, both built-in and external tools, for creating AI systems and solutions. These include over 200 built-in AI stored procedures and tools that work seamlessly with open-source AI ecosystems. In this workshop, participants will explore Db2’s AI support and use a selection of these features to implement practical AI models. The workshop consists of two parts. In the first module, participants will learn how to develop a supervised AI model using Db2’s built-in AI stored procedures. The entire model development and usage will be done using SQL within the database. In the second module, participants will learn how to create a Python model using popular Python packages outside of the database, and then deploy that model back into a Db2 database. By the end of the workshop, participants will have gained fundamental skills and hands-on experience in utilizing these AI capabilities. They will be able to apply these skills to their future AI projects. This workshop is designed to be beginner-friendly and does not require participants to have extensive knowledge in AI. Basic SQL skills and some Python programming skills are sufficient for attending and benefiting from this workshop.
Amazon RDS for Db2 Workshop
- This workshop will give you the education and information you need to use existing and new features of Amazon RDS for Db2. Some of the topics covered during this workshop will include provisioning, scaling, backup, monitoring, migration and beyond. Each module will be introduced and presented and then participants will be provided an environment they can use and go through a series of instructor led exercises to practice what they have learned and explore. This will be a joint workshop between the IBM and AWS RDS teams.
IMS Workshop
What is a database?
A brief description of two major database types. The differences, the similarities and the overlaps. The considerations of structure, access and usability. A summary view and comparison.
A (very) brief history of IMS
A short talk about how IMS came to be. One question quiz at the end of the day.
What sort of database is IMS?
IMS is a twofold product, so not JUST a database. Here we look at the two logical components of an IMS environment. The Transaction Manager – TM and Database Manager – DB. Then moves on the various databases available in IMS to suit programming requirements such as application access speed, availability and recovery.
Why do we choose IMS?
What makes IMS different? Business cases often have requirements that only IMS satisfies. SLAs with user might dictate levels of performance and availability. Or even the ability to handle differing volumes of transaction traffic. How does IMS provide users with the above?
IMS DB 101
IMS Database Manager component. Let’s look at the pieces needed to create and access a database. The tasks and configuration that controls database access and authorization. A deeper look at predominate database types with an eye towards performance. The Inherent integrity of IMS that allows multiple users to simultaneously access the same data structures. There will be a quick look into modernization features, such as Open DataBase Management, over the years.
IMS TM 101
IMS transaction Manager component. How does IMS process a transaction. A review of the life of a transaction. Where does the transaction run? How does IMS route it? What tasks are need in IMS to make this processing complete?
Application Development using JAVA with IMS 101
What makes and application program? A discussion of availability of programming languages. An explanation of DBDs, PCBs and ACBs modules. JAVA Environment/Coding set up for Transaction processing using SQL calls.
Problem Solving
IMS Fell over, What now? Initial step and data gathering for problem analysis and resolution. What is needed to get IMS running? What will IBM need to analysis? A starting point to turn errors into solutions.