View previous topic :: View next topic
|
Author |
Message |
sabyasachi
New User
Joined: 31 Aug 2006 Posts: 3
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You can use SELECT COUNT(*) in your DB2 query. |
|
Back to top |
|
|
harshadeshpande
New User
Joined: 23 Mar 2007 Posts: 5 Location: United States
|
|
|
|
If you have FILEAID tool then give your table name and in the NUMBER OF ROWS QUALIFIED give * |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
If your table is huge, SELECT COUNT(*) may not be preferable.
The SYSIBM.SYSTABLES table has this column:
CARDF
Total number of rows in the table or total number of LOBs in an auxiliary table. The value is -1 if statistics have not been gathered or the row describes a view, alias, or created temporary table. This is an updatable column |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Quote: |
The SYSIBM.SYSTABLES table has this column: |
In that case, you may have to check the STATS time. when is the last time statistics was taken. If there is some real time activity against this tables, then this count may not be accurate. |
|
Back to top |
|
|
|