DB2 - L

 View Only
Expand all | Collapse all

Couple of new Aha Ideas....RESTful and Trigger package full support

  • 1.  Couple of new Aha Ideas....RESTful and Trigger package full support

    Posted Mar 22, 2022 02:30 AM
    Hi all!
     I have created a couple of new Aha Ideas for "problems" all around RESTful and Trigger packages. When these were first created IBM obviously took the "quick-and-dirty" approach. I think it is time that these packages were brought into the fold of "normal" packages. To make it easier for IBM to split the work I opened two aha's:

    DB24ZOS-I-1338 Full package support for Restful services

    A restful service contains one and only one SQL statement and is, simply put, a mini-static package. It was delivered with a couple of problems. Firstly, the only way to tell if this static package is a restful service is to look at the HOSTLANG column not the TYPE column which you would expect. OK I can live with checking an extra field but then the worst, and second pain point, is that there is no support for EXPLAIN(ONLY). These restful services have access paths and we must be able to extract and check these without effecting running systems by doing a BIND SERVICE. Naturally there is also no REBIND SERVICE as all we got were BIND and FREE.

    Long story short: Make restful services the same as static packages

    and

    DB24ZOS-I-1339 Full EXPLAIN support for all types of trigger

    With Triggers you cannot use the REBIND option OWNER on a rebind. Why not? Not even for EXPLAIN(ONLY). We must get the ability, like with "normal" packages, to EXPLAIN into another set of EXPLAIN tables.

    Further, if you are using Advanced Triggers EXPLAIN(ONLY) is not allowed at all! Thus making the advanced triggers slightly less advanced than basic triggers where you can use that syntax.

    Bottom line: Bring EXPLAIN(ONLY) and REBIND options for all static packages to the same level

    ------------------------------
    Roy Boxwell
    Software Engineering GmbH
    ------------------------------


  • 2.  RE: Couple of new Aha Ideas....RESTful and Trigger package full support

    Posted Mar 31, 2022 08:28 PM
    Thanks Roy, voting on these now and here are links too

    DB24ZOS-I-1338 Full package support for Restful services


    DB24ZOS-I-1339 Full EXPLAIN support for all types of trigger

    ------------------------------
    _________________________
    Chris Muncan IDUG NA CPC
    ------------------------------