PK70207: WHEN RUNNING DSNTIAUL TO UNLOAD, IT RETURNS DSNT497I RETURN CODE FROM MESSAGE ROUTINE 4886488

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running DSNTIAUL to unload
  DSNT497I RETURN CODE FROM MESSAGE ROUTINE          4886488
  

Local fix

• no work around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DSNTIAUL in DB2 UDB for z/OS    *
  *                 Version 8 and DB2 Version 9.1 for z/OS are   *
  *                 affected by this change.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of DSNTIAUL may observe problems  *
  *                      with the following messages:            *
  *                      (1) DSNT497I RETURN CODE FROM           *
  *                                                              *
  *                          DSNTIAUL may print an unexpected    *
  *                          value for the MESSAGE ROUTINE       *
  *                          return code                         *
  *                                                              *
  *                      (2) DSNT505I DSNTIAUL OPTIONS USED      *
  *                                                              *
  *                                                              *
  *                          V8 DSNTIAUL will only print this    *
  *                          message if 'SQL' is a specified     *
  *                          parameter.                          *
  *                                                              *
  *                          V9 DSNTIAUL will only print this    *
  *                          message with a value 'SQLTOLWARN'   *
  *                          if 'SQL' is a specified parameter.  *
  *                                                              *
  *                      (3) DSNT408I SQLCODE = -000, WARNING:   *
  *                                                              *
  *                      (4) DSNT404I SQLCODE = xxx              *
  *                          DSNT408I SQLCODE = xxx              *
  *                                                              *
  *                          DSNTIAUL may print an extra         *
  *                          character at the end of the message *
  *                                                              *
  *                      (5) DSNT417I SQLWARNn-n SQL WARNINGS    *
  *                                                              *
  *                          DSNTIAUL prints 'W' for any         *
  *                          non-blank SQLWARNx value            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DSNTIAUL is a sample dynamic SQL processing application that is
  used primarily to unload data from DB2 tables to an externalized
  format.  DSNTIAUL also generates a LOAD control statement that
  can be used in conjunction with the DB2 LOAD utility to load the
  externalized data back into DB2.
  
  This APAR fixes the return code for the DSNTIAUL Message
  Routine.  It also cleans up some other DSNTIAUL message output.
  
  (1) DSNT497I RETURN CODE FROM MESSAGE ROUTINE
  
      Currently, this message may contain an unexpected value for
      the reported return code, such as 4710272.
  
      When this is the case, some SQLCODEs may not be printed.
  
  (2) DSNT505I DSNTIAUL OPTIONS USED: ...
  
      Currently, in V8 DSNTIAUL, message DSNT505I is only printed
      if one of the specified parameters is 'SQL'.
  
      Currently, in V9 DSNTIAUL, message DSNT505I is only printed
      with the value 'SQLTOLWAR' if 'SQL' is a specified parameter
  
      In both V8 and V9 DSNTIAUL, message DSNT505I may have
      x'00's printed at the end of the message.
  
  (3) DSNT408I SQLCODE = -000, WARNING:  .
  
      Currently, on a 0 SQLCODE, DSNTIAUL may print a '-' before
      the SQLCODE value.  It may also print "WARNING:"
  
      It should print the following instead:
          DSNT404I SQLCODE = 000, SUCCESSFUL EXECUTION
  
  (4) Messages DSNT404I SQLCODE = ...
      and      DSNT408I SQLCODE = ...
  
      Currently, DSNTIAUL may print an extra character at the
      end of messages DSNT404I and DSNT408I.
  
  (5) Messages DSNT417I SQLWARN0-5 = ...
      and      DSNT417I SQLWARN6-A = ...
  
      Currently, when a SQLWARNx SQLDA field is non-blank,
      DSNTIAUL prints a 'W' for the SQLWARNx field, even if
      the value is other than 'W'.
  

Problem conclusion

• In response, this APAR modifies DSNTIAUL:
  
  (1) Sets the correct return code from the message routine;
      this may result in more SQLCA information printed out.
  
  (2) Prints out all specified parameters with the DSNT505I
      message
  
  (3) No longer prints DSNT408I SQLCODE = -000, WARNING:
      when the SQLCODE is 0.
  
      Instead, the following is printed:
          DSNT404I SQLCODE = 000, SUCCESSFUL EXECUTION
  
  (4) Removes the extra character at the end of messages
      DSNT404I and DSNT408I
  
  (5) Prints the actual SQLWARNx setting in message DSNT417I
  
  This PTF modifies only the source code for DSNTIAUL in the
  prefix.SDSNSAMP target library.  The changes do not become
  effective until the DSNTIAUL load module has been rebuilt
  from the updated source code and the DSNTIAUL plan has been
  bound from the new DBRM.  See the ++HOLD actions section of
  this PTF for information on how to prepare and bind DSNTIAUL.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK41762 UK41763

Modules/Macros

• DSNTIAUL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK41762

     UP08/12/06 P F812

• R910 PSY UK41763

     UP08/12/06 P F812

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.