Hello everyone!

Does anybody know what is the equivalent of the MSSQL "sp_attach_db" stored procedure for DB2?

Basically i am looking for a fast way to create a new database from a template database. With MSSQL i was copying and renaming the db files and then attaching them in the server using the "sp_attach_db" command. How can i perform the same thing in db2??


Thanks!!!

You may have to do a redirected restore from a backup of the template database ...

I have used a backup and restore using unix pipe to make a copy of the template database ....

HTH

Sathyaram

Yes, this is what i did!!!

It seems to be working ok.

Thanks for your reply