IDS Forum

Re: oncheck -cc errors with isam errors

Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN
Date: Thursday, 13 July 2006, at 1:25 p.m.

In Response To: oncheck -cc errors with isam errors (Doug Fossmeyer)

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.

Messages In This Thread

• oncheck -cc errors with isam errors
  Doug Fossmeyer -- Thursday, 13 July 2006, at 12:16 p.m.
  • Re: oncheck -cc errors with isam errors
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Thursday, 13 July 2006, at 1:25 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.