If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > restore database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-01-03, 00:29
jagan_5378 jagan_5378 is offline
Registered User
 
Join Date: Nov 2003
Posts: 68
restore database

hi !
pl tell me the solution.

This is my database backup file . KALA.0.db2inst1.NODE0000.CATN0000.20031022214251.0 01

ok now i want to restore this backup another db2 server.

i don't have any information about backup file.
i have only backfile.
that file i want to restore now.
but whiel restoreing database it will folllowing errors
some times bad container path.

for this error i chech the backup thorough follwing command

db2ckrst -a KALA mr -t 0031022214251 -c
accoring this out put i create all paths.

in this database backup there are using /etc/raw/raw1 for one table space what is this?

some times it will give follwing error.
SQL0902C A system error (reason code = "2") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005


pl give me solution for this problem.

this i s very much userful for us.
Reply With Quote
  #2 (permalink)  
Old 11-03-03, 08:55
nitingm nitingm is offline
Registered User
 
Join Date: Jul 2003
Location: Austin, TX, USA
Posts: 278
Try redirected Restore.

Hello,

Please try the redirected restore option that should help. Please also list down the details of your DB2 Version, fixpack and the operating systems, that would help us to help resolve your problem.

Regards

Nitin.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On