RE: Identifying In-place Alters before IDS upgrade

The script is intended to identify Informix tables, which contain multiple versions due to in-place ALTER commands. All rows in these tables may need to be upgraded the current "version" before you upgrade to a newer Informix version. Such changes are required before you can revert to an older Informix version. An "oncheck -pT <database>:<table>" command can be run against each of the identified tables to learn how many rows are using each version of the table format. The following sources provide more information on Informix in-place ALTER command: 1) Performance Guide for Informix Dynamic Server 2) Informix release notes at $INFORMIXDIR/release/en_us/0333/MIGRATEDOC_7.3. 3) http://www.markscranton.com/informix/monthly_topic.htm#January 25, 1999 In your case, it appears that one or more of the WHERE clauses in the script is not functioning properly. I really doubt that ALTER commands have been run against 8,000 of your database tables. Rick -----Original Message----- From: Richard Spitz [mailto:Richard.Spitz@ana.med.uni-muenchen.de] Sent: Friday, October 20, 2000 00:08 To: informix-list@iiug.org Subject: Re: Identifying In-place Alters before IDS upgrade "Bernstein, Rick" wrote: > > Informix Technical Support (case 200515) provided me with the following > script to identify outstanding > "in-place ALTERs". It runs quickly, even with 9,000+ SAP tables. Thanks for providing us with that script. However, I don't know how to interpret it's output. When I run it, it prints an endless list of table names like this: (expression) pg_pagenum pg_physaddr (expression) tabname 0x00100001 145 1054650 0x00100001 TBLSpace 0x00100001 145 1054650 0x00100002 sysdatabases 0x00100001 145 1054650 0x00100003 systables 0x00100001 145 1054650 0x00100004 syscolumns 0x00100001 145 1054650 0x00100005 sysindexes 0x00100001 145 1054650 0x00100006 systabauth 0x00100001 145 1054650 0x00100007 syscolauth 0x00100001 145 1054650 0x00100008 sysviews 0x00100001 145 1054650 0x00100009 sysusers and so on ad infinitum (more than 8000 lines). What does that mean? This is on IDS 7.31UC4X1 on Siemens Reliant Unix 5.43. Regards, Richard -- +-----------------------------+-------------------------------------+ | Dr. med Richard Spitz | Mail: spitz@ana.med.uni-muenchen.de | | Klinik f'r Anaesthesiologie | Tel : +49-89-7095-6110 | | Klinikum der Univ. M'nchen | FAX : +49-89-7095-6420 | | 81366 M'nchen, Germany | GSM : +49-172-8933578 | +-----------------------------+-------------------------------------+