Siebel Database Upgrade Guide for DB2 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. 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.

The @@TIAUL USERMOD Patch

This topic lists the @@TIAUL USERMOD for IBM DB2 UDB for z/OS Version 8. 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.

NOTE:  Sequence numbers must start in column 72.

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

THIS USERMOD WILL CAUSE ONE SECTION OF CODE TO BE BYPASSED.

THIS SECTION SETS RETURN CODE 4 IN THE CASE OF A SELECT NOT
BEING A FULL SELECT WITH "*". THE CHANGE WILL NO LONGER FORCE
A RETURN CODE 4.

THE CHANGE ALSO INCLUDES AN "ORACLE81" EYECATCHER.

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 DATE
DSNTIAUL HDB8810 UK50731 SDSNSAMP ADSNMACS 2010.01.07

*/ .
++ VER (P115)
FMID(HDB8810)
PRE (UK50731)
/*
***************************************************************
* DO NOT ADD LINE NUMBERS TO THIS USERMOD! *
***************************************************************
* REP LINE WITH SEQ NUMBERS 04600000 *
* SKIP LINES WITH SEQ NUMBERS 11900000 TO 11930000 *
***************************************************************
*/ .
++MACUPD(DSNTIAUL) DISTLIB(ADSNMACS) .
./ CHANGE NAME=DSNTIAUL
SAVE (14,12),,'DSNTIAULORACLE81&SYSDATE.&SYSTIME' @ORACLE 04600000
*** DO NOT SET WARNING RETURN CODE *** @ORACLE 11895000
AGO .NOSLCT_BYPASS @ORACLE 11895001
.NOSLCT_BYPASS ANOP , @ORACLE 11935000
./ ENDUP