I have to move an a database ( name is DB1 ) from aix server to linux server.
I know that is is not possible by backup/restore but with the utility DB2MOVE.
Unfortunatly i have no experience with db2 someone could help me with the exact command that i have to lunch to move DB1 from aix to linux. ?? plse !!
On linux server i have installed DB2 and created the same instace name of th aix server, and i haven't creted non db ....
logon to aix with db2 instance owner, or root and su - to instance owner
get the db name : db2 list db directory
get tablespaces : db2 connect to dbname
db2 list tablespaces show detail
on linux logon the same and create database
db2 create db dbname on /fs/fs <<---- wherever the space is..
create the tablespaces if any needed
db2 create regular tablespace xxx <<--- see info center for syntax
db2move dbname export -sn schemaname
repeat for all schema
ftp all files created to linux in binary mode
db2 connect to dbname
db2move dbname import/load <-- depending if large table use load
for aal syntax detail see : http://publib.boulder.ibm.com/infoce.../v8//index.jsp
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be