-802 error for count(*) query for a DB2 table

[srilata83]

Hi,
I am trying to query a big table which contains huge data,I just tried to check the no of records of table, i have run the query for COUNT(*) in QMF, But i am not getting the result , i am getting an error -802 ,saying commit frequency must be greater than zero.
Is there any way of getting the count?
I tried in platinum tool also, but its N/A over there in 'No. of rows' field.

Please help me in this regard.

[dbzTHEdinosauer]

i am getting an error -802 ,saying commit frequency must be greater than zero

Don't know who told you that, but you are being mislead.

use the IBM LookAt site.

this link provides the explanation for a neg 802 sqlcode.

[Anuj Dhawan]

In addition to what Dick has suggested, please show us the query you use and the error messages.

[srilata83]

Hi,
My problem is solved now.
Actually the result of my query (i.e. No.of records in my table ) is out of range, it was crossing the limit ,so i was getting -802 error.
Now i modified the query as COUNT_BIG(*) and getting the actual result.

Thanks......

[Anuj Dhawan]

That's nice, thanks for letting us know the final solution you used.