IBM Support

II06865: SQLCODE -30073 RC147A TO A DB2 DRDA SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as canceled.

Error description

  • 5740XYR00 R230 KDW0434
    From an OS/2 requester, the user's program attempts to use
    (IEEE) floating point data that is too large for DB2.  In
    the 80X86 architecture (where OS/2 applications run) IEEE
    floating point numbers can be much larger than what can be
    supported in the system 370/390 architecture (where DB2 runs).
    In this case, an OS/2 program host variable was set with the
    value 1.2E126.  An SQL statement is executed to a DB2 server
    using this host variable as input. This is beyond the limit
    of the S370/390 architecture therefore DB2 returns a VALNSPRM
    (VALue Not SuPported Reply Message) to the requester indicating
    code point 147A (FDODTA).
    Users should refer to DB2 Messages and Codes manual under
    SQLCODE -405 and -406 for a description of the limits that are
    imposed by a DB2 system.
    **************************
    Additional symptoms and keywords:
      SQL30073N SQL30073 SQLCODE30073N SQLCODE30073 30073 -30073
      RC147A 147A FDODTA DRDA DB2 DDF DB2DRDA
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • Closing informational APAR.
    

APAR Information

  • APAR number

    II06865

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    CLOSED CAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    1993-04-05

  • Closed date

    1993-04-05

  • Last modified date

    1993-04-05

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 December 2020