MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

Hi,

This is something inique problem. We did a database migration ,
the steps used were, DDLs generation, then getting all the DBIDs, OBIDs and all and then then generated DSN1COPY, after which Rebuild index was run.

All went through fine,
But if we make a SELECT (*) on that table we get 0 rows, but if we make SELECT * then all the data is dispalyed, have tried everyhting, running runstats, unloading and loading data. but still the row count is the same.

Any suggestions!!!!!

kolusu · Posted: Thu Dec 04, 2003 1:38 pm Post subject:

Vani,

How is the SELECT COUNT(*) being execueted? Is it via SPUFI/QMF or a program? If it is spufi or qmf make sure that you are pointing to the right DB2 region. you can check if there are any tables existing with the same name.

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

I am executing it to batch Spufi using DSNTEP2 only, and the DB2 region name is the same. i have cross checked it.

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Vani, Are you using SELECT COUNT (*) or just SELECT (*) , just in case its a syntax issue..

Shaik Salauddin · Beginner Joined: 16 Dec 2003 Posts: 3 Topics: 0

Can you please check the value for the column name as CARD in SYSIBM.SYSTABLES and SYSINDEXPART for the table name. If the runstats have run fine it would have updated with proper statistics. Otherwise it will have -1 in them. This is just to confirm whether the statistics have updated properly or not. But irrespective of the value in the card, if we use a count(*) it will result the number of rows.
Hope this may be of littile help...
Thanks,
Shaik