Hi everyone,
As a Spectrum 10.2.x customer, and quite a few 9.x versions as well, I've had to manually repair the Archive Manager using ./ArchMgr.exe --repair any time the process is terminated ungracefully.
This can mean hours of fun. I've read that for Spectrum 10.3 the ddmdb can now be migrated to InnoDB which according to:
https://docops.ca.com/ca-spectrum/10-3-0/en/installing-and-upgrading/upgrading#Upgrading-PostUpgradeTasks
Supports "auto crash recovery features".
1) Any chance that InnoDB and MyISAM have been benchmarked by the Spectrum team? The same link also lauds certain performance benefits in accordance with MYSQL best practices.
2) Can the Archive Manager actually fix itself so that I no longer need to deal with repairing it and manually restarting it after a forced reset or shutdown?
Thanks!