Bookmark and Share
RSS

Recent Posts

A New Utility Stored Procedure

September 05, 2017

The stored procedure DSNUTILS has been deprecated as of Db2 12. It's used to call utility program DSNUTILB using EBCIDIC encoded parameters. While your application will continue to function when DSNUTILS is called, it could be removed from future releases. For this reason, you should replace DSNUTILS with either of two current support procedures, DSNUTILU and DSNUTILV.

DSNUTILU supports utility control statements that are smaller than 32K. To call more complex statements, use DSNUTILV, which is new with Db2 12. It supports utility control statements as large as 2 GB.

Utility control statements define the function that the utility performs. The IBM Knowledge Center has rules and examples for running all these utilities:

BACKUP SYSTEM
CATMAINT
CHECK DATA
CHECK INDEX
CHECK LOB
COPY
COPYTOCOPY
DIAGNOSE
EXEC SQL
LISTDEF
LOAD
MERGECOPY
MODIFY RECOVERY
MODIFY STATISTICS
OPTIONS
QUIESCE
REBUILD INDEX
RECOVER
REORG INDEX
REORG TABLESPACE
REPAIR
REPORT
RESTORE SYSTEM
RUNSTATS
STOSPACE
TEMPLATE
UNLOAD

If you've implemented applications using the new Db2 stored procedure DSNUTILV, please share your experience in comments.

Posted September 05, 2017 | Permalink

comments powered by Disqus