IDS Forum

Re: Reverting from 11.X -> 10.X using onmode -b do

Posted By: Art Kagel
Date: Monday, 13 July 2009, at 6:31 p.m.

In Response To: Reverting from 11.X -> 10.X using onmode -b does n (Michael Wiggins)

The online log is telling you why it won't revert:

16:05:47 "Database ace_test: Must drop spl/udr (oapi_rp_cc_and_pin)
before attempting reversion"

16:05:48 "Database ace_test: Must drop spl/udr (iol_update_rp_pin)
before attempting reversion"

16:05:49 "Database ace_test: Must drop spl/udr (iol_check_pin_exp)
before attempting reversion"

16:05:50 "Database ace_test: Must drop spl/udr (oe_upd_pin_exp) before
attempting reversion"

16:05:51 "Database ace_test: Must drop spl/udr (oe_upd_pin) before
attempting reversion"

16:05:52 "Database ace_test: Must drop spl/udr (f_company_by_emp)
before attempting reversion"

16:05:53 "Database ace_test: Must drop trigger (tr_ownere_update)
before attempting reversion"

16:05:54 Database ace_test is not revertible ...

So, just drop that handful of SPL or UDR routines and the reversion will
complete successfully. You can recreate them after the reversion.

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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 Mon, Jul 13, 2009 at 4:25 PM, Michael Wiggins <
michaelwiggins30@comcast.net> wrote:

> Hello,
>
> I am using Informix 10.00.FC9 and upgrading to 11.50.FC4 running AIX
> 5.3. I have noticed a fair amount of users are upgrading to 11.x and I
> am very excited about V11 as well. But I am having a bit of a problem
> in all of the environments when trying to revert back to V10 using the
> onmode -b 10.00 command. I read online where I must use
> LOG_INDEX_BUILDS = 0 in my configuration file but it doesn't seem to
> work. So I am reaching out to the INFORMIX world to see if anyone else
> is having this problem because I am using very VLDB databases and
> restores are really not an option in all test environments. Please advise.
>
> 16:04:55 Checkpoint Completed: duration was 1 seconds.
>
> 16:04:55 Mon Jul 13 - loguniq 36802, logpos 0x4ea7018, timestamp:
> 0xc715e8c5 Interval: 4289
>
> 16:04:55 Maximum server connections 0
>
> 16:04:55 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked 0, Plog used 2, Llog used 1
>
> 16:04:55 On-Line Mode
>
> 16:04:56 SCHAPI: Started dbScheduler thread.
>
> 16:04:56 Booting Language <spl> from module <>
>
> 16:04:56 Loading Module <SPLNULL>
>
> 16:04:56 SCHAPI: Started 2 dbWorker threads.
>
> 16:05:32 SCHAPI: thread dbWorker2 task mon_config_startup(3-12)
> shutting down
>
> 16:05:32 SCHAPI: thread dbScheduler task mon_checkpoint(0-217) shutting
> down
>
> 16:05:32 SCHAPI: thread dbWorker1 task mon_sysenv(4-12) shutting down
>
> 16:05:34 Shutdown Mode
>
> 16:05:35 Quiescent Mode
>
> 16:05:36 Checkpoint Completed: duration was 0 seconds.
>
> 16:05:36 Mon Jul 13 - loguniq 36802, logpos 0x4ed8018, timestamp:
> 0xc715ef28 Interval: 4290
>
> 16:05:36 Maximum server connections 0
>
> 16:05:36 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> blocked 0, Plog used 15, Llog used 49
>
> 16:05:37 Reversion to version 10.00 Started
>
> 16:05:37 Reverting Partition Header Pages Started
>
> 16:05:41 Reverting Partition Header Pages Succeeded
>
> 16:05:41 Beginning process of reverting system to 10.00 ...
>
> 16:05:43 Conv/rev: Started check phase of reversion for component HA
>
> 16:05:44 On-Line Mode
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component HA
>
> 16:05:45 Conv/rev: Started check phase of reversion for component SCHAPI
>
> 16:05:45 calling schapi_cvr1150_check_revertable
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component SCHAPI
>
> 16:05:45 Conv/rev: Started check phase of reversion for component SECURE
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component SECURE
>
> 16:05:45 Conv/rev: Started check phase of reversion for component RTREE
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component RTREE
>
> 16:05:45 Conv/rev: Started check phase of reversion for component PLOAD
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component PLOAD
>
> 16:05:45 Conv/rev: Started check phase of reversion for component BAR
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component BAR
>
> 16:05:45 Conv/rev: Started check phase of reversion for component SMI
>
> 16:05:45 Conv/rev: Finished check phase of reversion for component SMI
>
> 16:05:45 Conv/rev: Started check phase of reversion for component SQL
>
> 16:05:46 Quiescent Mode
>
> 16:05:46 processing ace_test
>
> 16:05:46 Checking database ace_test for revertibility ...
>
> 16:05:47 "Database ace_test: Must drop spl/udr (oapi_rp_cc_and_pin)
> before attempting reversion"
>
> 16:05:48 "Database ace_test: Must drop spl/udr (iol_update_rp_pin)
> before attempting reversion"
>
> 16:05:49 "Database ace_test: Must drop spl/udr (iol_check_pin_exp)
> before attempting reversion"
>
> 16:05:50 "Database ace_test: Must drop spl/udr (oe_upd_pin_exp) before
> attempting reversion"
>
> 16:05:51 "Database ace_test: Must drop spl/udr (oe_upd_pin) before
> attempting reversion"
>
> 16:05:52 "Database ace_test: Must drop spl/udr (f_company_by_emp)
> before attempting reversion"
>
> 16:05:53 "Database ace_test: Must drop trigger (tr_ownere_update)
> before attempting reversion"
>
> 16:05:54 Database ace_test is not revertible ...
>
> 16:05:55 processing dps_persist
>
> 16:05:55 Checking database dps_persist for revertibility ...
>
> 16:05:56 Database dps_persist is revertible ...
>
> 16:05:57 processing stores
>
> 16:05:57 Checking database stores for revertibility ...
>
> 16:05:59 Database stores is revertible ...
>
> 16:06:00 Conv/rev: Failed in check phase of reversion for component SQL
> 16:06:00 Conv/rev: Started check phase of reversion for component RSAM
> 16:06:00 Reverting Secondary Partition Header Pages Started
>
> 16:06:11 Reverting Secondary Partition Header Pages Succeeded
>
> 16:06:11 Conv/rev: Finished check phase of reversion for component RSAM
>
> 16:06:11 Reversion cancelled.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001636c5b2f0383be4046e9de209

Messages In This Thread

• Reverting from 11.X -> 10.X using onmode -b does n
  Michael Wiggins -- Monday, 13 July 2009, at 4:25 p.m.
  • Re: Reverting from 11.X -> 10.X using onmode -b do
    Art Kagel -- Monday, 13 July 2009, at 6:31 p.m.
  • Re: Reverting from 11.X -> 10.X using onmode -b do
    John Miller iii -- Monday, 13 July 2009, at 7:57 p.m.
    • Re: Reverting from 11.X -> 10.X using onmode -....
      Michael Wiggins -- Tuesday, 14 July 2009, at 5:47 p.m.
      • Re: Reverting from 11.X -> 10.X using onmode -....
        John Miller iii -- Friday, 17 July 2009, at 3:52 a.m.
      • Re: Reverting from 11.X -> 10.X using onmode -....
        KEN KWAN -- Wednesday, 22 July 2009, at 1:32 p.m.
        • Re: Reverting from 11.X -> 10.X using onmode -....
          Michael Wiggins -- Wednesday, 22 July 2009, at 2:37 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.