I am deleting client using scc5, and now ,it is processing "coepl" . but two days pasted, it is still processing coep.
this table have about 15000000 rows. I have check alert.log, it seems the database is ok. and in AIX OS, I can see many disk
I/O using topas,
in sm50, I can see a work process is running for sequential read and delete coepl, it seems it is still running.
and select count(*) from coepl, the total rows is decreasing.
I do not know whether it is ok that processing coepl such a long time?
Could you give me some advices?
thanks a lot.
Edited by: victor on May 19, 2010 2:15 AM
Edited by: victor on May 19, 2010 2:15 AM
Edited by: victor on May 19, 2010 2:17 AM
Edited by: victor on May 19, 2010 2:24 AM
Edited by: victor on May 19, 2010 2:28 AM