Hi All,

Is there a way to extract the create database command from an existing DB2 V8.2 database? Any 3rd party tools that has this feature? Any help is greatly appreciated.

Thanks,
Dev

DB2LOOK command with the appropriate parameters will create the DDL for you

I tried DB2LOOK. DB2LOOK does not give you "create database" command. If you know the parameters please let me know.

Thanks

There is no command to recreate a create database command used for a specific database. Some of the basic information could be obtained via SQL and/or various admin views, etc, but probably not every parameter that can be used in a create database.

So whats the easiest way to migrate a database from SOLARIS to LINUX? Due to endian difference, we cannot just do a backup-restore. Also DB2LOOK and DB2MOVE does not give me the "create database" statement. And, we have over 300 databases which we need to migrate over to LINUX. So writing individual "CREATE DATABASE" statement is pain-staking and time consuming.

That depends on which options you want to specify in the create database statement. Are you expecting the options to be different (other than database name and path names) for each database? You could easily generate the statements if you just have a list of the databases and you use a standard convention for database path and automatic storage path.

Stupid question: you don't have the scripts archived that were used to create the databases?