IDS Forum

RE: onmode -b 7.31 to revert back from 9.40

Posted By: Plugge, Joe R.
Date: Tuesday, 16 June 2009, at 1:34 p.m.

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

Alter the database to non logged, run your mass update, then alter it back ... then back it up.

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN
Sent: Tuesday, June 16, 2009 12:25 PM
To: ids@iiug.org
Subject: RE: onmode -b 7.31 to revert back from 9.40 [16053]

Thanks. Now that I have gotten past that, I am running into a long
transaction. Is the only trick to overcome that, adding more log files?

> To: ids@iiug.org
> From: Peter_Logan@spartanstores.com
> Subject: RE: onmode -b 7.31 to revert back from 9.40 [16047]
> Date: Tue, 16 Jun 2009 10:37:49 -0400
>
> 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.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

*******************************************************************************
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.