IBM Support

PM14353: SQLCODE-104 ACCESSING A DB2 V8 SYSTEM (NFM) USING DDF FROM A DB2V9 SYSTEM (NFM), WITH CATOWNER¬=SYSIBM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When accessing a DB2 V8 system (NFM) using DDF from a DB2 V9
    system (NFM), with CATOWNER¬=SYSIBM, receive message:
    
    DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "ROUNDING". SOME
    SYMBOLS THAT MIGHT BE LEGAL ARE: = ENCODING
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: SQLCODE-104 attempting to access a DB2  *
    *                      system that is prior to V9 (NFM), when  *
    *                      connected to a DB2 system at DB2 V9     *
    *                      (NFM), with FMN2POPT parameter CATOWNER *
    *                      not equal to 'SYSIBM'.                  *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    FM/DB2 is erroneously issuing SQL statements to set the CURRENT
    DECFLOAT ROUNDING MODE, when connected to DB2 systems that do
    not support this statement.
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    PM14353

  • Reported component name

    FILE MANAGER ZO

  • Reported component ID

    5655V5200

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-05-13

  • Closed date

    2010-07-29

  • Last modified date

    2010-09-01

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

    PM13661

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

Modules/Macros

  • FMN2LVL
    

Fix information

  • Fixed component name

    FILE MANAGER ZO

  • Fixed component ID

    5655V5200

Applicable component levels

  • RA12 PSY UK59244

       UP10/08/04 P F008

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
01 September 2010