COUNT is not working

David Beckham · New User Joined: 04 Apr 2008 Posts: 14 Location: Chennai

Dear all,

In our Db2 environment Count(*) SQL Query is not working properly. For some tables it's giving the actual no rows. for some tables it's showing 0 rows. It's not retriving the actual no of rows present in the table.

Cound Anyone help me to resolve this problem?

Regards,
David.

UmeySan · Posted: Tue Jul 01, 2008 1:15 pm Post subject:

Hi !

Could it be possible, that this depends on the WhereClause ???

dbzTHEdinosauer · Posted: Tue Jul 01, 2008 1:39 pm Post subject:

Where clause? Which Where clause? If the OP truely wants a row count, the sql should contain NO where clause.

am_ne · New User Joined: 24 Mar 2007 Posts: 25 Location: Bangalore

David Beckham · New User Joined: 04 Apr 2008 Posts: 14 Location: Chennai

Hi,

Actually i don't give any WHERE clause in the COUNT Query. I am just executing a simple query SELECT COUNT(*) FROM <table name>. The rows are there in table, still it showing 0 rows in the result. When i execute SELECT * FROM <table name>. It's retriving the rows. Anything is there to do with Reorg or Rebuild Index?

Thank you,
Regards,
David

am_ne · New User Joined: 24 Mar 2007 Posts: 25 Location: Bangalore

David Beckham · New User Joined: 04 Apr 2008 Posts: 14 Location: Chennai

Hi,

Is there any way to identify which access path the COUNT Query is choosing? How to make the COUNT Query to do Tablespace scan.

Thanks for your help.

Regards,
David.

prakash271082 · Active User Joined: 09 Sep 2005 Posts: 61

Hi,

One simple thing is that you can drop any indexes present in the table. So that it does Tablespace scan by default.

dbzTHEdinosauer · Posted: Wed Jul 02, 2008 1:11 pm Post subject:

indexes have nothing to do with a query that has no where clause.

suggest your problem is elsewhere. besides, we have not seen the sql.

David Beckham · New User Joined: 04 Apr 2008 Posts: 14 Location: Chennai

After running Rebulid Index, Count Query is working fine.

Thanks for your support.
______
David

dbzTHEdinosauer · Posted: Tue Jul 08, 2008 3:01 pm Post subject:

such BS!

stodolas · Posted: Tue Jul 08, 2008 6:44 pm Post subject:

agreed

Anuj D. · Posted: Wed Jul 09, 2008 1:23 pm Post subject:

What is BS here..? (Basic Stuff..by any chance..?)

dick scherrer · Posted: Wed Jul 09, 2008 8:03 pm Post subject:

Hi Anuj,

Anuj D. · Posted: Thu Jul 10, 2008 12:00 pm Post subject:

Hi Dick,

Yeah, I got a PM explaing the meaning..that was lil different..but was intresting..