Migrating MAXDB 7.7 from AIX to Windows

[former_member514918]

Hello all,

I am trying to migrate MAXDB 7.7.07.41 running on AIX server to 7.7.07.50 running on Wintel.

I am using loadercli to export the data and import it. Export is getting completed successfully but import failing with below error.

General error;-6006 PSO<14> Duplicate name.

I am trying to give duplicates_clause but it is not taking.

Here is my command

loadercli -d sid -u username,password -b parameter_file

Parameter file content

IMPORT DB

catalog instream file 'filename.catalog'

data instream file 'file_name.data' RECORDS

package outstream file 'import_file_name.pack' csv

EXPORT DB

catalog outstream file 'filename.catalog'

data outstream file 'file_name.data' RECORDS

package outstream file 'export_fille_name.pack' csv

Appreciate your inputs into this at the earliest

Thanks

[simon_matter]

I never did an import/export with loadercli, but maybe you could simply do a full backup on AIX and recover from it on Windows, did you try that?

Simon

[former_member514918]

Hello Simon,

AIX to windows is an heterogeneous migration. Not sure if backup and restore would work.

Did you try this option, will it work?

I am more into oracle and when we are doing heterogenous migration, we use export/import if not latest features of transportable tablespace.

New maxdb and having tough time

Appreciate your inputs.

Thanks,

Gowda

[simon_matter]

I didn't test this but I think as long as both systems have the same endianness it should work. Unfortunately that may be a problem for you because I read "Power processors are big-Endian, while Intel Architecture processors are little-Endian." on IBM's website

Maybe SAP provides a tool to change endianness of MaxDB backups?