| re: Copying an existing DB2 database
Stefan,
see update inline...
"Stefan Schneider" <schneider_66@gmx.de> schrieb im Newsbeitrag
news:cs84cs$h1u$1@pentheus.materna.de...[color=blue]
> Hi,
>
> I have to copy an existing database from one Windows-Server to another
> one.
>
> The source database is a 8.1.0 database on a Windows 2000 Server, the
> destination database will be a newer 8.x database on a Windows 2003
> Server.
>
> What is the preferred way to copy the old data to the new server? Should
> I use the backup/restore tools or is there a better way like copying the
> tablespace files?[/color]
The prefererred way is to backup and restore the database...[color=blue]
>
> Is it possible to do a backup of the old database and restore it into the
> new (empty) system? I always have to choose an existing database where to
> restore into. If I create an empty database, I get a message while
> restoring that this database is not matching the one I want to restore.[/color]
You can can restore in a new database 'restore db xxx ... into target
database'
or in an existing database 'restore db xxx ... replace existing'
If the underlying filesystem is the same as on the source database you have
nothing to do than a restore, but if you change the filesystem lke path or
name
you can use 'restore db xxx ... redirect'. Look for the syntax.
[color=blue]
>
> I would prefer to backup all tables as IXF-files and import them on the
> new system, but I have not found a method to extract the appropriate
> DDL-statements for all tables. It is very annoying to select the first
> table, klick on export, choose IXF, choose all columns, extract
> ddl-statement, select the second table, ...[/color]
you can use db2move, what is doing all for you,
also look for db2look which generate the database layout.
[color=blue]
>
> Do you have any ideas or some links which could help me?
>
> Thanks
> Stefan
>
>
> PS: Do I have to migrate the databases when changing from 8.1.0 to 8.2 or
> 8.1.x?[/color]
The restore do this for you...
You have to bind the db2cli and the db2ubind packages after the restore is
complete.
Run also db2updv8.
P.S: Materna in Dortmund?
[color=blue]
>[/color]
| 
