IDS Forum

RE: onmode -b 7.31 to revert back from 9.40

Posted By: LARRY SORENSEN
Date: Wednesday, 17 June 2009, at 10:40 a.m.

In Response To: Re: onmode -b 7.31 to revert back from 9.40 (Art Kagel)

Thanks to all for the help. I first doubled the number of logical logs without success. I then was able to change the two (2) databases to non-logging temporarily (as suggested) while I did the updates and the conversion. Once I brought the instance back up in IDS 7.31, I changed the two (2) databases back to buffered logging.

> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: onmode -b 7.31 to revert back from 9.40 [16068]
> Date: Wed, 17 Jun 2009 09:39:25 -0400
>
> Either that or break up the update into multiple updates. You DO have at
> least two indexes, one for each of the referential constraints on the
> table. So, you could use those keys to limit the updates to some of the
> rows. You can check on whether a table still has any altered rows that are
> not currently at the latest schema version by running oncheck -pT
> <database>:<table>. That report will tell you what row versions are in the
> table and how many rows are at each version level in the section headed
> "Home Data Page Version Summary". If the table has no alters outstanding
> then all rows will be at the single version level marked "(current)".
>
> 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 Tue, Jun 16, 2009 at 1:24 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote:
>
> > 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.
> >
> >
>
> --001636c5ab5bef7c98046c8b6af2
>
>
> *******************************************************************************
> 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.