Posting from the Informix-list 
Author Message
 Posting from the Informix-list

Hi,

I upgraded my Informix server from 7.31 to 9.21 this weekend. There is NO error error messages in  message log (online.log) during the installation. Afterwards, I executed a command " update statistics high on sysmaster" with LTAPEDEV set to /dev/null
based on the tutorial material presented by Mr. Carlton Doe in this year's IBM Informix Conference. The error message are follows:

243:Could not position within a table (informix.syscrtadt)
158: ISAM error: Operation disallowed on SMI pseudo table

Now the output of "oncheck -pe " has error message "ERROR: Missing pages between 3517 and 3527", There was NO error from the same command just before today's upgrade. Besides, the "update statistics ...."outputs from Art Kagel scripts will NOT run now. I
still can run commands:"update statistics low drop distributions" & "update statistics medium distributions only" on the dbaccess command line.

How serious is the problems with missing pages and how to fix it? Why I can run "update statistics" on the whole database, but NOT individual tables?

Thanks for your help in advance and Merry Christmas & Happy New Year !!!!!

Best Regards,

Kenneth Ma



Fri, 11 Jun 2004 07:22:42 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Posting from the Informix-list

2. Posting from the Informix-list

3. Posting from the Informix-list

4. Posting from the Informix-list

5. Posting from the Informix-list

6. Posting from the Informix-list

7. Posting from the Informix-list

8. Posting from the Informix-list

9. Posting from the Informix-list

10. Posting from the Informix-list

11. Posting from the Informix-list

12. Posting from the Informix-list


 
Powered by phpBB® Forum Software