When I'm querying in QMF like SELECT COUNT(*) FROM TABLEA WHERE TB_FIELD='US' is fetching more than 100 rows but at the same time when I perform( Db2 Version 7 )Unload thru a job like UNLOAD TABLESPACE databasename.tablespacename FROM TABLEA WHEN TB_FIELD='US' its not fetching rows. Count in job log is zero.
When I perform db2 v7 Unload on any other table with that TB_FIELD='US', they are working fine...
Also when i give Unload like UNLOAD TABLESPACE databasename.tablespacename FROM TABLEA WHEN "some other condition" its pulling rows.
what might be the problem? Can a table be set so that it cannot be unloaded?