DSNUTILU for fun and profit

Tuesday, 12 June, 2018 - 15:45 - 16:30
z/OS Track
Emil Kotrč
Db2 for z/OS comes with a set of Stored Procedures that can help application developers to perform various administrative tasks. The main benefits of these procedures are their ease of use via the SQL CALL statement and the simplification of processes. One example of the supplied stored procedures is DSNUTILU, which allows Db2 utility operations from the application programs.
In this presentation we will show how to use DSNUTILU, we will discuss possible real life scenarios, and the benefits and drawbacks of its usage in local and remote application programs.
1. An overview of Db2 supplied stored procedures.
2. Description of DSNUTILU and examples of possible use cases.
3. Discussion of DSNUTILU benefits and drawbacks.


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2021

VIRTUAL EVENT - 27th - 28th May 2021