James / Nadir,
Thanks for your input.
It was me who bound SPUFI against the remote systems, so I know
I was trying to do a BIND COPY and wasn't having a lot of success.
eventually found that if I created an alias on the remote (LUW)
the same name as the z/OS alias then I could get the bind copy to
even a very simple SP to run.
But as soon as I try to do anything useful in the SP it starts to
series of errors, most recently "Mutually exclusive fields cannot
contain non-null values: error code -4499". This seems to be some
with the JDBC driver which calls the SP (from Data Studio) -
PMR I found on this relates to DB2 --> DB2 code rather than DB2
--> LUW and
I have a JDBC driver newer than the one that fixed that
Maybe I do need to cut my losses on this one and drive everything
LUW side. I've been doing federated stored procedures from LUW for
time, so I do know that works. But I was hoping to drive this from
I'm only looking at application code for this at all because of
issue with LOAD from CURSOR over federation where the tables
include XML or LOBs. The amount of data being transferred is
compared to the size of the actual data - and a previous PMR I
this shows that the XML / LOB is being expanded in an internal
the maximum allowable length before transmission. I couldn't get
fixed, since I couldn't convince support that this wasn't working
(I think because they'd have to go into the guts of the memory
code to fix something that very few people use.
At the end of the day, I've got to consolidate about 4 TB of XMLs
LUW databases into a single z/OS database and will have to find
some way of
doing it (and as efficiently as possible).
On Thu, 2 Jul 2020 at 06:18, James Campbell
<[login to unmask email]> wrote:
> "> If so, how do I get the package I need out there?"
> Did you try doing a remote bind copy?
> On z/OS
> "> I've created aliases to the remote tables I need and can
> > through SPUFI.
> You'll probably find that whoever installed / migrated Db2
> DSNTISG job and bound
> the SPUFI packages on the remote database.
> James Campbell
> On 1 Jul 2020 at 16:58, Philip Nelson wrote:
> > Folks,
> > I've got to write a stored procedure which processes data
in a local Db2
> > for z/OS subsystem and also in a number of remote Db2 for
> > I've created aliases to the remote tables I need and can
> > through SPUFI.
> > I create a stored procedure which tries to read from the
> > The SP deploys but when I try to run it I get a -805
(package missing) on
> > the remote server.
> > Is it actually possible to use an alias to a remote LUW
table from a z/OS
> > native SQL stored procedure?
> > If so, how do I get the package I need out there?
> > Phil
> This email has been checked for viruses by AVG.
> -----End Original Message-----