Re: multi-tenant issues with stored procedures

On Wed, Nov 29, 2017 at 12:01 PM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

Yes, but off-platform stored procedure calls all come into the IBM
i using the same job description -- correct?

To me the question sounds rhetorical. At the risk of stating the obvious
I'll respond by saying that off-platform applications connect with a
prestart job (QZDASOINIT, most likely) that is probably already running
within a pool of prestart Jobs that respond to such client requests.

If this is not correct.

Please enlighten me how an off-platform stored procedure call can specify
what IBM i job description to use for its session.

I'm not aware of any way for off-platform programs to "pick" which IBM i
database Job they might connect to. And I'm not aware of any way to
configure prestart jobs to service a particular tenant.

Frankly, I'm not aware of any solid rationale for trying to support
multi-tenant environments via QZDASOINIT Jobs nor any other interface that
is based on ODBC or JDBC. Hence, the reason for my question. To open the
discussion to explore options.