Technical Blog Post
Abstract
50 DB2 Nuggets #28 : Tech Tip - Restore SQL0104N
Body
When restoring you must use the restore-options in the order shown in the InfoCenter If you don't you will see error SQL0104N
Example:
db2 "restore database sample from /tmp/backups to newdb without prompting without rolling forward"
SQL0104N An unexpected token "without" was found following "PROMPTING".
Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601
Per InfoCenter without rolling forward is listed before without prompting. So it should look like this:
db2 "restore database sample from /tmp/backups to newdb without rolling forward without prompting"
If you encounter the SQL0104N check the Infocenter (RESTORE DATABASE command) to verify order of the restore-options being used.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
UID
ibm11141492