IDS Forum

RE: IDS 9.40 32bit/64bit - Backup&Restore question

Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN
Date: Tuesday, 7 November 2006, at 1:33 p.m.

In Response To: RE: IDS 9.40 32bit/64bit - Backup&Restore question (Sebastian, Norma J.)

Norma,

Actually I assumed as you did that they were also porting to a different
machine at the same time, I just did not think of the restore to 32bit then
upgrade option. They can certainly take your suggestion!

Art S. Kagel

----- Original Message -----
From: Norma J. Sebastian <ids@iiug.org>
At: 11/07 13:17:49

Art, are you sure?

back when I did it, I don't recall exporting nearly a terabyte of data
and importing....

I think I just brought DB down, upgraded IDS binaries, brought DB up...
and wala... moments later after internal stuff, IDS was happy.

But like I said, that was several years back and I have slept since then
;)

Norma Jean Sebastian
ERP Support Administration
GIS- Enterprise Technical Services

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
ART KAGEL, BLOOMBERG/ 731 LEXIN
Sent: Tuesday, November 07, 2006 11:13 AM
To: ids@iiug.org
Subject: Re: IDS 9.40 32bit/64bit - Backup&Restore question [7750]

No. You cannot go from 32bit to 64bit using ontape or onbar. You have to

export the data, create a new instance, then import the data. Use
dbexport/dbimport, my replacement utility myexport/myimport which can
optionally
use onpload for the IO and can export/import the tables in parallel so
that it
will run faster than dbexport/dbimport can, or your own home grown
combination
of dbschema/myschema and onpload to export the schema and data and
reimport
them.

Myexport is available for download from the IIUG Software Repository and

requires you to also install:
utils2_ak (by me - specifically my dbschema replacement myschema)
sqlcmd (by Jonathan Leffler - v72.06 or later IB, current is 80.00 -
specifically the sqlreload and sqlunload utilities it includes)
myonpload (a simplified commandline interface to onpload by Ravi
Krishna)

Art S. Kagel

----- Original Message -----
From: Elena.Nemtisor@softnet.ro <ids@iiug.org>
At: 11/07 12:07:05

Hello,

I would like to move a database from an IDS 9.40.UC2 towards an IDS
9.40.FC7, on SUN 8 machines.

Is possible to do this using the BACKUP & RESTORE utilities?
If yes, what I have to prepare on the destination server before starting

the database restore?

Thank you,
Elena

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

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

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

Messages In This Thread

• IDS 9.40 32bit/64bit - Backup&Restore question
  Elena.Nemtisor@softnet.ro -- Tuesday, 7 November 2006, at 11:58 a.m.
  • RE: IDS 9.40 32bit/64bit - Backup&Restore question
    Sebastian, Norma J. -- Tuesday, 7 November 2006, at 12:11 p.m.
  • Re: IDS 9.40 32bit/64bit - Backup&Restore question
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Tuesday, 7 November 2006, at 12:12 p.m.
    • RE: IDS 9.40 32bit/64bit - Backup&Restore question
      Sebastian, Norma J. -- Tuesday, 7 November 2006, at 1:08 p.m.
      • RE: IDS 9.40 32bit/64bit - Backup&Restore question
        ART KAGEL, BLOOMBERG/ 731 LEXIN -- Tuesday, 7 November 2006, at 1:33 p.m.
      • Re: IDS 9.40 32bit/64bit - Backup&Restore question
        Martin Fuerderer -- Tuesday, 7 November 2006, at 1:55 p.m.
        • RE: IDS 9.40 32bit/64bit - Backup&Restore question
          mosserp@wellsfargo.com -- Wednesday, 8 November 2006, at 4:31 p.m.
  • AW: IDS 9.40 32bit/64bit - Backup&Restore question
    Model-Bosch, Tilman -- Tuesday, 7 November 2006, at 1:02 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.