Re: IDS 10 systables missing
Chris Funderburg wrote:
> Jonathan Leffler wrote:
>
>> funderburg@gmail.com wrote:
>>
>>> After upgrading to 10.00.UC1, I keep getting these errors on *some* of
>>> the databases:
>>>
>>> 311: Cannot open system catalog (sysdirectives).
>>> 135: ISAM error: TBLspace does not exist>>>
>>> Would this be because the databases didn't upgrade properly? If so,
>>> short of downgrading the database and restoring a backup, is there any
>>> way I can create that table manually?
>>>
>>> Running "oncheck -cD" is equally unhelpful. It returns:
>>>
>>> TBLspace data check for cell:informix.sysdirectives
>>> Error opening TBLspace sysdirectives.
>>>
>>> Any ideas?
>>
>>
>>
>> As Neil said - worrying. One possibility is that the upgrade didn't
>> complete properly. What does the online log file say?
>>
>> Contact IBM/Informix Tech Support.
>>
>
> The log's gone now as I cleared it, but basically:
>
> Converting foo.
> Finished converting foo.
> Converting bar.
> Finished converting bar.
> Converting somethingelse
>
> And it never said finished.
>
> But I'm not too sure that's the problem as the error is occuring in a
> database that I *know* finished converting.
>
Try :
oncheck -pe
oncheck -cc
TBP wrote:
> Chris Funderburg wrote:
>> Jonathan Leffler wrote:
>>
>>> funderburg@gmail.com wrote:
>>>
>>>> After upgrading to 10.00.UC1, I keep getting these errors on *some* of
>>>> the databases:
>>>>
>>>> 311: Cannot open system catalog (sysdirectives).
>>>> 135: ISAM error: TBLspace does not exist>>>>
>>>> Would this be because the databases didn't upgrade properly? If so,
>>>> short of downgrading the database and restoring a backup, is there any
>>>> way I can create that table manually?
>>>>
>>>> Running "oncheck -cD" is equally unhelpful. It returns:
>>>>
>>>> TBLspace data check for cell:informix.sysdirectives
>>>> Error opening TBLspace sysdirectives.
>>>>
>>>> Any ideas?
>>>
>>>
>>>
>>> As Neil said - worrying. One possibility is that the upgrade didn't
>>> complete properly. What does the online log file say?
>>>
>>> Contact IBM/Informix Tech Support.
>>>
>>
>> The log's gone now as I cleared it, but basically:
>>
>> Converting foo.
>> Finished converting foo.
>> Converting bar.
>> Finished converting bar.
>> Converting somethingelse
>>
>> And it never said finished.
>>
>> But I'm not too sure that's the problem as the error is occuring in a
>> database that I *know* finished converting.
>>
>
> Try :
>
> oncheck -pe
> oncheck -cc
Hmmm. These are my databases:
sysuser
systest
sysspin
syscell
cell
central
onpload
At the moment the central on onpload database are getting the errors.
oncheck -pe proves the error:
[informix@cupid ~]$ oncheck -pe | grep sysdirectives
sysmaster:'informix'.sysdirectives 11717 8
sysutils:'informix'.sysdirectives 12613 8
sysuser:'informix'.sysdirectives 13053 8
systest:'informix'.sysdirectives 26282 8
sysspin:'informix'.sysdirectives 41462 8
syscell:'informix'.sysdirectives 75168 8
cell:'informix'.sysdirectives 149986 8
And:
[informix@cupid ~]$ oncheck -cc central
Validating database central
Validating systables for database central
ISAM error: TBLspace does not exist
And:
[informix@cupid ~]$ oncheck -cd central
{all the other systables}
TBLspace data check for central:informix.sysdirectives
Error opening TBLspace sysdirectives.