IDS Forum

Re: Fast recovery slow

Posted By: John Miller iii
Date: Monday, 22 February 2016, at 3:53 p.m.

In Response To: Re: Fast recovery slow (MARK SCRANTON)

A very simple way to re-create this is to

1. create a table

2. do a checkpoint

3. load X million rows of data and commit

4. kill the engine (before the next checkpoint)

5. start the engine. Fast recovery has to replay the x million r= ow

load.

For this exact reason we created RTO=5FSERVER=5FRESTART

# RTO=5FSERVER=5FRESTART - Specifies, in seconds, the Recovery Time

# &= nbsp; Objective for Informi= x restart after a

server

# &nbs= p; &= nbsp; failure. Acceptable values are 0

(off) and

# &nbs= p; &= nbsp; any number from 60-1800,

inclusive.

John F. Miller III

STSM, Lead Architect

miller3@us.ibm.com503-747-1366

IBM Informix Dynamic Server (IDS)

----- Original message -----

From: "MARK SCRANTON" <mark@marks= cranton.com>

Sent by: ids-bounces@iiug.org

To: ids@iiug.org

Cc:=

Subject: Re: Fast recovery slow [36600]

Date: Mon, Feb 22, 2016 11:3= 4 AM

Roger -

My apologies...I thought you were saying that recovery = was slow but

it didn't

complete. So my dissertation on getting stuck fas= t recovery is just

good

education now. ;)

I see that it did compl= ete (due to the "online mode" message. I

would think

that the section wh= ere I talked about transactions being applied

taking a long

time is norm= al and expected. I don't see any that got rolled back so

that

didn't add= to the time (unless the msg log was cut out for brevity).

Many

factors = come into play here - disk I/O, horsepower of engine, load

on the

system= , etc. Heavy transactions get killed due to the engine

stopping will

alw= ays take "some time" depending on items above.

Let me know if you ha= ve anymore questions. Fun topic.

Thanks -

Mark Scranton

The Ma= rk Scranton Group

mark@markscranton.com

*********************=

**********************************************************

F= orum Note: Use "Reply" to post a response in the discussion

forum. <= br>

Messages In This Thread

• Fast recovery slow
  ROGER VILCA -- Tuesday, 9 February 2016, at 8:43 p.m.
  • Re: Fast recovery slow
    MARK SCRANTON -- Thursday, 18 February 2016, at 3:57 p.m.
    • Re: Fast recovery slow
      ROGER VILCA -- Monday, 22 February 2016, at 11:49 a.m.
      • Re: Fast recovery slow
        MARK SCRANTON -- Monday, 22 February 2016, at 2:33 p.m.
        • Re: Fast recovery slow
          John Miller iii -- Monday, 22 February 2016, at 3:53 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.