1. Database Upgrade Guide for DB2 for z/OS
  2. About Applying the DSNTIAUL Patch

About Applying the DSNTIAUL Patch

The DSNTIAUL patch, @@TIAUL USERMOD, is packaged as an SMP/E format USERMOD. The patch is a MACUPD (macro update) because DSNTIAUL is delivered as a macro and not as a source object. The @@TIAUL USERMOD updates the DSNTIAUL assembler source code so that nonzero return codes generated solely by the selective SELECT statements are suppressed. The USERMOD is generic in that it applies to known fix levels of the DSNTIAUL utility.

Note: It is recommended that a DB2 systems programmer who has knowledge of SMP/E and your maintenance process applies the patch.

To apply the patch, copy the @@TIAUL USERMOD code, listed in The @@TIAUL USERMOD Patch, and apply it to the SMP/E DB2 target zone on z/OS. You can apply the patch using various methods, for example:

  • Use the SMP/E APPLY command to apply @@TIAUL USERMOD directly to the z/OS system, then run assemble, link, and bind jobs to specify it as the default program

  • Copy the source member containing the original DSNTIAUL code and add the code from @@TIAUL USERMOD to the copy. Then create an executable with a new name for the new source member.

Note: If you use this method, you might have to change the Siebel upgrade scripts to accommodate any changes to the way in which DSNTIAUL is invoked.

Ask your z/OS system administrator for the most appropriate method to use to apply the @@TIAUL USERMOD at your site.