|
Every time we rebuild our database, the file extension name increases by one letter. Can anyone tell us why this happens, how to prevent it and/or how to get it back to the original extension? example: "dbspace.DB" has grown to "dbspace.DBRRRRRRRRERRR" There is an R for each rebuild and the E is when we rebuilt with Encryption. |
|
It is done so that the filename will be different from the one you are unloading from. Right, but can we rename them to get rid of the extra?
(27 Jul, 14:50)
ricwash
Replies hidden
1
Yes. Use ALTER DBSPACE RENAME: https://help.sap.com/docs/SAP_SQL_Anywhere/93079d4ba8e44920ae63ffb4def91f5b/8168f96e6ce21014a0a59fbe21100c1b.html
(27 Jul, 16:21)
John Smirnios
Thank You!
(03 Aug, 07:56)
ricwash
|
|
It seems like your database management system or the process you're using to rebuild your database is appending additional characters to the file extension every time you perform a rebuild. The behavior you've described is not typical for standard database systems, and it's possible that there might be some custom scripting or configuration causing this. 1
No, it's no custom scripting but the default behaviour when using the builtin DBUNLOAD tool with the -an or -ar options (and possibly others) to replace the existing database - it's done to prevent file name conflicts if the dbspace file for the new database is created in the same directory as the dbspace for the original database.
(14 Aug, 10:06)
Volker Barth
|
