DB2 - SQL1051N while Redirected Restore

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)
Author: Rambler(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

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.


Post a comment on DB2 - SQL1051N while Redirected Restore

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright