Restoring a database

db2dba08 · #1 (**permalink**) 02-04-09, 00:53

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

przytula_guy · #2 (**permalink**) 02-04-09, 01:52

no tables for your schema (connected user)
try db2list tables for schema sysibm

MarkhamDBA · #3 (**permalink**) 02-04-09, 10:52

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'

hkp819 · #4 (**permalink**) 02-05-09, 00:18

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?

MarkhamDBA · #5 (**permalink**) 02-05-09, 13:30

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

stephen.song · #6 (**permalink**) 02-08-09, 02:46

you can check the tables here : select * from syscat.tables

Internet Services

Web Development

Digital Marketing

Consumer Tech