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. asked 27 Jul '23, 14:38 ricwash |
It is done so that the filename will be different from the one you are unloading from. answered 27 Jul '23, 14:48 John Smirnios Right, but can we rename them to get rid of the extra?
(27 Jul '23, 14:50)
ricwash
Replies hidden
1
Yes. Use ALTER DBSPACE RENAME: https://help.sap.com/docs/SAP_SQL_Anywhere/93079d4ba8e44920ae63ffb4def91f5b/8168f96e6ce21014a0a59fbe21100c1b.html
(27 Jul '23, 16:21)
John Smirnios
Thank You!
(03 Aug '23, 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. answered 14 Aug '23, 09:32 Mobodon 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 '23, 10:06)
Volker Barth
|