Re: IDS 10 systables missing
Posted in 2005
Neil Truby wrote:
> <funderburg@gmail.com> wrote in message
> news:1121244971.269771.202770@z14g2000cwz.googlegroups.com...
>> 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?
>
> Worrying. Did you raise a tech support case by the way?
>
>
It's logged with our software provider (OpenPSL). I was just hoping
that someone might have seen this before. It's nasty because it won't
even let you drop the database.
Today I restored the whole instance with an ontape backup I made two
weeks ago. It was perfect for an hour. I ran an update statistics on
all the databases and then a completely different database broke.
I've got a funny feeling I'm going to go back to 9.4 until 10.00.UC2
comes along. :-(