Loading…
Welcome to The AI Era Conference 2026: Shaping Tomorrow’s Intelligence Today!

Join us as we navigate the transformative landscape of AI, forge connections, and unlock the potential of tomorrow’s possibilities. Let’s embark on a journey towards a more intelligent future together!
Venue: Aristoteles 3 clear filter
arrow_back View All Dates
Tuesday, October 28
 

10:20am WIB

F6 | A day in the life of an MFA-enabled Db2 for z/OS DBA
Tuesday October 28, 2025 10:20am - 11:20am WIB
As enterprise security threats evolve, Multi-Factor Authentication (MFA) has become essential for safeguarding access to mission-critical systems like Db2 for z/OS. This session provides an inside look at a day in the life of a Db2 for z/OS administrator navigating an MFA-enabled environment. From securely logging in and managing authentication challenges to executing routine database tasks with enhanced security controls, we’ll examine how MFA impacts daily workflows, troubleshooting, and compliance requirements. Attendees will gain practical insights into best practices, potential challenges, and strategies for balancing security with productivity. Additionally, we’ll explore a range of access methods, from traditional TSO to modern tools like Db2 for z/OS Administration Foundation, SQL Tuning Services, and the Db2 for z/OS Developer Extension for VS Code.
Speaker
Tuesday October 28, 2025 10:20am - 11:20am WIB
Aristoteles 3
  Track F

11:30am WIB

F7 | Coming back to DSNZPARM roots
Tuesday October 28, 2025 11:30am - 12:30pm WIB
In the past, one of the most required tasks of a Db2 DBA when facing the migration to a new version was to check and review parameters in DSNZPARM module. Along the Db2 versions, some parameters disappeared, some still remain but almost forgotten and new ones are coming out to cover the new functionalities and enhancements developed or to update existing capabilities.
As per Db2 13, there are more than 300 parameters. This seminar reviews the most important parameters, grouped by the Db2 functionalities or areas where they apply and focused on latest Db2 13.
Tuesday October 28, 2025 11:30am - 12:30pm WIB
Aristoteles 3
  Track F

1:00pm WIB

RUG Leaders Meeting
Tuesday October 28, 2025 1:00pm - 2:00pm WIB
Take a moment to eat lunch, and come join us for a RUG Leaders Meeting. All are welcome.
Tuesday October 28, 2025 1:00pm - 2:00pm WIB
Aristoteles 3

2:00pm WIB

F8 | Tales of a DBA with UDFs and Store Procedures
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
I would like to talk about the Stored Procedures from a DBA point of view, as starting points:
- Differences between SP and UDF, and some information about what they are. The different SP and how to check if you have still any External SQL, that is deprecated and how to migrate them to Native.
- How to display their status, checking whether they are started or not, among other things
- How to consult the WLM where they run, and check with the command /D WLM, APPLENV whether its available or not, and how if there’s a problem with the SP, normally you can find the error there, for example if it’s giving some ASUTIME error.
How to check our WLM environments, in order to see if we have them with the right parameters: NUMTCB, MNSPAS, ...
- ZPARM related to them, as the “new” MAX_UDF.
- Talking about the DSNTIJPM Premigration Reports Db2 V13, because Report 19 is for checking the native SQL procedures and compiled SQL created prior to Db2 11. So if you have any, you have to regenerate them before moving to V13. How to check and how to regenerate them. I had to do this for some before moving to V13.
- Show some of the IBM Stored procedures provided by IBM, for example I always use the DSNTEJ6Z installation job- for calling the ADMIN_INFO_SYSPARM and get the ZPARM of any subsystem.
- The ADMIN_INFO_SQL, sometimes you can need it for sending it to IBM support
- The one for doing a WLM_REFRESH (DSNTEJ6W), I find this interesting for example, for giving at Development the option to the developers to do themselves the WLM refresh, only at development, that way they don’t need to ask for the same to Ops or zOS teams.
- Other options that can be discussed with the application are these parameters:
· STOP AFTER SYSTEM DEFAULT FAILURES
· STOP AFTER nn FAILURES
· CONTINUE AFTER FAILURES
. STAY RESIDENT
- The stored procedures to run utilities or execute Db2 commands: DSNUTILU, DSNUTILV, …
- Some interesting provided UDF as the ones at DSNTEJ3U: DAYNAME, CURRENCY, … or the interesting WEATHER.
Mainly the Db2 people hear about a Stored Procedure when there’s a problem. Maybe you are the one also that DROP or CREATE it, but for sure, if any of them starts to consume a lot, or to loop, or to have some trouble, you will be the one contacted for checking where the problem is.
Tuesday October 28, 2025 2:00pm - 3:00pm WIB
Aristoteles 3
  Track F

4:30pm WIB

F9 | Modernize Db2 for z/OS Development with VS Code
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
In this session, discover how to leverage VS Code, one of the most popular Integrated Development Environments (IDE), for Db2 for z/OS development. Using a sample CICS DB2 COBOL application, you’ll learn to check out code from SCM, fix errors, and utilize debugging tools for a thorough walkthrough. We’ll also set up a test script for further evaluation before deploying the application to the CICS region for final testing—all within VS Code. Enhance your skills and streamline your development process!
Speaker
Tuesday October 28, 2025 4:30pm - 5:30pm WIB
Aristoteles 3
  Track F
 
From $0.00

AI Era: Shaping Tomorrow’s Intelligence
From $0.00
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -