Access AS400 Db2 from ZOS DB2

Michael Kaminski

Access AS400 Db2 from ZOS DB2

We have a need to access data from an outside client which resides on a
AS400/DB2 platform from our ZOS/DB2 (v7.1) platform. I found some
information on setting up the SYSIBM tables but has anyone setup SPUFI
or QMF? Looks like SPUFI might be straight forward via re-binding to a
collection on the AS400 but QMF appears to be more work. We also had the
need to access information from both machines via one program if

Finally my question is can anyone share any knowledge on how to perform
these tasks.

Thanks in Advance

Mike Kaminski

NOTICE: This e-mail message and all attachments transmitted with it may
contain confidential, sensitive, or protected information intended solely
for the use of the addressee. If the reader of this message is not the
intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or its
attachments is strictly prohibited. If you have received this message in
error, please notify the sender immediately by telephone or by electronic
mail and delete this message and all copies and backups thereof. Thank


* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at