DSNUTILU for fun and profit

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.

Objectives:

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.