Problems with upgrade from 7.31 to 9.21 
Author Message
 Problems with upgrade from 7.31 to 9.21

Hi,

This is the second message of my problem:

After I removed routines: oldsystdist & remove_jar_undeplo from the "update statistics ..." created by Art Kagel's script, I have NO problem to run the job. But I am still concerned with the 'missing pages .....' output from command "oncheck -pe".

Thanks for your help again !!!!!

Best Regards,

Kenneth Ma

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:54:46 GMT
 Problems with upgrade from 7.31 to 9.21

Quote:

> Hi,

You may have an older copy of dostats!  The upgrade from 7.xx to
9.xx updated an existing system stored procedure with one that works
with the updated system catelog in 9.xx.  However, the old one is
still there just renamed to a weird name.  The older versions of
dostats could not handle that procedure and so failed.  It would
work fine on a scratch 9.xx installation but not on an upgraded one.
Get the latest utils2_ak which has special code to avoid this
problem in upgraded instances.

As to the other problem, I don't know.

Art S. Kagel

Quote:
> This is the second message of my problem:

> After I removed routines: oldsystdist & remove_jar_undeplo from the "update statistics ..." created by Art Kagel's script, I have NO problem to run the job. But I am still concerned with the 'missing pages .....' output from command "oncheck -pe".

> Thanks for your help again !!!!!

> Best Regards,

> Kenneth Ma

> 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



Mon, 14 Jun 2004 05:49:42 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Upgrade 7.31 to 9.21

2. Upgrade from 7.31 to 9.21

3. Upgrade 7.31 TC5 ==> 9.21 Tc 3

4. IDS 7.31 -> IDS.2000 9.21 upgrade

5. Performance Degradation IDS 7.31 to 9.21

6. Migration from 7.31 to 9.21 ERROR 1226

7. FW: Migration from 7.31 to 9.21 ERROR 1226

8. IDS.2000 9.21 + IConnect + ISQL 7.31

9. IDS 9.21 Upgrade/Performance Problems

10. problem w/ query after upgrade to 7.31

11. Days(360)...and problems with upgrade form 7.31 to 9.20

12. 7.31 upgrade problems


 
Powered by phpBB® Forum Software