Oppolzer - Informatik / Blog

Yes. We have some batch programs that read data from DB2 LUW
and move them to a mainframe based table system. The data came
from mainframe DB2 some years before, but management decided that
the table creation process has to be moved to DB2 LUW (using some
Java GUI), and so the existing batch programs (written in C) that read the
DB2 data and build the (operative) table data simply was rebound to
the DB2 LUW database.

Another program which has to be treated the same way was a comparison
tool which compared the operative table data on the mainframe with the
DB2 LUW data on the Linux server (just to make sure if the deploying was
OK).

The were two major issues:

a) the subsystem names to do the CONNECTs to had only 4 chars (which was
OK for the mainframe DB2s, but this had to be extended to 8 chars for the
LUW subsystem names) - the subsystem names are (optional) JCL parameters
to the programs (keyword parameters with defaults) - they had to be expanded
in size.

b) the LUW subsystems had ASCII charset, so there were some issues with
ORDER BY. Although the ordering on the target table system (on the mainframe)
is the same, of course, the comparison tool had some problems, because it
used ORDER BY on the DB2 side to guarantee the same ordering as on the
mainframe table side, and this didn't work with the ASCII DB2 tables on LUW.
So we had to change the ORDER BY clauses in the comparison program
to get an EBCDIC ORDERing even on the ASCII tables of DB2 LUW.
This was possible by ordering some hex representation of the data - using
HEX(TRANSLATE(...)).

Kind regards

Bernd



Am 18.06.2013 20:52, schrieb D.K.:
>
> Hello,
>
> Has anyone set up a connection from DB2 on the mainframe to a DB2 LUW
> (preferably AIX) database? I thought DB2 for z/OS had everything to
> connect remotely as long as the communication database entries were
> set up correctly? This could be a read or even merge (upsert) from
> DB2 z/OS to DB2 LUW, not just a load using cross-loader. Thanks!
>
>
> ------------------------------------------------------------------------
>