Results 1 to 5 of 5

Thread: db2 restore

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: db2 restore

    Dear ALL,

    What is command used for db2 restore? please give me the example.

    Regards,
    K.Manikandan

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    I am considering you take ONLINE Backup for your system:

    Step 1> First Restore the last required complete backup Image:

    RESTORE DATABASE TEST2 FROM "c:\backup_new" TAKEN AT 20051229144027 TO "C:" INTO test2bk4 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;


    Step2> Rollforward the Archive Log-files till the point you want your consisten DB:

    ROLLFORWARD DATABASE test2bk4 TO 2005-12-29-14.43.26.000000 USING LOCAL TIME AND COMPLETE OVERFLOW LOG PATH ("C:\backup\DB2\TEST2");

    Thanks,
    Jayanta

  3. #3
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    K.Manikandan - I suggest you better check out stuff for your self from online resources

    A good place to start off -
    Go over there and search for it.... also you can get plenty of examples if you search or google it..... dont keep creating new posts for simple stuff like restore.... atleast try it out yourself first and if you have a problem then you can post....
    IBM Certified Database Associate, DB2 9 for LUW

  4. #4
    Join Date
    Oct 2008
    Posts
    70

    Db workpocess

    Hi,

    How to find out db process are in acive?what is the command to seee?

    Regards,
    K.Manikandan.

  5. #5
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    As for the utilities running:

    LIST UTILITIES SHOW DETAIL

    As for the threads in flight

    LIST APPLICATIONS FOR DATABASE alias_dbname SHOW DETAIL

Posting Permissions

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