IDS Forum

Re: Imported db restore filling rootdbs

Posted By: Art Kagel
Date: Wednesday, 22 August 2012, at 12:34 p.m.

In Response To: Imported db restore filling rootdbs (jpierrot@chubb.com)

Place a file named "stop" in $INFORMIXDIR/etc/sysadmin that will prevent
any tasks from running when you start the restore. If you want tasks
running, you can shutdown the server after the restore completes and has
been first brought fully online to complete the recovery process, delete
the stop file, and restart the server without it in place.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Wed, Aug 22, 2012 at 12:23 PM, jpierrot@chubb.com <jpierrot@chubb.com>wrote:

> Using
> IDS11.5.FC7XO,
> Server : AIX .6.1
>
> Each time I restored an instance I can see an increase in rootdbs size =
> of
> about 40MB or more on the average. Once, rootdbs was filled up right af=
> ter
> the rollforwad of the logs and the instance was blocked. Is this expect=
> ed
> behavior with IDS11.5.FC7X0 ? Has anyone else experienced this ? Resto=
> re
> of the same instance under 7.31.UD8 did not do that, whatever the size =
> of
> the rootdbs while the backup was taken, remained the same after the
> restore. Though this behavior is very different with IDS11.5. Any thoug=
> hts
> or suggestions on this will be greatly appreciated! Contacted IBM suppo=
> rt,
> the tech person's answer to me was not acceptable, for he pointed out "=
> AUS
> 'Automated Update Statistics"
>
> Quote from IBM support " Please be aware that the AUS will activate eve=
> ry
> time the server is initialized unless it is deactivated. This results i=
> n
> evaluation of all the data and updates to the sysadmin database, regard=
> less
> if it was turned on/off on the source server."
> He wanted a test case, can't provide backups due to SOX regulations and=
>
> they contain personal information, that will lead to big violations. Th=
> ey
> did not offer to dial in to diagnose and debug, that sucks to me. Then =
> they
> closed the PMR.
>
> 11:33:48 Dataskip is now OFF for all dbspaces
> 11:33:48 Dropping temporary TBLspace 0x100120, recovering 8 pages.
> 11:33:48 Dropping temporary TBLspace 0x100123, recovering 4 pages.
> 11:33:48 Begin recreating indexes deferred during recovery.
> 11:33:48 Recreating index:
> 'sysadmin:"informix".aus_work_info-aus_work_info_idx1'
> 11:33:48 Checkpoint Completed: duration was 0 seconds.
> 11:33:48 Fri May 18 - loguniq 572607, logpos 0xe72620, timestamp:
> 0x27d6bd4f Interval: 31819
>
> 11:33:48 Maximum server connections 1
> 11:33:48 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns bloc=
> ked
> 0, Plog used 41, Llog used 2
>
> 11:33:48 On-Line Mode
> 11:33:49 Completed recreating indexes.
> 11:33:49 CDR Initialization failed (inactive).
> 11:33:50 SCHAPI: Started dbScheduler thread.
> 11:33:50 Booting Language <spl> from module <>
> 11:33:50 Loading Module <SPLNULL>
> 11:33:50 SCHAPI: Started 2 dbWorker threads.
> 11:33:52 Logical Log 572607 Complete, timestamp: 0x27d6d842.
> 11:33:52 Checkpoint Completed: duration was 0 seconds.
> 11:33:52 Fri May 18 - loguniq 572608, logpos 0x3f018, timestamp: 0x27d6=
> d87c
> Interval: 31820
>
> 11:33:52 Maximum server connections 1
> 11:33:52 Checkpoint Statistics - Avg. Txn Block Time 0.008, # Txns bloc=
> ked
> 0, Plog used 173, Llog used 115
>
> 11:33:53 Logical Log 572607 - Backup Started
> 11:33:53 WARNING: DBspace rootdbs is full
> 11:33:53 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
> 11:33:53 IBM Informix Dynamic Server Version 11.50.FC7XO
> 11:33:53 Who: Session(29, informix@, 0, 7000000331e6548)
> Thread(185, dbWorker3, 7000000331a59b0, 4)
> File: mtex.c Line: 417
> 11:33:53 Action: Please notify IBM Informix Technical Support.
> 11:33:53 stack trace for pid 23593076 written
> to /cbpt0atdb03/opt/app/informix/tmp/af.4a16be1
> 11:33:53 See Also: /cbpt0atdb03/opt/app/informix/tmp/af.4a16be1
>
> I had deactivated AUS on the destination server during the restore and =
> it
> is still happening. This sounds more like a defect to me. The workarou=
> nd
> for future restore were to increase rootdbs on the source instance to a=
> llow
> room for it to grow during the restore. Which to me seems silly.......I=
>
> don't see that as an alternative, while one can be in a situation where=
> you
> have to restore the db unexpectedly. One thing I notice, in that partic=
> ular
> instance, is that the rollforward of the logs contain a lot of recreati=
> ng
> of indexes, due to nightly bacth jobs dropping and recreating indexes t=
> hat
> are logged. Though this practice is not new, it was there under 7.31 wi=
> th
> no negative impact. Is there any change in onbar algorithm between IDS7=
> ..x
> and IDS11.x.
>
> I look forward into reading your much anticipated answers.
>
> Regards,
>
> jp
> =
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--14dae93409039f056f04c7dd4fcf

Messages In This Thread

• Imported db restore filling rootdbs
  jpierrot@chubb.com -- Wednesday, 22 August 2012, at 12:23 p.m.
  • Re: Imported db restore filling rootdbs
    Art Kagel -- Wednesday, 22 August 2012, at 12:34 p.m.
    • Re: Imported db restore filling rootdbs
      jpierrot@chubb.com -- Thursday, 18 October 2012, at 1:29 p.m.
    • Re: Imported db restore filling rootdbs
      Art Kagel -- Thursday, 18 October 2012, at 2:02 p.m.
      • Re: Imported db restore filling rootdbs
        jpierrot@chubb.com -- Thursday, 18 October 2012, at 2:45 p.m.
  • Re: Imported db restore filling rootdbs
    Art Kagel -- Wednesday, 22 August 2012, at 12:37 p.m.
    • Re: Imported db restore filling rootdbs
      Fernando Nunes -- Wednesday, 22 August 2012, at 12:48 p.m.
      • Re: Imported db restore filling rootdbs
        jpierrot@chubb.com -- Thursday, 23 August 2012, at 9:51 a.m.
    • Re: Imported db restore filling rootdbs
      jpierrot@chubb.com -- Thursday, 23 August 2012, at 9:52 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.