NetWorker: SQL0104N Errors during backup of DB2 databases.
Summary: SQL0104N Errors during NetWorker backup of DB2 databases.
Symptoms
NetWorker backups of DB2 databases can fail with the following errors:
C:\Program Files\EMC NetWorker\nsr\bin>db2 update db cfg for DBNAME using logarchmeth1 VENDOR:"C:\Program Files\EMC NetWorker\nsr\bin\libnsrdb2.dll" logarchopt1 "C:\Program Files\EMC NetWorker\nsr\apps\config\nmda_db2_tlogs.cfg"
SQL0104N An unexpected token "Files\EMC" was found following "<identifier>"
Expected tokens may include: "ACT_SORTMEM_LIMIT" SQLSTATE=42601
Cause
This failure is the result of a mistake in the syntax of the backup command.
Resolution
The backup command must use the Windows Short Path convention. For example:
Full Path: C:\Program Files\EMC NetWorker
Short Path: C:\PROGR~1\EMCNET~1
The same command in the symptoms section that failed would instead include the short path:
db2 update db cfg for DBNAME using logarchmeth1 VENDOR:C:\PROGRA~1\EMCNET~1\nsr\bin\libnsrdb2.dll logarchopt1 C:\PROGRA~1\EMCNET~1\nsr\apps\config\nmda_db2_tlogs.cfg