PM25524: FILE MANAGER TOLERATION FOR DB2 VERSION 10

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR allows FM/DB2 Version 10 to work with
  DB2 version 10 systems.
  No support for DB2 Version 10-specific features is provided as
  part of this APAR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This is an enhancement APAR, providing  *
  *                      toleration support when connected to    *
  *                      DB2 version 10 systems.                 *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  DB2 version 10 was released after File Manager version 10.
  Accordingly, File Manager version 10 does not work properly when
  connected to DB2 version 10 systems.
  

Problem conclusion

Temporary fix

Comments

• File Manager DB2 component has been updated to provide
  toleration support when connected to DB2 version 10 systems.
  The following is a summary of the toleration support included
  with this APAR:
  1.  Connection to DB2 version 10 systems supported.
  2.  The DB2 release is now shown as, eg '0815', '0915', '1015'.
      Previously the DB2 release was shown as, eg '815', '915',
      '015'.
  3.  FM/DB2 functions Browse, View, Edit, Print, Copy, Import,
      Export and Data Create will work with DB2 V10 objects.  No
      changes have been made to support DB2 V10 objects that
      include DB2 V10 specific features.
  4.  The Object List and Object Privileges utility will display
      the correct list of object/privilege types when connected
      to a DB2 version 10 system.  The 'VS' command (Show view
      SQL) does NOT work when connected to a DB2 version 10
      system.  No support is offered for any new DB2 version 10
      catalog tables.  Any new column(s) added to DB2 catalog
      tables with DB2 version 10 will NOT be shown when using the
      FM/DB2 Object List utility.
  5.  No changes have been made to the DB2 Utilities function, the
      DB2 utilities supported and the DB2 utility control
      statements generated are unchanged.
  6.  No changes have been made to the Explain utilities function.
      Any explain-related tables created using this function will
      not include any columns added in DB2 version 10.
  7.  The SQL Advanced Prototyper will work when connected to a
      DB2 version 10 system, but the syntax supported is for DB2
      version 9.
  8.  The SQL Reverse Engineering code (GEN command in the Object
      List utility) is unchanged.  The GEN command may fail when
      the target DB2 version 10 object includes DB2 version 10
      specific syntax.
  

APAR Information

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

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

  UK64385 UK64386 UK64394 UK64395 UK64396 UK64403 UK64434 UK64435

Modules/Macros

• FMNASMX  FMNAUDCH FMNAUDDS FMNBELOW FMNBE99
  FMNBTB   FMNBTU   FMNCARMA FMNCBIN  FMNCBLX  FMNCMEDB FMNCMI
  
  ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
  

Fix information

• Fixed component name

  FILE MANAGER ZO

• Fixed component ID

  5655V5200

Applicable component levels

• RA1A PSY UK64386

     UP11/02/04 P F102

• RA1B PSY UK64394

     UP11/02/04 P F102

• RA1C PSY UK64395

     UP11/02/04 P F102

• RA10 PSY UK64385

     UP11/02/04 P F102

• RA11 PSY UK64396

     UP11/02/04 P F102

• RA12 PSY UK64403

     UP11/02/04 P F102

• RA13 PSY UK64434

     UP11/02/04 P F102

• RA14 PSY UK64435

     UP11/02/04 P F102

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.