Skip to main content
2 of 2
improve formatting
Julien Vavasseur
  • 10.2k
  • 2
  • 28
  • 46

I guess it's a locking issue.

While such inserts take so long use admin view below. The column HLD_CURRENT_STMT_TEXT shows the blocker statement (what cause the insert took so long):

db2 select * from SYSIBMADM.MON_LOCKWAITS