Skip to Content
avatar image
Former Member

SWPM Import running phase:Alter tables volatile

Hi,

While importing ABAP application in AIX environment for DB2 database, we are in phase where system in ALTER TABLES VOLATILE mode from last 10 hours. During this we see that query is in progress in db2top, but nothing in log area of installation.

DB2top

Application Cpu% IO% Mem% Application Application Delta Delta Delta Delta Delta Sess Assoc. Paral. Lockwait
Handle(Stat) Total Total Total Status Name RowsRead/s RowsWritten/s IOReads/s IOWrites/s TQr+w/s Memory Agents Degree (sec)
------------ ------- ------- ------- ----------------------------------- --------------- -------------- -------------- -------------- -------------- -------------- -------- ------ ------ --------
10(c) 0.00% 0.00% 6.06% Connected db2bp 0 0 0 0 0 512.0K 1 0 0
49(?) 0.00% 100.00% 13.64% Compiling SQL Stmt db6util 0 0 757 0 0 1.1M 1 1 0
1859(i) 0.00% 0.00% 6.82% UOW Waiting in the application db2bp 0 0 0 0 0 576.0K 1 1 0

Is this expected output or should we try something else as well.

Please check and guide us to fix this.

Thanks and Regards,

Rajesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 02, 2017 at 02:49 AM

    I am able to fix this issue. We have killed those db6util processes and then restarted the import.

    Add comment
    10|10000 characters needed characters exceeded