dbTalk Databases Forums  

SQL2310N The utility could not generate statistics. Error "-668"was returned.

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss SQL2310N The utility could not generate statistics. Error "-668"was returned. in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kavin
 
Posts: n/a

Default SQL2310N The utility could not generate statistics. Error "-668"was returned. - 04-24-2011 , 06:34 AM






Hi,

I am getting the error when i runstats for a table SQL2310N The
utility could not generate statistics. Error "-668" was returned.
Also The tablespace is 100% full. Is this the reason why runstats is
getting failed? if not how can i analyse the reason why the runstats
got failed.

Thanks
Kavi.

Reply With Quote
  #2  
Old   
Ian
 
Posts: n/a

Default Re: SQL2310N The utility could not generate statistics. Error "-668"was returned. - 04-24-2011 , 07:59 AM






On Apr 24, 4:34*am, kavin <kavinilammur... (AT) gmail (DOT) com> wrote:
Quote:
Hi,

I am getting the error when i runstats for a table SQL2310N *The
utility could not generate statistics. *Error "-668" was returned.
Also The tablespace is 100% full. Is this the reason why runstats is
getting failed? if not how can i analyse the reason why the runstats
got failed.
The -668 error is SQL0668N: "Operation not allowed for reason code
*reason-code* on table *table-name*."

http://publib.boulder.ibm.com/infoce...sql00668n.html

You may have received more information (i.e. the reason code) that you
can use to figure out why your table is inaccessible. If you didn't,
try selecting data from the table and you should get the SQL0668N
error message with more detail.

Most commonly you'll see reason code 1 (table is in set integrity
pending) or reason code 3 (table is in load pending state).

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.