PM55886: GETTING SQL CODE -4700 AFTER MIGRATING FROM DB2 V8 TO DB2 V10.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After migrating to DB2 V10 with compatibility mode from DB2 V8,
  attempting to enter File Manager DB2 results in a -4700 SQL
  code.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1. All users of File Manager DB2 component   *
  *                 using a DB2 V10 system in CM8 mode (migrated *
  *                 from DB2 V8).                                *
  *                 2,3. All users of File Manager DB2           *
  *                 component.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.  SQLCODE-4700 on start-up when       *
  *                      connected to a DB2 V10 system in CM8    *
  *                      mode.                                   *
  *                      2.  Incorrect batch JCL (DSNIN and      *
  *                      TCIN parameters) for File Manager DB2   *
  *                      import, when the target DB2 object      *
  *                      name is selected from a pop-up list.    *
  *                      3.  When using the File Manager DB2     *
  *                      template editor (Column Selection/Edit  *
  *                      panel), removing all customized column  *
  *                      attributes for a date/time/timestamp    *
  *                      column (E prefix command) does not      *
  *                      remove the E indicator in the 'SHE'     *
  *                      column.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1.  File Manager DB2 component is incorrectly determining the
  VRM (version/release/modification) status of the connected DB2
  system, and is erroneously attempting to execute SQL statements
  that require either DB2 V9 or V10 NFM (new function mode).
  2.  The pop-up selection process corrupts values for the input
  data set names.
  3.  The removal of all customization attributes for a date/time/
  timestamp column is not being detected.
  

Problem conclusion

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

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:

  UK79656 UK79657 UK79658 UK79659 UK79660

Modules/Macros

• FMNASMX  FMNAUDCH FMNAUDDS FMNAUD2  FMNCBIN
  FMNCBLX  FMNCPCK  FMNDSP   FMNDYNTP FMNEDIPP FMNEDIT  FMNEDI
  
  ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W4700

Applicable component levels

• RB1B PSY UK79657

     UP12/06/22 P F206

• RB10 PSY UK79656

     UP12/06/22 P F206

• RB12 PSY UK79658

     UP12/06/22 P F206

• RB13 PSY UK79659

     UP12/06/22 P F206

• RB14 PSY UK79660

     UP12/06/22 P F206

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.