Migration from server running IDS 7.32 to 11.5 on
Larry asked how to move a ~25 GB database from an old Sun/Solaris 2.6 box running IDS 7.31 (he first said 7.32) to a new Solaris 10 box running IDS 11.5, since dbexport hit 2 GB file limits and tape would need a dozen volumes. He also asked whether a 7.31 onunload file could be loaded by 11.5 onload. Suggestions offered: do a staged in-place upgrade (7.x to 9.3/9.4, then to 11.x) per the IBM upgrade guide; split large unloads with WHERE clauses or unload through a pipe/compress; use Enterprise Replication to copy data to the 11.50 server; or create the tables on the new instance and use INSERT ... SELECT across servers, then rebuild indexes. The onunload/onload question went unanswered and no final choice or outcome is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Does anyone have any suggestions for migrating a database from an old Sun
server running IDS 7.32 to a new server running IDS 11.5? The database is only
about 25 GB, but dbexport seems to have problems with the 2GB limits. I could
probably export to tape, but that would require 12-13 tapes.
Larry
Also, will data created from an IDS 7.32 onunload work with the IDS 11.5
onload (both Sun platforms)?
Date: Thu, 26 Jun 2008 14:51:14 -0400 Does anyone have any suggestions for
migrating a database from an old Sun server running IDS 7.32 to a new server
running IDS 11.5? The database is only about 25 GB, but dbexport seems to have
problems with the 2GB limits. I could probably export to tape, but that would
require 12-13 tapes. Larry
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum. > Also
You have to ways:
1.- Do a upgrade from 7.20 to 9.30 or 9.40 and then, another upgrade from 9.x
to 11.x. it works very well. Read the upgrade manual in IBM portal.
2.- If you have some large table with a unload file grater than 2GB, you can
unload in 2 or 3 parts with a query with conditions. Other form is unload to a
pipe and compress the stardard output directly.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Jueves, 26 de Junio de 2008 01:51 p.m.
To: ids@iiug.org
Subject: Migration from server running IDS 7.32 to 11.5.... [12519]
Does anyone have any suggestions for migrating a database from an old Sun
server running IDS 7.32 to a new server running IDS 11.5? The database is only
about 25 GB, but dbexport seems to have problems with the 2GB limits. I could
probably export to tape, but that would require 12-13 tapes.
Larry
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
There is no IDS 7.32, the last version in the 7.xx series is 7.31.
One option: If you have Enterprise Versions you can use ER to replicate the
data from the 7.31 server to IDS 11.50 and then you can migrate applications
as you verify them on the new system.
Art
On Thu, Jun 26, 2008 at 2:51 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote:
> Does anyone have any suggestions for migrating a database from an old Sun
> server running IDS 7.32 to a new server running IDS 11.5? The database is
> only
> about 25 GB, but dbexport seems to have problems with the 2GB limits. I
> could
> probably export to tape, but that would require 12-13 tapes.
>
> Larry
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
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.
You could also create the tables in the new v11.5 instance on box a ...
and then insert into ... select from box b ... then build the indexes and
other objects ....
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Flores, J. Gerardo" <j-gerardo.flores.olvera@hp.com>
To:
ids@iiug.org
Date:
06/26/2008 03:03 PM
Subject:
RE: Migration from server running IDS 7.32 to .... [12521]
You have to ways:
1.- Do a upgrade from 7.20 to 9.30 or 9.40 and then, another upgrade from
9.x
to 11.x. it works very well. Read the upgrade manual in IBM portal.
2.- If you have some large table with a unload file grater than 2GB, you
can
unload in 2 or 3 parts with a query with conditions. Other form is unload
to a
pipe and compress the stardard output directly.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
LARRY
SORENSEN
Sent: Jueves, 26 de Junio de 2008 01:51 p.m.
To: ids@iiug.org
Subject: Migration from server running IDS 7.32 to 11.5.... [12519]
Does anyone have any suggestions for migrating a database from an old Sun
server running IDS 7.32 to a new server running IDS 11.5? The database is
only
about 25 GB, but dbexport seems to have problems with the 2GB limits. I
could
probably export to tape, but that would require 12-13 tapes.
Larry
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Thank you for the suggestions so far. One thing that I should add is that the
old Sun server is running 2.6 and the new Sun server is running OS v10. Also,
Art was right, the old server is running 7.31.
> To: ids@iiug.org> From: Peter_Logan@spartanstores.com> Subject: RE:
Migration from server running IDS 7.32 to .... [12523]> Date: Thu, 26 Jun 2008
15:33:10 -0400> > You could also create the tables in the new v11.5 instance
on box a ... > and then insert into ... select from box b ... then build the
indexes and > other objects .... > > Peter Logan > Senior Database
Administrator > Phone: 616/878-8309 > > From: > "Flores, J. Gerardo"
<j-gerardo.flores.olvera@hp.com> > To: > ids@iiug.org > Date: > 06/26/2008
03:03 PM > Subject: > RE: Migration from server running IDS 7.32 to ....
[12521] > > You have to ways: > > 1.- Do a upgrade from 7.20 to 9.30 or 9.40
and then, another upgrade from > 9.x > to 11.x. it works very well. Read the
upgrade manual in IBM portal. > > 2.- If you have some large table with a
unload file grater than 2GB, you > can > unload in 2 or 3 parts with a query
with conditions. Other form is unload > to a > pipe and compress the stardard
output directly. > > -----Original Message----- > From: ids-bounces@iiug.org
[mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > SORENSEN > Sent: Jueves,
26 de Junio de 2008 01:51 p.m. > To: ids@iiug.org > Subject: Migration from
server running IDS 7.32 to 11.5.... [12519] > > Does anyone have any
suggestions for migrating a database from an old Sun > server running IDS 7.32
to a new server running IDS 11.5? The database is > only > about 25 GB, but
dbexport seems to have problems with the 2GB limits. I > could > probably
export to tape, but that would require 12-13 tapes. > > Larry > > >
*******************************************************************************
> > 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. >