Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2009
    Posts
    4

    Exclamation Unanswered: Restoring a database

    Hi All,
    I am facing a problem in db2,
    i have restored a database using the command

    db2 restore database db_name from /path

    and it completed successfully also,
    but when i issued the command

    db2 list tables

    It is not showing any records there,
    will any1 tell me wats the problem and how to resolve this

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    no tables for your schema (connected user)
    try db2list tables for schema sysibm
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by db2dba08
    Hi All,
    I am facing a problem in db2,
    i have restored a database using the command

    db2 restore database db_name from /path

    and it completed successfully also,
    but when i issued the command

    db2 list tables

    It is not showing any records there,
    will any1 tell me wats the problem and how to resolve this
    try 'db2 list tables for all'
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Dec 2008
    Posts
    59
    I have read article related to this topic from here I think you will also get sufficient help from here......
    Zen Cart(tm) Tutorials and FAQs - How can I do a database-backup with phpMyAdmin?

  5. #5
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by db2dba08
    Hi All,
    I am facing a problem in db2,
    i have restored a database using the command

    db2 restore database db_name from /path

    and it completed successfully also,
    but when i issued the command

    db2 list tables

    It is not showing any records there,
    will any1 tell me wats the problem and how to resolve this
    depending on the history of this db, another thing you probably need to do is uncatalog and then catalog it
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  6. #6
    Join Date
    Aug 2004
    Posts
    24
    you can check the tables here : select * from syscat.tables
    I am a java and database developer.

Posting Permissions

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