Use backup db and restore db ..
It's easy for you.
-----Message d'origine-----
De : botlhaleb
[mailto:db2udbdba-ezmlmshield-x87813181.[Email address protected]
Envoyé : mercredi 26 octobre 2005 16:23
À : LazyDBA Discussion
Objet : Migration
Hi Gurus,
Running on AIX 5.2.0.0
We are trying to migrate data from one instance to another and the
other one is from one server to another, db2v7.2(instance1) which is EEE
to db2v8.2(instance2) EE. What is the best process of migration for this
particular table?
We've got one Table that has column name with datatype (blob)
length(4194304) LOGGED NOT COMPACT and take long time to export, even
load does'nt help and it is production envirnment.
The tablespace for this table is managed by system. There is about 1,5
million rows on the table.
Regards
Felicity
___________________________________________________________
Important Notice:
Authorised Financial Services Provider
Important restrictions, qualifications and disclaimers
("the Disclaimer") apply to this email. To read this click on the
following address or copy into your Internet browser:
http://www.absa.co.za/disclaimer
The Disclaimer forms part of the content of this email in terms of
section 11 of the Electronic Communications and Transactions
Act, 25 of 2002.
If you are unable to access the Disclaimer, send a blank e-mail
to [Email address protected] and we will send you a copy of the
Disclaimer.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
***********************************
Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de
ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France Telecom decline toute responsabilite au titre de
ce message s'il a ete altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised
use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or
falsified.
If you are not receiver of this message, please cancel it immediately and inform the sender.
***********************************
DB2 & UDB email list listserv db2-l LazyDBA home page