I thought that dbm cfg parameters would stay the same when a database
is restored, but that the db cfg parameters would get overwritten by
params in the backup. This doesn't appear to be the case becuase I
restored a backup into a database where the STMTHEAP was 32768. I
restored a backup into that database that came from a database that
had STMTHEAP at 4096. I thought that after the restore that the 32768
would have gotten overwritten to 4096, but that didn't happen.

Can someone explain what db config parameters, if any, will get
overwritten by a restore?

Thanks for enlightening me. :-)

On Nov 17, 5:50*pm, Richard <rmcgor... (AT) gmail (DOT) com> wrote:
I'm pretty sure everything is kept, except what you change explicitely
(storage paths, logpath, ...). If you want to use the values from the
backup, you need to drop the db first.

--
Frederik Engelen