IDS Forum

Re: RE: onmode -b 7.31 to revert back from 9.40

Posted By: jack.parker4@verizon.net
Date: Tuesday, 16 June 2009, at 2:41 p.m.

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

1 - 'ontape -s -N=C2=A0<database> -t NUL' may get around that.=C2=A0 =

DB does not like to change logging state without a backup.

2 - S= chema changes are always logged - even for raw tables.=C2=A0

IMLE, you need= 1x the size of the table in logfiles to support a

schema change.

j.

On Jun 16, 2009, LARRY SORENSEN <lso= rensen25@msn.com> wrote:

I tried to change the status using both ontape and onmonitor. Both

t= imes I

selected non logged, it said that it was an invalid option.

> To: [1]ids@iiug.org

> From: [2]JRPlugge@west.com =

> Subject: RE: onmode -b 7.31 to revert back from 9.40 [16056]

> Date: Tue, 16 Jun 2009 13:34:58 -0400

>

> Alter t= he database to non logged, run your mass update, then

alter it back

.= ...

> then back it up.

>

> -----Original Message= -----

> From: [3]ids-bounces@iiug.org [mailto:[4]ids-bounc= es@iiug.org]

On Behalf Of LARRY

> SORENSEN

> Sent: Tu= esday, June 16, 2009 12:25 PM

> To: [5]ids@iiug.org

> Subje= ct: RE: onmode -b 7.31 to revert back from 9.40 [16053]

>

&g= t; 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

file= s?

>

> > To: [6]ids@iiug.org

> > From: Peter_Logan@spartanstores.com

> > Subject: RE: onm= ode -b 7.31 to revert back from 9.40 [16047]

> > Date: Tue, 16 = Jun 2009 10:37:49 -0400

> >

> > You could do the fo= llowing ...

> >

> > begin work;

> >

> > lock table table_name in exclusive mode;

> > updat= e table_name ....

> > commit work;

> >

> &= gt; That will place a table level lock on the table ... You

should make sur= e

> > you have enough transaction logs ... or you might hit the= high

water mark

> > ....

> >

> > Peter=

> >

> > Peter Logan

> > Senior Databas= e Administrator

> > Phone: 616/878-8309

> >

&= gt; > From:

> > "LARRY SORENSEN" <[7]lsorensen25@msn.com= >

> > To:

> > [8]ids@iiug.org

> > = Date:

> > 06/16/2009 10:05 AM

> > Subject:

&g= t; > RE: onmode -b 7.31 to revert back from 9.40 [16046]

> >= Sent by:

> > [9]ids-bounces@iiug.org

> >

> > 2 more questions:

> >

> > 1) I went th= rough the steps listed in the documentation for

migration. How

> &= gt;

> > else do I know what in-place alters need to be done bef= ore

migration?

> >

> > 2) I am receiving the follow= ing error while trying to do an

in-place

> > alter:

> = >

> > update claim_d set claim_d.h_msi =3D claim_d.h_msi

> > where 1=3D1;

> > 271: Could not insert new row int= o the table.

> >

> > 134: ISAM error: no more locks=

> > I have changed the LOCK MODE to PAGE from ROW and tried ag= ain

without

> > success.

> > I have my LOCKS set at= 900000.

> >

> > Any suggestions? The row that I us= ed above is not indexed,

but there are 2

> >

> > re= ferential constraints on the table. I believe that there

are around 2.5

> > million rows in the table.

> >

> > Tha= nks

> >

> > > To: [10]ids@iiug.org

> > = > From: [11]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

> > >

> > > Y= ou have tables which have been altered in-place. The

in-place alters

= > > must

> > > be completed (by physically updating ev= ery row) before the

server can be

> >

> > > reve= rted 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 fu= lly compatible with

dbexport/dbimport).

> > > Myexport can b= e downloaded from the Oninit web site (

> > [12]www.oninit.com/= utils)

