IBM Support

50 DB2 Nuggets #28 : Tech Tip - Restore SQL0104N

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":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141492