PM94171: SQLCODE-270 ATTEMPTING TO ACCESS A REMOTE LOCATION CATOWNER=SYSIBMV IN FMN2POPT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE-270 attempting to access a remote location, target DB2
  system is DB2 V10 (CM9) and CATOWNER=SYSIBMV specified in the
  FMN2POPT.
  

Local fix

• Instead of using SYSIBMV as the CATOWNER parameter in the
  FMN2POPT, code CATOWNER=SYSIBM instead.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. In File Manager DB2 component        *
  *                      SQLCODE-270 "Function not supported"    *
  *                      on start-up.  The target DB2 system     *
  *                      is at DB2 V10 (CM9), AND the CATOWNER   *
  *                      parameter in the FMN2POPT specifies     *
  *                      a value other than SYSIBM.              *
  *                      2. In File Manager DB2 component        *
  *                      SQLCODE-270 "Function not supported"    *
  *                      in the Object List Utility attempting   *
  *                      to change locations.  The target DB2    *
  *                      system is at DB2 V10 (CM9), AND the     *
  *                      CATOWNER parameter in the FMN2POPT      *
  *                      specifies a value other than SYSIBM.    *
  *                      3. In File Manager DB2 component        *
  *                      Print function, the message 'XML        *
  *                      column(s)' persists after an attempt    *
  *                      is made to process an object with       *
  *                      XML columns.                            *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1.  The code that detects the status of the target DB2 system
  is erroneously reporting the SQLCODE-270.
  2.  The SQL statement used to retrieve information from the
  remote DB2 system is erroneously including columns that are
  not available in CM9 mode.
  3.  An internal flag is not being reset.
  

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:

Modules/Macros

• FMN2LVL
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W6800

Applicable component levels

• RC12 PSY UK97434

     UP13/09/13 P F309

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.