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.
6 Comments
