Have you ever had a situation where you needed to load data
into a DB2 table, but the file with the data was not on the mainframe? So you
had to PTF that data to the mainframe and then load it.
Well, with DB2 12 for z/OS you get a new
capability to load the data to the mainframe without moving the file. The DRDA fast
load feature provides you with an efficient way to load data to DB2 for z/OS tables
from files that are stored on distributed clients.
The DNSUTILU stored procedure can be
invoked by a DB2 application
program to run DB2 online utilities. This
means that you can run an online LOAD utility using DSNUTILU. Before loading remote
data, you must bind the DSNUT121 package at each location where you will
be loading data. A local package for DSNUT121 is bound by installation job DSNTIJSG
when you install or migrate to a new version of DB2 for z/OS.
The DB2 Call Level Interface APIs and
Command Line Processor have been enhanced to support remote loading of data to
DB2 for z/OS. They have been modified to stream data in continuous blocks for
loading. This feature is supported in all DB2 client packages. The extraction task
for data blocks that passes them to the LOAD utility is 100 percent offloadable
to the zIIP, so the process can result in reduced elapsed time.
This capability is available before activating
new function.
