search cancel

DDMDB database conversion from myisam to innodb after upgraded from Spectrum 10.4.x

book

Article ID: 189865

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction


Recently upgraded Spectrum to 10.4.1 and want to convert the DDMDB database from MyISAM to the newer InnoDB engine type. 

 convert_saved_myisam_to_innodb.pl

However, as the requirements state, there should be approximately 3x the amount of disk space overhear of the largest table, to allow buffer room for the conversion. On this server there is not enough disk space. Can we run the conversion on another server and import the converted back into the original 10.4.1 machine?

Environment

Release : 10.4.1

Component : Spectrum Core / SpectroSERVER

Cause

There is not enough disk space on a 10.4.1 server to run InnoDB conversion

Resolution

- Using DDM_save and DDM_load utilities, you can export and import DDMDB databases. 

- Use DDM_Save to export the original 10.4.1 DDMDB database. 

- Copy the saved DDMDB file to the 10.4.1 server with the additional disk space

- Run the conversion tool  convert_saved_myisam_to_innodb.pl

- Copy the converted database back to the original 10.4.1 server

- Use DDM_Load to import the converted DDMDB