> > > or from the IIUG Software Repository (=

www.iiug.org/software). You will

> > also

> > &= gt; need my dbschema replacement utility (dbschema is NOT

compatible with <= br />> > > dbimport) from the package utils2_ak,

Jonathan Leffler'= s sqlcmd utility,

> > and

> > > -optionally - Ra= vi Krishna's myonpload (if you want to have

> > > myexport/m= yimport use the HPLoader for file IO - though the

7.31

> > HPLo= ader is

> > > limited to 2GB files, so you can pass this opt= ion up).

> > >

> > > Art S. Kagel

> = > > Oninit ([13]www.oninit.com)

> > > IIUG Board of Dire= ctors ([14]art@iiug.org)

> > >

> > > Disclaimer:= Please keep in mind that my own opinions are my

own opinions

> &g= t; and

> > > do not reflect on my employer, Oninit, the IIUG= , nor any

other

> > organization

> > > with whic= h I am associated either explicitly or implicitly.

Neither do

> &g= t; > those opinions reflect those of other individuals

affiliated with a= ny

> > entity

> > > with which I am affiliated n= or those of the entities

themselves.

> > >

> > &= gt; On Mon, Jun 15, 2009 at 11:13 AM, LARRY SORENSEN

> > <[15]lsorensen25@msn.com>wrote:

> > >

> > &g= t; > I have an IDS 7.31.UC9 (Solaris 5.6) instance that I

occasionally <= br />> > convert

> > > > to

> > > &g= t; 9.40.UC8 (Solaris 5.6) so that I can export a database

in preparation > > for

> > a

> > > > future perman= ent migration. I have several tables that

are very large

> > an= d

> > > > will

> > > > not export corre= ctly 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 =3D

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

> > > > <= br />> > > > Without anyone else touching the database

while it= is converted, I go

> > > > through

> > > = > the following steps:

> > > >

> > > &g= t; IDS 7.31.UC9

> > > >

> > > > onmode = -s

> > > >

> > > > onmode -l

>= > > >

> > > > onmode -c

> > > &g= t;

> > > > 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:

> > &g= t; >

> > > > onmode -s

> > > >

> > > > onmode -l

> > > >

> > &g= t; > onmode -c

> > > >

> > > > ontap= e -a

> > > >

> > > > onmode -yuk

= > > > >

> > > > oninit -s

> > >= ; >

> > > > onmode -b 7.31

> > > > <= br />> > > > Can anyone se something that I am doing

wrong to p= revent some tables

> > from

> > > > being abl= e to revert back to IDS 7.31?

> > > >

> > >= ; > thanks

> >

> >

> >

> >

************************************************************=

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

> >

> > Forum Note: Use "Reply"= to post a response in the discussion

forum.

> >

> >= ;

> >

>

>

*****************************=

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

> > Forum No= te: Use "Reply" to post a response in the discussion

forum.

> >=

>

>

>

***********************************=

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

> Forum Note: Use "Re= ply" to post a response in the discussion

forum.

>

>

>

**************************************************************=

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

> Forum Note: Use "Reply" to post a response in = the discussion

forum.

>

************************=

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

Forum Note: U= se "Reply" to post a response in the discussion

forum.

References

1. 3D"mailto:ids@iiug.org"

2. 3D"mailto:JRPlug=

3. 3D"mailto:ids-bounces@iiug.org"

4. file://localhost/tmp/3D"mai=

5. 3D"mailto:ids@iiug.org=

6. 3D"mailto:ids@iiug.org"

7. 3D"mailto:lsore=

8. 3D"mailto:ids@iiug.org=

9. 3D"mailto:ids-bounces@iiug.org"

10. 3D"mailto:ids@iiug.org=

11. 3D"mailto:art.kagel@gmail.com"

12. 3D"http://w=/

13. 3D"http://www.oninit.com"/

14. 3D"mailto:art@iiug.org"

15. 3D"mailto:lsorensen25@msn.com"

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.