Migration from Oracle to DB2

[Former Member]

Hi,

We are planning to Migrate from Oracle to DB2 version 10.5 Database.Can you please help us or share any document/link how we can proceed with this migration .

We have our SAP System ECC6.0 EHP5 .Oracle Version is 11.2.0.2.

Thanks in advance

Regards

Amit Shedge

[Reagan · Accepted solution]

Hello

You need to do a Heterogeneous system copy to achieve this.

Head here for the guide.

https://websmp208.sap-ag.de/erp-inst

SAP ERP 6.0 - Installation - System Copy: Systems Based on SAP NetWeaver 7.1 or Higher

You prepare the source system and then export the source system using the sapinst/SWPM and then move the export dump to the target system and create the target system by importing the dump into the target system. A certified Migration Consultant should be doing this.

Check these for more details

82478 - SAP system OS/DB migration

http://scn.sap.com/docs/DOC-34592

http://scn.sap.com/docs/DOC-8324

Regards

RB

[Former Member · Accepted solution]

Thanks Reagan for the reply.

Please find the details of the Source and Target System for which we will doing migration

Current Release :

Database :- Oracle 11.2 EE

OS Version: Windows 2003 EE Sp1

SAP Release : SAP Netweaver 2004s

Target Release :-

Database : -Db2 10.5 fp1

OS Version : Windows 2008 R2 Std

SAP Release : SAP Netweaver 2004s.

Can you please let us know if any notes /installation guide which need to be refer ..

Also what are the parameter we need to updated for export/import.

Thanks & Regards

Amit Shedge

[Reagan · Accepted solution]

Hello Amit

Please read those links I have provided.

Also check these SAP notes.

936441 - Oracle settings for R3load based system copy

454173 - DB6: Accelerated R3load migration through CLI LOAD

Regards

RB

[Former Member · Accepted solution]

Thanks ,

I have gone through those note and we have successfully migrated from Oracle to Db2 10.5 fix pack 1.

But when we executed DB02 Transaction we are getting error

SQL0440N  No authorized routine named

"SNAPSHOT_DBM" of type "FUNCTION" having

compatible arguments was found.  SQLSTATE=42884

Please suggest

Thanks & Regards

Amit

[Former Member · Accepted solution]

Hi Amit,

Did you run the db6_update_db.bat and db6_update_client.bat script yet?

I found it strange that it calls the "SNAPSHOT_DBM", whereas in DB2 v 10.1 it's replaced by "SNAP_GET_DBM"....

I hope this will help you.

Regards,

Andre

[Former Member · Accepted solution]

Amit,

Also use the transaction DBACOCKPIT, instead of DB02.

Regards,

Andre

[tariqmaqsood]

Hi Guys

I am facing the same issue on our BW system. It is also migrated from Oracle to DB2 10.5.

Regardless using DB02 or DBACOCKPIT - there is this error message in SM21

Database error -440 at OPC

> SQL0440N No authorized routine named "SNAPSHOT_DBM" of type

> "FUNCTION" having compatible arguments was found.

> SQLSTATE=42884

Database error -440

[Former Member]

Hi Tariq,

Please check below notes for db2 related monitoring.

1314750-  DB6: DBA Cockpit Correction Collection SAP Basis 7.00 / 7.10

1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31

1309424  -DB6: DBA Cockpit Correction Collection SAP Basis 7.01 / 7.11

[former_member285936]

Hi All,

We have successfully migrated from Oracle to Db2 10.5 FP 3.

SAP Version SAP ECC 6.0 EHP4

After migration we have following error found in Tcode dbacockpit

1). SQL0420N Invalid character found in a character string argument

of the function "DECFLOAT". SQLSTATE=22018

2). SQL0440N No authorized routine named "SNAPSHOT_DBM" of type

"FUNCTION" having compatible arguments was found. SQLSTATE=42884

We have follow the below note but didn't get any solution.

956214 - DB6: SQL0443N after upgrade to a new SAP release

1309424  -DB6: DBA Cockpit Correction Collection SAP Basis 7.01 / 7.11

Please Suggest.

Regards,

Varenyam Trivedi

[tariqmaqsood]

Hi

This is the same scenario, as ours.

On our production system I am getting this message:

SQL0420N  Invalid character found in a character string argument of the function "DECFLOAT".  SQLSTATE=22018

We have upgraded the Basis packages to the lates support package level (only Basis) on Dev and QAS - I have no error on those system anymore and DBACOCKPIT is working perfect. Production will be upgraded in next service window.

For connecting the systems to Solution Manager we have also upgraded ST-PI and ST-A/PI plugins to the latest version.

So my advice is:

Upgrade Basis to the latest SP

Upgrade ST-PI to the latest SP

Upgrade/install latest ST-A/PI

Then run DBACOCKPIT master note.

Regards

Tariq

[Former Member]

Hi Varenyam,

Please check this OSS-Note

1835822 - DB6: Compatibility Patches for IBM DB2 10.5 for LUW

I hope is can help you solve the DBACOCKPIT SQL-error.

Regards,

Andre