Home » Posts tagged 'DB2'

Tag Archives: DB2

Un-officially SAP OSDB Migration Project done !!

Another project have been completed by me this year.

Since the sister company (formerly I maintain) moved to hyperconverged Nutanix and used Acropolis as its hypervisor, there is a SAP R / 3 4.7 ext 200 system running on HP rx4640 machine with HPUX 11.23 OS and Oracle 9.2 database server that must be migrated to a Nutanix machine . HP rx4640 machine is not extended maintenance support. While the system, SAP R / 3 4.7 ext 200 is also not supported by SAP both SAP instance and database server.

Target using Linux OS SLES 11 SP4 and DB2 database server 9.7 FP 5.

Broadly speaking the migration process is :

    – Export existing data in SAP R / 3 4.7 ext 200 on HPUX source machine
Install DB2 9.7 database server on target Linux
Install Central Instance on Linux target
Install Database instance in Linux target by selecting System Copy and export result (process no.1) as imported data.

The export process runs smoothly. Problems begin to emerge during process no.4 of them:

The process of database load had stopped because the file system is full sapdata. Solution: extend the sapdata partition and the file system
The database load process was stopped again because the file system is a full archive log. Solution: extend the partition and add the number of LOGARCHIVE second files.

After the import process is complete, there are still more problems that arise, the SAP kernel 6.40 used does not recognize the linux 3.0 kernel (used SLES 11 SP 4) and DB2 9.7 database. The solution is download the latest version of SAP kernel 6.40 EX2 patch (version 414).

Project un-official SAP OSDB migration done by un-certified Base like me

Installation SAP NetWeaver 7.4 using DB2 10.5 FP 3 on SLES 11 SP 4


Lately I have upload some video on how to install SAP NetWeaver 7.4. I am using DB2 10.5 FP 3 as database server and using SuSE Linux Enterprise Server 11 SP 4.

Preparation check before installation.

Installation video.

part 1

part 2

Enjoy !!

IBM DB2 10.1 has been supported by SAP

Finally, IBM DB2 10.1 has been supported by SAP. There are a lot of improvement whic had been done by IBM on DB2 10.1 such as Adaptive Compression (prior than Deep Compression which now mentioned as Static Compression), Log Compression, etc.

SAP has just certified DB2 10.1 this July 2012.

There are several SAP Notes need to be read and implement if you want to use DB2 10.1.

sapnote_0001700631_DB6: Using DB2 10.1 with SAP Applications

sapnote_0001701181_DB6: ABAP DDIC: Enhancements for DB2 10.1

sapnote_0001692571_DB6: DB2 10.1 Standard Parameter Settings

sapnote_0001365982_DB6: Current db6_update_db_db6_update_client script (V 27)

Right now, I also doing some research on this DB2 10.1 using SAP ERP 6 EHP 5.

Happy hacking, guys !!

SAP DBA Cockpit ebook download


Its great to share this great ebook.

Title  : “SAP DBA COCKPIT – Flight Plans for DB2 LUW Database Administrators”

This ebook format is PDF. You can download it here or directly here (http://www.ziddu.com/downloadlink/9987177/COCKPIT-FlightPlansforDB2LUWDatabaseAdministrators.pdf) or here (http://ugotfile.com/file/1547172/SAP DBA COCKPIT – Flight Plans for DB2 LUW Database Administrators.pdf).

Happy downloading and enjoy it.

SAP Basis & Virtualization Services

Hi guys,

I am offering Remote SAP Basis Support and Service to your company. No matter your company have dedicated SAP Basis or not, we can help you. Your company could hire me as Remote SAP Basis.

I also have virtualization support on VMware, Proxmox VE, Linux, Oracle, and DB2. Usually, I support my client via TeamViewer connection.

You can contact me through

Email : devratt@yahoo.com
Phone/SMS/WA/Telegram : +62-81336451502