var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Data loading from DB2 UDB to DB2/MVS
What is the best method to load data(from few tables) on DB2 UDB (v8/AIX) to DB2 on MVS (Not sure about version #) ?
Can we create a federated link on MVS side to do a cursor load ?
It depends on your site policies and the volume of data:
If the data volume is small, then you can export data to ixf/del files and do import to the zos. Note, you need DB2 Connect license to do this.
You can create "federated" link(called DDF on zos, iirc) from the zos to the luw, and then do "insert into...select from " or load from cursor.
you can create a federated link from luw to zos and issue insert into ..select * from ..
you can "export" the data from luw to fixed width files, ftp over to mainframe and run the LOAD utility.
Visit the new-look IDUG Website
, register to gain access to the excellent content.
you may find this redbook helpful:
IBM Redbooks | Moving Data Across the DB2 Family
It covers moving data between DB2 z/OS and DB2 LUW