User tried to migrate data from db2 v 8.1 FP13 to DB2 v9.7 and got hang up at query for tablespace. See attachment . User could run export/import the table successful.
User also monitored from Spotlight and found the SQL running at the moment.
User was waiting on the transaction for 1/2 hour. He had to cancel to get out of toad but the transaction still running until being forced.
STATUS
Waiting for a fix with CR 81,885 on a future release of Toad for DB2.
WORKAROUND:
Use Export/Import utilities.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center