Just finished up testing import/export with DB2 for Z. First step is to copy jdbc driver into your sqoop/lib dir.  With a 10 system cluster running and having an index on column C1 I was able to use 9 maps for parrallelism.  Also the options below make sqoop use the generic jdbc driver, we aren't using the DB2 specifc connector which is for LUW only.  My import from DB2 Z into hadoop looked like:   sqoop import --driver com.ibm.db2.jcc.DB2Driver --connect jdbc:db2://192.168.1.1:59000/DB2LOC1 --username SYSADM --password password --table SYSADM.TB1  --split-by C1 --target-dir "/user/biadmin/1GBTBL" -m 9     ... View more