DB2 v9.5.1 ESE on AIX v6.1
we are deleting many recs from 2 tables in the DB and developers told me they commit only after thousands of deletes. everything is very slow. db2pd shows failure in Archive Status:
db2pd -db prod_db -logs
Logs:
Current Log Number 71
Pages Written 6141
Method 1 Archive Status Failure
Method 1 Next Log to Archive 71
Method 1 First Failure 34
Method 2 Archive Status n/a
Method 2 Next Log to Archive n/a
Method 2 First Failure n/a

Address StartLSN State Size Pages Filename
0x077000002002EF78 0x03D96FF90000 0x00000000 30000 30000 S0000070.LOG
0x077000002047FF38 0x03D9774C0000 0x00000000 30000 30000 S0000071.LOG
0x077000002002FE78 0x03D97E9F0000 0x00000000 30000 30000 S0000072.LOG
0x077000002002FF38 0x03D985F20000 0x00000000 30000 30000 S0000073.LOG
0x077000002001FE38 0x03D98D450000 0x00000000 30000 30000 S0000074.LOG
0x077000002001FEF8 0x03D994980000 0x00000000 30000 30000 S0000075.LOG
0x0770000020487658 0x03D99BEB0000 0x00000000 30000 30000 S0000076.LOG
0x0770000020487718 0x03D9A33E0000 0x00000000 30000 30000 S0000077.LOG
0x07700000204877D8 0x03D9AA910000 0x00000000 30000 30000 S0000078.LOG
0x0770000020487898 0x03D9B1E40000 0x00000000 30000 30000 S0000079.LOG
0x0770000020487958 0x03D9B9370000 0x00000000 30000 30000 S0000080.LOG
0x0770000020487A18 0x03D9C08A0000 0x00000000 30000 30000 S0000081.LOG
0x0770000020487AD8 0x03D9C7DD0000 0x00000000 30000 30000 S0000082.LOG
0x0770000020487B98 0x03D9CF300000 0x00000000 30000 30000 S0000083.LOG
0x077000022EA8FC98 0x03D9D6830000 0x00000000 30000 30000 S0000084.LOG

what does it mean? I can not see anything special in other db2pd outputs or in snapshot outputs. Anything else I could look at to see where the problem is?

thanks in advance

How about db2diag.log?

no problems in the diag.log. Only STMM changing some parameters from time to time
STMM log file (78) removed automatically to maintain space constraint.
"Sheapthres_shr" From: "5000" <automatic> To: "7500" <automatic>
"Sortheap" From: "500" <automatic> To: "750" <automatic>

we have archive logging ON:
(LOGARCHMETH1) = DISK:/dbbackup/<db_name>/offline/

what is the definition of slow?

You can find some info here (Scenario 10):
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

we figured there were not problems with DB2. the query developers were running were extremely unefficient (would take like 26hrs). they re-wrote the query and it runs much faster (10-15mins).