![Unique table names on a connection [CR 455684]](arrow-right.gif){kind=icon}
The information in “Example 2 — Moving the Catalog Store” in the “Moving database files” section of the “The RESTORE statement” section under “Restoring your databases” in Chapter 14, “Backup and Data Recovery” is not correct regarding the directory in which a file is restored.
In the second bullet, the sentences “Files originally created relative to the IQ_SYSTEM_MAIN dbspace, which holds the main IQ Store file, are restored relative to the main IQ Store file.” will be replaced with the following:
“Files originally created relative to the Catalog Store are restored relative to the Catalog Store.”
The sentence “Relative pathnames in the RENAME clause work as they do when you create a database or dbspace: the main IQ Store dbspace, Temporary Store dbspaces, and Message Log are restored relative to the location of db_file (the Catalog Store); user-created IQ Store dbspaces are restored relative to the directory that holds the main IQ dbspace.” will be replaced with the following:
Relative pathnames in the RENAME clause work as they do when you create a database or dbspace: the main IQ Store dbspace, Temporary Store dbspaces, and Message Log are restored relative to the location of db_file (the Catalog Store); user-created IQ Store dbspaces are restored relative to the directory that holds the Catalog Store.”
