18 February,2011 by Tom Collins
You’ll get this error message when attempting to restore a database with automatic storage onto a server where the path doesn’t exist
I had this problem when attempting :
db2 restore db db1 from /db2inst1/backups into db1 redirect without prompting
The error message was
SQL1051N The path "/db2inst/files" does not exist. SQLSTATE=57019
The resolution was :
1)Create path where the automatic storage should install
2)use the following syntax :
db2 "restore db db1 from /db2inst1/backups ON /db2inst1/files/db1 into db1 redirect without prompting"
db2 “restore db db1 continue”
Source:Jack Vamvas(http://www.dba-db2.com)
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |