IBM Support

PI10521: DB2 11 FOR Z/OS NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • DB2 11 for z/OS new function.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR is the enabling APAR for      *
    *                      JSON support on top of DB2 for z/OS.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    JSON (JavaScript Object Notation) support is introduced via this
    APAR. These initial changes are provided to help enable use of
    DB2 for z/OS as a JSON store, not for general use by a user.
    
    DB2 provides an SQL interface to extract and retrieve JSON data
    into SQL data types from BSON (Binary-encoded Serialization of
    JSON) objects. The schema is SYSIBM. This interface takes an
    argument which is intended to be a BLOB that contains one JSON
    document represented as BSON, and each such JSON document holds
    only one business object in JSON notation (stored as BSON).
    
    This APAR also adds several DB2-supplied user-defined functions
    (UDFs), a DB2-supplied stored procedure, and a database for
    serviceability.  Refer to ++HOLD actions of this APAR for
    installation details of these UDFs, stored procedure, and
    database.
    
    The extensions for DB2 for z/OS are part of an integrated
    deliverable between DB2 server and client components. The client
    components will be available in DB2 Accessories Suite for z/OS
    Version 3.2 (DB2 Accessories Suite V11 feature).
    

Problem conclusion

Temporary fix

Comments

  • This new function is already available in DB2 10 for z/OS via
    APARs PM97869 and PM98357.
    

APAR Information

  • APAR number

    PI10521

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-28

  • Closed date

    2014-05-14

  • Last modified date

    2014-06-03

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

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

    UI17988

Modules/Macros

  • DSN@RIN  DSN@RVFY DSN@XAZP DSNTESR  DSNTIDXA DSNTIDXB DSNTIJRT
    DSNTINST DSNTINSV DSNTINS1 DSNTIPRA DSNTIPRQ DSNTRIN  DSNTRVFY
    DSNTXAZP DSNXOBFA DSNXOBFF DSNXOBF3 DSNXOBF4
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI17988

       UP14/05/30 P F405

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.



Document information

More support for: DB2 for z/OS

Software version: 11.0

Reference #: PI10521

Modified date: 03 June 2014