Skip to Content
In today’s post I’d like to talk about news regarding the installation procedure of DB2 and a new possibility to generate a script for a ‘redirected restore’ to copy a database. h4. Feature: Script generation for a redirected restore SAP provides the guides ‘Homogeneous and Heterogeneous System Copy for SAP Systems’ for various SAP releases on the SAP Service Marketplace. They contain a general method (using R3load or Jload) and database specific procedures for all supported DB platforms (like the backup/restore method described above). For Netweaver 04 you will find the guides {code:html}here{code}, for Netweaver 2004s they are available {code:html}here{code} (look at ‘Installation – SAP NetWeaver 2004s’). Using RESTORE…GENERATING SCRIPT replaces (part of the) functionality which was so far delivered by the SAP tool brdb6brt. See the {code:html}Database Administration Guide{code} for Details. 0.1.  Sometimes you may want to copy not the complete database but only a subset of the data. If this is the case have a look at a new SAP product called {code:html}TDMS{code} (Test Data Migration Server). h4. New Installation Features Up to DB2 Version 8 the installation path for the DB2 Software was fixed. In V9 there are now default installation paths for the various operating systems, but you now have also the possibility to choose the installation path. The following table gives an overview of the (default) installation paths in V8 and V9.   | Operating System | Fixed install path in DB2 V8 | Default install path in DB2 V9 | | Linux | /opt/IBM/db2/V8.1 | /opt/ibm/db2/V9.1 | | AIX | /usr/opt/db2_08_01 | /opt/IBM/db2/V9.1 | | HP-UX | /opt/IBM/db2/V8.1 | /opt/IBM/db2/V9.1 | | Solaris | /opt/IBM/db2/V8.1 | /opt/IBM/db2/V9.1 | | Windows | x:Program FilesIBMsqllib | x:Program FilesIBMsqllib |  Note especially the changes in the installation path on AIX and Linux. The possibility to choose the installation path is a prerequisite for another new feature: it is now feasible to install the DB2 software multiple times on one host. Every install is called a ‘DB2 copy’. One of the benefits is that the DB2 copies must not have the same code level. You can now have multiple DB2 installations with different fixpak levels on one computer. So it is e.g. possible to apply a fixpak to one copy and test it before applying it to the other copies – all on one server. SAP will use these installation improvements in the upcoming SAP Netweaver 2007 Release. The installation of DB2 will be integrated into the SAP installation tool sapinst as a ‘silent install’. Also, the DB2 software will be installed by default in the home directory of the DB2 instance owner. This allows for multiple SAP systems with their own DB2 software level on one server. The following UML deployment diagram shows a production and a test system on one box.image
To report this post you need to login first.


You must be Logged on to comment or reply to a post.

    1. Johannes Heinrich
      Post author

      the ‘silent install feature’ in the sense that the DB2 software is installed by sapinst is available with SAP Netweaver 2007. Before (and also on 2004s) you had to install DB2 manually before starting sapinst.


      1. Former Member
        Hello Johannes and Raghu,

        I think the ‘silent install feature’ is available with NetWeaver 2004s/DB2 v8/Windows.
        And it is not supported with DB2 9 yet as Johannes mentioned. 
        I feel it is a bit confusing…

        I hope it will be available with DB2 9 soon!

        Best regards,

      2. Former Member
        We have DB2 running n Aix 5.2 verison for our unicode SAP systems.

        We are building new systems uisng the exisitng systems using system copies. So far we did 3 systems and when we hit the 4th system we noticed that the ‘brdb6brt -s TST -bm RETRIEVE -replace TST=FST; command generate a script that by passed the all the tablespace except system tablespace. Not sure what the issue here. Can someone let us know the root cause and solution to it. On source system we have 15+ tablesapce but they are not generated in to .scr script to restore the backup on target system.

        Please see the ./scr file as follows.


Leave a Reply