Hi - We are using V7.2 on the MainFrame with z/OS

When I issue a SELECT COUNT(*) FROM....

I get a result of 0, when, in fact, there a 2 million rows.

Any ideas????

See what "SELECT COUNT(1) FROM..." gives you.

I don't believe it....you in the right subsystem?

Got the correct sqlid?

What does SELECT * FROM... give you?

If you submit:

SELECT COUNT(*) FROM table-name

it will give you the row count. If you have have anything after the "table-name" then you need to remove it.

Don't try SELECT * FROM table-name on a table with 2 million rows, unless you add SELECT FIRST n ROWS to the end of the statement.

The indexes for this table were corrupt. After I dropped/recreated them, the table was fine. It seems as if the pri/sec qty values were 720 and 720, which is not very much room. So, when an index runs out of room, doesn't DB2 give you some kind of message??????

Check the db2diag.log for error messages.

Newbie

There's no db2diag.log on the mainframe.

Accept my apologies..... I am curious how does a developer know the errors? Anyone?

Newbie

SQL codes will be returned to a COBOL (for example) program, or if using SPUFI (dynamic SQL query tool), the SQL code is returned back to the screen. Also, SQL codes are logged in the console output for the DB2 MSTR region.