Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    25

    Unanswered: Redirect Restore

    Hi, this is narasimha,i have taken off line backup in production server and i have to restore it in testing server. after restoring db in testing server using backp image, i am not getting tables.
    production
    proddinst1

    testing
    testinst1

    but in testing it is not showing the tables after issuing the following command

    db2 list tables

    but it will show
    db2 list tables for schema prodinst1(in testing)
    what is the problem
    what can i do to resolve it

    please provide solution for me

    Thanks and Regards
    Narasimha A

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    but it will show
    db2 list tables for schema prodinst1(in testing)


    A restore doesn't change the tables' schema
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Please, read the description of the LIST TABLES command.
    Regards,
    Mark.

Posting Permissions

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