Hi all,
during our publications on DB2, we found the process before writing data is too slow.
On a basic mapping of 3 tables with 100 iterations the elapsed time is 7 minutes, 90% of which in "preparing data".
DBAs investigated with a trace tool on DB2 and they found some errors due to OWNER not existing in DB (PBCATOWN, SYSCAT).
We know SYSCAT is a DB2 LUW's OWNER, however we use a DB2 Z/os version.
Is there a way to disable the interrogation to these objects? How can we speed publications?
Thanks,
Anna