Skip to Content
0

SWPM Import running phase:Alter tables volatile

Sep 01, 2017 at 08:42 AM

67

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded