IDS Forum

Re: truncate logical log

Posted By: TILMAN MODEL-BOSCH
Date: Monday, 16 April 2007, at 10:38 a.m.

In Response To: Re: truncate logical log (PAUL GATHOGO)

Ok thrid attempt - now via WEB interface :
sorry for the MIME repsonses - don't know what happend,

Seems Notes did cream my previous replies somehow :-(

Don't knoew what happend

> Thanks for this info, but i still belive they should try document ways of

> fixing this issue or resolving?

Documented way of fixing/resolving the issue is a restore .

> I have a very bad feeling about problems that have to resolved via support

> team, reason is this might take long and have a prolonged downtime, am just

> lucky becouse i was attempting to migrate my data to this new

> enviroment when

> all this happened!

I agree that the need to invlove support is always unwanted - any

problem you can
fix yourselve is probably fixed much faster.

How did you migrate your IDS DBspaces and chunks ?

I assume you did copy all the chunks to the new environment?

Are you positive IDS was offline or write-blocked at the time the

copy was taken ?

If not - that would explain the error .

> I see on your mail you have suggested to restore the given dbspaceor table,

> but when this problem happens how would i know which dbspace or table is

> failing?

The af.file should give you a hint which table/dbspace is affected.

You could also set ONDBSPACEDOWN to 0 , IDS should come online and

the affected DBspace will be offline. (provided it was not a critical dbspace)

(review IDS documentation for ONDBSPACEDOWN at
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp

> Last how do i engage the IBM team for support? becouse i have a

> feeling this

> might happen again.

You may open an Electronic Service Request via

http://www-306.ibm.com/software/support/probsub.html

This requires you do have a valid maintenance contract.

More info on Informix Support can be found here:

http://www-306.ibm.com/software/data/informix/support/

HTH
Tilman

Messages In This Thread

• truncate logical log
  PAUL GATHOGO -- Sunday, 15 April 2007, at 9:01 a.m.
  • Re: truncate logical log
    Tilman Model-Bosch -- Monday, 16 April 2007, at 5:56 a.m.
    • Re: truncate logical log
      PAUL GATHOGO -- Monday, 16 April 2007, at 8:28 a.m.
      • Re: truncate logical log
        Tilman Model-Bosch -- Monday, 16 April 2007, at 9:03 a.m.
        • Re: truncate logical log
          ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 16 April 2007, at 9:16 a.m.
          • RE: truncate logical log
            Gentsch, Samuel -- Monday, 16 April 2007, at 9:37 a.m.
      • Re: truncate logical log
        Tilman Model-Bosch -- Monday, 16 April 2007, at 10:01 a.m.
      • Re: truncate logical log
        TILMAN MODEL-BOSCH -- Monday, 16 April 2007, at 10:38 a.m.
  • Re: truncate logical log
    Jonathan Leffler -- Tuesday, 17 April 2007, at 12:08 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.