New DSNUTILV stored procedure

In Db2 12, you can use the new DSNUTILV stored procedure to pass utility statements as large as 2 GB. It is otherwise similar to the existing DSNUTILU stored procedure, which cannot pass utility statements larger than 32 KB.

The DSNUTILV stored procedure has the following restrictions:

• Any keywords, names, or constants in the utility statement cannot be larger than 32,704 bytes.
• If you pass a file reference variable, the specified data set that contains the utility statements must be in variable record format.

For detailed information about the requirements, see the description of the utstmt input parameter in the DSNUTILV information.

The DSNUTILV stored procedure is created after new function is activated in Db2 12.