How to do SYSTEM COPY of Identity Center Database (DB2 to DB2) ?

[Former Member]

Hello All,

SAP IDM 7.2 SP8.

I have use case to do System Copy from DB2 to DB2.

I was checking IDM document -  SAP NetWeaver Identity Management System Copy G... | SCN (System Copy Guide - Copying the Identity Center Database) and found that there is no mention of this use case.

I checked ZIP file under SAP NetWeaver Identity Management System Copy Export File - System Copy Jobs (ZIP) under and see that DB2 to DB2 copy use case is not part of documentation.

Can you please help me to know if it is possible to do DB2 to DB2 System Copy ?

If yes, Is there documentation available ?

Thank you.

Kind Regards,

Pradeep

[Former Member · Accepted solution]

Hi Pradeep,

The original idea behind the SYSCOPY, was to enable migration from one db type to another.

When both source and target are the same, you would normally use a database tool to do the copy.

There should be tools for doing this for DB2.

Regards,

Ole K.

[Former Member · Accepted solution]

Hi Ole K. ,

Thank you for your reply. 🙂

I am not aware of DB2 tool to do this...I would check with DB guy in my group.

But current documentation has steps for system copy for MSSQL to MSSQL DB and Oracle to Oracle DB and in these use cases, source and target DB are of same type same as of use case for DB2 to DB2 system copy.

So, I thought DB2 to DB2 system copy also should have had the documentation and scripts.

Does this sound reasonable ?

Thanks & Regards,

Pradeep

[Former Member · Accepted solution]

Hi,

As you say, it should probably be made as there are jobs for MSSQL to MSSQL and Oracle to Oracle.

I was actually the one creating the SYSCOPY when I was in SAP Labs Norway, and at that time it was decided not to go further with doing DB2 to DB2.

I do not now if SAP Labs Sofia has any plans for doing it.

Regards,

Ole K.

[Former Member · Accepted solution]

Hi,

Thank you Ole.

Currently on the roadmap we do not plan to provide DB2 SYSCOPY. So it is better to use the DB2 standard tools.

Best wishes,

Fedya Toslev

[former_member2987 · Accepted solution]

Pradeep,

Assuming you're still on the same project, check with the DBA team.  They were using some DB2 product to move the databases and tables around.

Matt

[Former Member · Accepted solution]

Hi Matt,

Thank you for the response. 🙂

DBA team suggested and would use "DB2 redirected restore for Database using production backups".

Thanks & Regards,

Pradeep