reason code 3 plz advice

i am trying to run a select count(*) from dim_order and its giving me reason code 3 error can u plz advise why and aht should i do to rectify it?
SQL0668N  Operation not allowed for reason code "3" on table
"DB2ADMIN.DIM_ORDER".  SQLSTATE=57016


 1 The table is in Check Pending state.  The integrity of the    
table is not enforced and the content of the table may be        
invalid.  An operation on a parent table or an underlying table  
that is not in a check pending state may also receive this error  
if a dependent table is in a check pending state.  

 2 The table is in No Data Movement state. When in this state,    
operations that cause data movement are disallowed. Data movement
operations include REDISTRIBUTE, update of partitioning key,      
update of multi-dimensional clustering key and REORG TABLE.  

 3 The table is in Load Pending state. A previous LOAD attempt on
this table resulted in failure. No access to the table is allowed
until the LOAD operation is restarted or terminated.  

 4 The table is Read Only state. This state can occur during      
on-line LOAD processing (LOAD INSERT with the READ ACCESS option),
or after an on-line LOAD operation, but before all constraints    
have been validated in the newly appended portion of the table    
using the SET INTEGRITY statement. No update activity is allowed  
on this table.  

 5 The table is in Load In Progress state. The LOAD utility is    
currently operating on this table, no access is allowed until the
LOAD is finished.  

 6 Materialized query tables that reference a nickname cannot be  
refreshed in ESE.  

User Response:

 
 

 1 Execute the SET INTEGRITY statement with the IMMEDIATE CHECKED
option on table "<table-name>" to bring the table out of      the
Check Pending state. For a user maintained materialized      
query       table,   execute the statement with the IMMEDIATE    
UNCHECKED         option   instead of   the IMMEDIATE CHECKED    
option.  

 2 Execute REFRESH TABLE statement on the dependent immediate    
materialized query tables and staging tables of table            
"<table-name>". The contents of these dependent immediate    
materialized query tables and staging tables can be incrementally
maintained from the appended data of "<table-name>" through  
previous LOAD INSERT operations.  

 3 Restart or terminate the previously failed LOAD operation on  
this table by issuing LOAD with the RESTART or TERMINATE option  
respectively.  

 4 Issue the LOAD QUERY command to check whether the table is in  
the process of being loaded. If yes, wait until the LOAD utility  
has completed, or if necessary, restart or terminate previously  
failed LOAD operation. If LOAD is currently not in progress,      
issue the SET INTEGRITY command with the IMMEDIATE CHECKED option,
to validate constraints in the newly loaded portion of the        
table.  

 5 Wait until the current LOAD operation has finished. You can    
use the LOAD QUERY command to monitor the progress of load.  

 6 Define a materialized query table using the MAINTAIN BY USER  
option. Then, use an INSERT statement with a subquery to populate
the materialized query table.  

 sqlcode :  -668

 sqlstate :  57016



thanks
bobby