PJ39741: FILE IMPORT WITH LOAD IS MARKED AS SUCCESSFUL EVEN IF THE FILE TO BE LOADED IS MISSING

IBM ISW-InterimFix-SQW_9.7.3.v20120719

APAR status

• Closed as program error.

Error description

• When running a File Import operator with 'LOAD' option in a
  control flow, the execution status of the flow shows success
  even if the file to be loaded does not exist.
  
  The log file may also show the following message:
  
  Call ADMIN_CMD: SQL2036N: The path for the file or device
  "xxxxxx" is not valid.
  
  Subsequently, no data will be loaded to DB2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * SQW users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a FileImport operator with 'LOAD' option runs in a      *
  * control                                                      *
  * flow, if the file to loaded does not exist, the execution of *
  * this operator will still mark the execution status as        *
  * success.                                                     *
  *                                                              *
  * In the log file, it has the message like this:               *
  *                                                              *
  * Call ADMIN_CMD: SQL2036N: The path for the file or device    *
  * "xxxxxx" is not valid.                                       *
  *                                                              *
  * Subsequently, no data is loaded to DB2.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The interim fix was delivered through SQW interim fix        *
  * package 'SQW-9.7.3.v20111212'.                               *
  *                                                              *
  * Please upgrade to ISW 9.7.7 to pickup the full fixes of this *
  * problem as well as other fixes.                              *
  ****************************************************************
  

Problem conclusion

• The logic for checking the error code from DB2 LOAD utility
  needs to be improved.
  

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:

Fix information

• Fixed component name

  DWE SQL WHSE TO

• Fixed component ID

  5724DWESQ

Applicable component levels

• R973 PSY

     UP