PI12494: Receive SQLCODE = -104 when copying a row from one DB2 location to another using FM/DB2 option 3.3.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When copying a row from one DB2 location to another using
  FM/DB2 option 3.3, receive message:
  
   DSNT408I SQLCODE = -104, SQLSTATE = 42601, SYNTAX ERROR OR
   ACCESS RULE VIOLATION FROM ?
          TOKENS <END-OF-STATEMENT> NOT EXISTS XMLEXISTS ( USER ?
       CURRENT CURRENT_SCHEM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE-104 using the File Manager DB2  *
  *                      component copy utility, copying from    *
  *                      one location to another, with update    *
  *                      of existing rows.                       *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The target table has these indexes:
  . IX1, an index defined as 'UNIQUE WHERE NOT NULL'
  . IX2, an index defined as 'UNIQUE', all columns in the index
    key are defined as 'NOT NULL'.
  An insert into the target table that results in SQLCODE-803
  against IX1 results in an SQL statement to update that row with
  a WHERE clause that has no predicates, resulting in the observed
  SQLCODE -104.
  

Problem conclusion

• File Manager DB2 component has been updated to correct the
  problem.
  

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:

Modules/Macros

• FMN2LVL  FMN2LVLJ FMN2LVLK
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W6800

Applicable component levels

• RC1B PSY UI17766

     UP14/05/14 P F405

• RC12 PSY UI17767

     UP14/05/14 P F405

• RC13 PSY UI17768

     UP14/05/14 P F405

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.