This APAR makes a huge difference.
ERROR DESCRIPTION:
arsdb command import option (-i) performance degradation occurs
due to frequency of commits. Even though the arsdb import code
itself does not issue explicit commits, code elsewhere in arsdb
turns on the ODBC auto-commit setting, a fact that the code to
do the import was not cognizant of. (The auto-commits don't
show up in an ODBC application trace.)
Oops - the title is a bit misleading, don't know how to edit it.
This APAR affects H272741, H272841, H27284A .... in other words, if you're migrating from V2 -> V7 it'll improve table load throughput at that release as well.
PROBLEM DESCRIPTION(S):
PM07633 -
***************************************************************
* USERS AFFECTED: All Content Manager OnDemand for z/OS users
* using arsdb -i
***************************************************************
* PROBLEM DESCRIPTION: arsdb -i can experience long import
* times
***************************************************************
* RECOMMENDATION: None.
***************************************************************
arsdb -i was running with the ODBC autocommit enabled. This
caused a commit to be performed after every insert of a row
into the table being imported.
This code change provides so much improvement it's been marked HIPER:
http://www-01.ibm.com/support/docview.wss?uid=isg1_ODMP710_H272711 (http://www-01.ibm.com/support/docview.wss?uid=isg1_ODMP710_H272711)
R711 PSY UK55884
R84A PSY UK55885
R841 PSY UK55886