If the dbspace name contains a file extension such as .iq, .iqtmp, or .iqloc, you must enclose the dbspace name in double quotation marks when specifying the name in a RESTORE command RENAME clause.
For example:
RENAME local1 TO '/work/local1_res.iqloc.iqloc' DBSPACENAME "local1_res.iqloc"
or
RENAME "test_prod2.iq" TO '/test/test_prod7.iq'