IBM Support

II14827: DB2 FOR Z/OS NATIVE RESTFUL SERVICES - ADDITIONAL DOCUMENTATION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • INTRAN

Error description

  • 5740XYR00 Information APAR for DB2 for z/OS native RESTful
    services support
    
    Additional Documentation Items:
    
    - There are no additional documentation items at this time.
    
    DB2 V11 APAR Information
    ========================
    
    -------------------------------------------------------------
    Known Restrictions/Limitations for DB2 V11:
    -------------------------------------------------------------
    
    - A DB2 RESTful service created with an SQL statement which
      refers to data which has been offloaded to an IBM
      DB2 Analytics Accelerator for z/OS (IDAA) is not supported.
      This restriction will be addressed by a future APAR.
    
    - DB2 system profile monitoring is not supported for a
      DB2 RESTful service invocation.
      This restriction will be addressed by a future APAR.
    
    - A DB2 RESTful service created with an SQL statement which
      refers to data at a remote DRDA location is not supported.
      This restriction may be addressed by a future APAR.
    
    -------------------------------------------------------------
    Known Restrictions/Limitations at DB2 V11 APAR PI66828 level:
    -------------------------------------------------------------
    
    - Due to potential scalability issues, it is strongly
      recommended that the overall size of the request and
      reply messages of a DB2 native RESTful service be
      limited to a maximum of one (1) Megabyte.
      This restriction will be addressed by APAR PI70477.
    
    - A DB2 RESTful service created with an SQL statement which
      refers to LOB or XML data is not supported at this level.
      Although a service that refers to LOB/XML data can be
      successfully created, any attempt to invoke the service
      will result in a REST error being returned to the invoker.
      This restriction will be addressed by APAR PI70477.
    
    - While the SQL CALL statement is supported for a RESTful
      service, there is currently no support for handling of
      stored procedure returned resultsets.  Stored procedure
      parameters, including IN, OUT, and INOUT usage modes,
      are supported.
      This restriction will be addressed by APAR PI70477.
    
    - A DB2 RESTful service created with an SQL statement which
      refers to data which has been offloaded to an IBM
      DB2 Analytics Accelerator for z/OS (IDAA) is not supported.
      This restriction will be addressed by a future APAR.
    
    - DB2 system profile monitoring is not supported for a
      DB2 RESTful service invocation.
      This restriction will be addressed by a future APAR.
    
    - A DB2 RESTful service created with an SQL statement which
      refers to data at a remote DRDA location is not supported.
      This restriction may be addressed by a future APAR.
    
    DB2 V12 APAR Information
    ========================
    
    -------------------------------------------------------------
    Known Restrictions/Limitations for DB2 V12:
    -------------------------------------------------------------
    
    - A DB2 RESTful service created with an SQL statement which
      refers to data which has been offloaded to an IBM
      DB2 Analytics Accelerator for z/OS (IDAA) is not supported.
      This restriction will be addressed by a future APAR.
    
    - DB2 system profile monitoring is not supported for a
      DB2 RESTful service invocation.
      This restriction will be addressed by a future APAR.
    
    - A DB2 RESTful service created with an SQL statement which
      refers to data at a remote DRDA location is not supported.
      This restriction may be addressed by a future APAR.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II14827

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    INTRAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-10

  • Closed date

  • Last modified date

    2017-10-02

  • 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



Document information

More support for: z/OS family

Software version: 001

Operating system(s): MVS

Reference #: II14827

Modified date: 02 October 2017


Translate this page: