IDS Forum

RE: onmode -b 7.31 to revert back from 9.40

Posted By: Peter_Logan@spartanstores.com
Date: Tuesday, 16 June 2009, at 10:37 a.m.

In Response To: RE: onmode -b 7.31 to revert back from 9.40 (LARRY SORENSEN)

You could do the following ...

begin work;

lock table table_name in exclusive mode;
update table_name ....
commit work;

That will place a table level lock on the table ... You should make sure
you have enough transaction logs ... or you might hit the high water mark
...

Peter

Peter Logan
Senior Database Administrator
Phone: 616/878-8309

From:
"LARRY SORENSEN" <lsorensen25@msn.com>
To:
ids@iiug.org
Date:
06/16/2009 10:05 AM
Subject:
RE: onmode -b 7.31 to revert back from 9.40 [16046]
Sent by:
ids-bounces@iiug.org

2 more questions:

1) I went through the steps listed in the documentation for migration. How

else do I know what in-place alters need to be done before migration?

2) I am receiving the following error while trying to do an in-place
alter:

update claim_d set claim_d.h_msi = claim_d.h_msi
where 1=1;
271: Could not insert new row into the table.

134: ISAM error: no more locks
I have changed the LOCK MODE to PAGE from ROW and tried again without
success.
I have my LOCKS set at 900000.

Any suggestions? The row that I used above is not indexed, but there are 2

referential constraints on the table. I believe that there are around 2.5
million rows in the table.

Thanks

> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: onmode -b 7.31 to revert back from 9.40 [16042]
> Date: Mon, 15 Jun 2009 18:48:34 -0400
>
> You have tables which have been altered in-place. The in-place alters
must
> be completed (by physically updating every row) before the server can be

> reverted successfully. You really should do the updates BEFORE upgrading
to
> 9.40.
>
> FYI, you can use my dbexport replacement utility, myexport, for the
export
> directly from 7.31 to a set of correctly exported files that you can
import
> into 9.40 or any later release using myexport's myimport utility or
dbimport
> (myexport and myimport are fully compatible with dbexport/dbimport).
> Myexport can be downloaded from the Oninit web site (
www.oninit.com/utils)
> or from the IIUG Software Repository (www.iiug.org/software). You will
also
> need my dbschema replacement utility (dbschema is NOT compatible with
> dbimport) from the package utils2_ak, Jonathan Leffler's sqlcmd utility,
and
> -optionally - Ravi Krishna's myonpload (if you want to have
> myexport/myimport use the HPLoader for file IO - though the 7.31
HPLoader is
> limited to 2GB files, so you can pass this option up).
>
> 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, Jun 15, 2009 at 11:13 AM, LARRY SORENSEN
<lsorensen25@msn.com>wrote:
>
> > I have an IDS 7.31.UC9 (Solaris 5.6) instance that I occasionally
convert
> > to
> > 9.40.UC8 (Solaris 5.6) so that I can export a database in preparation
for
a
> > future permanent migration. I have several tables that are very large
and
> > will
> > not export correctly otherwise due to file size limits. After my
dbexport,
> > I
> > perform an onmode -b 7.3 to convert it back and it always complains
about
> > several tables that I need to run UPDATE table_name set
table_name.field =
> > table_name.field...... Sometimes, that does not work and it complains
about
> > the same tables again and again and appears not to be able to revert
back.
> >
> > Without anyone else touching the database while it is converted, I go
> > through
> > the following steps:
> >
> > IDS 7.31.UC9
> >
> > onmode -s
> >
> > onmode -l
> >
> > onmode -c
> >
> > ontape -a
> >
> > onmode -yuk
> >
> > oninit -s
> >
> > onmode -yuk
> >
> > I then bring up the instance with my after environment variables have
been
> > changed to point to my IDS 9.40.UC8 installation (in-place migration).

> >
> > I then export a database.
> >
> > I then repeat the above steps as follows:
> >
> > onmode -s
> >
> > onmode -l
> >
> > onmode -c
> >
> > ontape -a
> >
> > onmode -yuk
> >
> > oninit -s
> >
> > onmode -b 7.31
> >
> > Can anyone se something that I am doing wrong to prevent some tables
from
> > being able to revert back to IDS 7.31?
> >
> > thanks

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

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• onmode -b 7.31 to revert back from 9.40
  LARRY SORENSEN -- Monday, 15 June 2009, at 11:13 a.m.
  • Re: onmode -b 7.31 to revert back from 9.40
    Obnoxio The Clown -- Monday, 15 June 2009, at 11:17 a.m.
    • RE: onmode -b 7.31 to revert back from 9.40
      LARRY SORENSEN -- Monday, 15 June 2009, at 11:41 a.m.
      • Re: onmode -b 7.31 to revert back from 9.40
        Obnoxio The Clown -- Monday, 15 June 2009, at 12:25 p.m.
        • RE: onmode -b 7.31 to revert back from 9.40
          LARRY SORENSEN -- Monday, 15 June 2009, at 12:32 p.m.
          • Re: onmode -b 7.31 to revert back from 9.40
            Obnoxio The Clown -- Monday, 15 June 2009, at 12:34 p.m.
  • Re: onmode -b 7.31 to revert back from 9.40
    jack.parker4@verizon.net -- Monday, 15 June 2009, at 1:45 p.m.
    • RE: onmode -b 7.31 to revert back from 9.40
      LARRY SORENSEN -- Monday, 15 June 2009, at 2:02 p.m.
      • Re: RE: onmode -b 7.31 to revert back from 9.40
        jack.parker4@verizon.net -- Monday, 15 June 2009, at 2:20 p.m.
        • RE: onmode -b 7.31 to revert back from 9.40
          LARRY SORENSEN -- Monday, 15 June 2009, at 5:40 p.m.
          • Re: onmode -b 7.31 to revert back from 9.40
            Obnoxio The Clown -- Monday, 15 June 2009, at 5:44 p.m.
            • RE: onmode -b 7.31 to revert back from 9.40
              LARRY SORENSEN -- Monday, 15 June 2009, at 5:58 p.m.
  • Re: onmode -b 7.31 to revert back from 9.40
    Art Kagel -- Monday, 15 June 2009, at 6:48 p.m.
    • RE: onmode -b 7.31 to revert back from 9.40
      LARRY SORENSEN -- Tuesday, 16 June 2009, at 10:05 a.m.
      • RE: onmode -b 7.31 to revert back from 9.40
        Peter_Logan@spartanstores.com -- Tuesday, 16 June 2009, at 10:37 a.m.
        • RE: onmode -b 7.31 to revert back from 9.40
          LARRY SORENSEN -- Tuesday, 16 June 2009, at 1:24 p.m.
          • RE: onmode -b 7.31 to revert back from 9.40
            Peter_Logan@spartanstores.com -- Tuesday, 16 June 2009, at 1:34 p.m.
          • RE: onmode -b 7.31 to revert back from 9.40
            Plugge, Joe R. -- Tuesday, 16 June 2009, at 1:34 p.m.
            • RE: onmode -b 7.31 to revert back from 9.40
              LARRY SORENSEN -- Tuesday, 16 June 2009, at 2:33 p.m.
              • Re: RE: onmode -b 7.31 to revert back from 9.40
                jack.parker4@verizon.net -- Tuesday, 16 June 2009, at 2:41 p.m.
                • Re: Re: RE: onmode -b 7.31 to revert back from 9.4
                  jack.parker4@verizon.net -- Tuesday, 16 June 2009, at 4:42 p.m.
              • RE: onmode -b 7.31 to revert back from 9.40
                Peter_Logan@spartanstores.com -- Tuesday, 16 June 2009, at 2:44 p.m.
          • Re: onmode -b 7.31 to revert back from 9.40
            Art Kagel -- Wednesday, 17 June 2009, at 9:39 a.m.
            • RE: onmode -b 7.31 to revert back from 9.40
              LARRY SORENSEN -- Wednesday, 17 June 2009, at 10:40 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.