Siebel Database Upgrade Guide for DB2 UDB for z/OS > Planning A Siebel Database Upgrade > About Using the DSNTIAUL Utility >

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. @@TIAUL updates the DSNTIAUL assembler source code so that non-zero 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 apply the patch.

To apply the patch, copy the @@TIAUL USERMOD code, listed in The @@TIAUL USERMOD, 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 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 need 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.

The @@TIAUL USERMOD

This section lists the @@TIAUL USERMOD. Before copying the following code and applying the USERMOD, change the modification control statements to reflect the applicable maintenance level of the existing DSNTIAUL utility; comments in the @@TIAUL USERMOD provide specific instructions.

++ USERMOD (@@TIAUL) REWORK(2006297)
/*
USERMOD @@TIAUL:
ALLOW RETCODE 0 EVEN WHEN SELECTING LIMITED COLUMNS.

THIS USERMOD WILL CAUSE TWO SECTIONS OF CODE TO BE BYPASSED.
THAT CODE SETS RETURN CODE 4 IN THE CASE OF A SELECT OF
COLUMNS LESS THAN THE TOTAL NUMBER OF COLUMNS OF THE TABLE.

NOTE:
THE PRE-REQUISITE (PRE) OPERAND <<MUST>> BE CHANGED ON THE
++VER CONTROL STATEMENT TO REFLECT CURRENT MAINTENANCE LEVEL.

MACRO DETAILS:
MACRO FMID RMID SYSLIB DISTLIB
DSNTIAUL HDB8810 UK17727 SDSNSAMP ADSNMACS
*/ .

++ VER (P115)
FMID(HDB8810)
PRE (UK17727)
/*
***************************************************************
* DO NOT ADD LINE NUMBERS TO THIS USERMOD! *
***************************************************************
* SKIP LINES WITH SEQ NUMBERS 11900000 TO 11930000 *
* SKIP LINES WITH SEQ NUMBERS 25660000 TO 25700000 *
***************************************************************
*/ .

++MACUPD(DSNTIAUL) DISTLIB(ADSNMACS) .
./ CHANGE NAME=DSNTIAUL
*** DO NOT SET WARNING RETURN CODE *** @ORACLE 11895000
AGO .NOSLCT_BYPASS @ORACLE 11895001
.NOSLCT_BYPASS ANOP , @ORACLE 11935000
*** DO NOT SET WARNING RETURN CODE *** @ORACLE 25655000
AGO .SKIP_RETWRN2 @ORACLE 25655001
.SKIP_RETWRN2 ANOP , @ORACLE 25705000
./ ENDUP