oncheck -cc errors with isam errors

Hi, we are implementing a new feature in a test system and were attempting to create an index on a table with no data. It generated a error 214 and 102. Attempts to rename, drop, init in as well as any alter statements results in the same error message. Oncheck -cc generated this output. Is there any actions we can take to remedy the problem or force a drop of the table and associated indexes and constraints? No other oncheck routine is generating errors. Thanks in advance, Doug oncheck -cc ifasdev2: Validating database ifasdev2 Validating systables for database ifasdev2 ISAM error: illegal argument to ISAM function. TBLspace name retwaern Owner bsidba TBLspace number 300654 Tabid 586 Row size 127 Number of columns 20 Number of indexes 2 Number of rows 0 Date created 02/24/2006 TBLspace major version number 587 TBLspace minor version number 18 TBLspace type T Locking level R Number of pages used 0 First extent size 16 Next extent size 16 Flags 0 Site Database name ISAM error: illegal argument to ISAM function. TBLspace name retwaflk Owner bsidba TBLspace number 300657 Tabid 588 Row size 143 Number of columns 9 Number of indexes 1 Number of rows 0 Date created 02/24/2006 TBLspace major version number 588 TBLspace minor version number 11 TBLspace type T Locking level R Number of pages used 0 First extent size 16 Next extent size 16 Flags 0 Site Database name ISAM error: illegal argument to ISAM function. TBLspace name retwa_reported Owner bsidba TBLspace number 300913 Tabid 809 Row size 122 Number of columns 15 Number of indexes 1 Number of rows 0 Date created 02/24/2006 TBLspace major version number 828 TBLspace minor version number 11 TBLspace type T Locking level R Number of pages used 0 First extent size 16 Next extent size 16 Flags 0 Site Database name ERROR: Database ifasdev2 sysfragments has 1885 records, but systables and sysindexes refer to 1884. Validating syscolumns for database ifasdev2 Validating sysindexes for database ifasdev2 ISAM error: illegal argument to ISAM function.

Corruption. Time to restore from archive and run the oncheck again immediately after the restore to verify that the corruption had not happened earlier. Art S. Kagel ----- Original Message ----- From: Doug Fossmeyer <ids@iiug.org> At: 7/13 12:21:22 Hi, we are implementing a new feature in a test system and were attempting to create an index on a table with no data. It generated a error 214 and 102. Attempts to rename, drop, init in as well as any alter statements results in the same error message. Oncheck -cc generated this output. Is there any actions we can take to remedy the problem or force a drop of the table and associated indexes and constraints? No other oncheck routine is generating errors. Thanks in advance, Doug oncheck -cc ifasdev2: Validating database ifasdev2 Validating systables for database ifasdev2 ISAM error: illegal argument to ISAM function. TBLspace name retwaern Owner bsidba TBLspace number 300654 Tabid 586 Row size 127 Number of columns 20 Number of indexes 2 Number of rows 0 Date created 02/24/2006 TBLspace major version number 587 TBLspace minor version number 18 TBLspace type T Locking level R Number of pages used 0 First extent size 16 Next extent size 16 Flags 0 Site Database name ISAM error: illegal argument to ISAM function. TBLspace name retwaflk Owner bsidba TBLspace number 300657 Tabid 588 Row size 143 Number of columns 9 Number of indexes 1 Number of rows 0 Date created 02/24/2006 TBLspace major version number 588 TBLspace minor version number 11 TBLspace type T Locking level R Number of pages used 0 First extent size 16 Next extent size 16 Flags 0 Site Database name ISAM error: illegal argument to ISAM function. TBLspace name retwa_reported Owner bsidba TBLspace number 300913 Tabid 809 Row size 122 Number of columns 15 Number of indexes 1 Number of rows 0 Date created 02/24/2006 TBLspace major version number 828 TBLspace minor version number 11 TBLspace type T Locking level R Number of pages used 0 First extent size 16 Next extent size 16 Flags 0 Site Database name ERROR: Database ifasdev2 sysfragments has 1885 records, but systables and sysindexes refer to 1884. Validating syscolumns for database ifasdev2 Validating sysindexes for database ifasdev2 ISAM error: illegal argument to ISAM function. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.