Test Data Manager

 View Only

Datamaker publication too slow

  • 1.  Datamaker publication too slow

    Posted Nov 12, 2019 10:55 AM
    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