Update daily one row of a whole table

Hi, I need to update one row of a whole table. The row is a daily counter, so it needs to be reset everyday. I need to do this on a very large table (1 to 10 million rows), which exceeds the maximum number of locks available, so a simple UPDATE statement will not do. A table lock will not do either, since this table needs to be accessible while this update is performed. Is there a ready solution for this (either in SQL or ESQL-C ?) with IDS 9.30.UC2 or above ? Thanks, --Jacques--