Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008

    Unanswered: want to backup only schemas

    Hello everyone,
    I have a requirement for taking the backup of only a particular schema, without taking the backup of rows in it, as the data r stored in some other server which populates every day. So, i ncase in future, my database gets corrupted, i should b able to restore the whole database structure with all related indexes or any kind of objects.

    I am confused as to use db2look or db2move option, can anyone help on this ?????

  2. #2
    Join Date
    Jun 2006
    db2look -d xx -e -l -x will create the complete structure of the db
    no data is involved
    db2move is to move the data - without the structure. the db has to exist
    best regards, guy przytula
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts