Page 3 - Trademarks
Trademarks ii Trademarks The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: AIX DB2 DB2 Universal Database Enterprise Storage Server (ESS) ESCON FlashCopy IBM iSeries zSeries The following terms a...
Page 4 - Table of contents; Overview
Table of contents iii Table of contents ABSTRACT................................................................................................................................................. IV ABOUT THE AUTHORS ........................................................................................
Page 5 - Abstract; SAP
Abstract iv Abstract SAP ® R/3™ and its components have been the success of more than 19,000 installations in enterprises of every size in more than 106 countries worldwide. The SAP R/3 system is an open, integrated system that covers all business applications including accounting and controlling, p...
Page 6 - About the authors; Aslam Nomani; has been working with the IBM Database Technology team in the; Brigitte Bläser; has been working for IBM for 17 years. She has been engaged in; David Davis
About the authors v About the authors Aslam Nomani has been working with the IBM Database Technology team in the Toronto Laboratory for five years. For the past four years, he has worked in the DB2 UDB System Verification Test department. Aslam has worked extensively in testing DB2 UDB EE and DB2 UD...
Page 7 - DB2 UDB suspended I/O overview
DB2 UDB suspended I/O overview 1 DB2 UDB suspended I/O overview DB2 UDB v7.2 has implemented suspended I/O technology, which provides the capability to use split mirroring technology while DB2 is online. Suspended I/O supports continuous system availability by providing a full implementation for spl...
Page 8 - DB2 UDB commands; UDB documentation
DB2 UDB commands 2 DB2 UDB commands We use the following commands: set write suspend The suspend command (db2 set write suspend for database) suspends all write operations to the DB2 UDB database (i.e., to tablespaces and log files). Read operations are not suspended and are thus allowed to continue...
Page 9 - Universal Database V7
DB2 UDB commands 3 Universal Database V7 http://www7b.software.ibm.com/dmdd/library/techarticle/0204quazi/0204quazi.html ..
Page 10 - Overview of IBM 2105 Enterprise Storage Server; Implementing ESS Copy Services on UNIX and Windows NT/2000
Overview of IBM 2105 Enterprise Storage Server 4 Overview of IBM 2105 Enterprise Storage Server The IBM 2105 Enterprise Storage Server (ESS) provides superior storage sharing for Unix®, Windows NT®, Windows 2000®, Novell Netware, iSeries™ and zSeries™ servers. With the ESS any combination of these h...
Page 11 - Overview of Copy Services; The target can only be used on the same operating system.
Overview of FlashCopy 5 Overview of Copy Services Copy Services is a separately priced feature of the ESS, which provides powerful functions for replication of mission-critical data. For the Open Systems environment Copy Services offer point-in-time replication with FlashCopy and dynamic synchronous...
Page 13 - Overview of the ESS Copy Services Web interface; fctask
Overview of ESS Copy Services Web Interface 7 Overview of the ESS Copy Services Web interface The ESS Copy Services Web interface is used to create and manage Copy Services tasks. This Web interface consists of a number of HTML screens and Java™ applets and can be accessed from a standard Web browse...
Page 14 - Overview of ESS Command Line Interface (CLI)
Overview of ESS Command Line Interface (CLI) 8 Overview of ESS Command Line Interface (CLI) The ESS Command Line Interface consists of a number of scripts to communicate with the ESS Copy Services server. The Command Line Interface is Java-based and therefore requires the Java JDK version 1.1.8 to b...
Page 15 - ESS Copy Services CLI command description; rsExecuteTask; Note; rsPrimeServer; Determines PPRC status.
ESS Copy Services CLI Command Description 9 ESS Copy Services CLI command description rsExecuteTask Executes one or more predefined Copy Services Server tasks and waits for the tasks to complete execution. The command returns 0 for successful completion and greater-than zero if there is an error. . ...
Page 16 - Overview of standard SAP R/3 system installation with DB2 UDB; sapsys
Overview of Standard SAP R/3 System Installation with DB2 UDB 10 Overview of standard SAP R/3 system installation with DB2 UDB A SAP R/3 system is identified by a three character system identifier <SID> and a two digit system number between 00 and 96. The following information about the direct...
Page 18 - Sample configuration of SAP R/3 with DB2 UDB and IBM ESS; Creating a clone SAP system (; Snapshot database scenario; Creating a standby SAP database (; Standby database scenario; on page; FlashCopy; FlashCopy; System; Figure 1. Conceptual overview
SAP R/3 with DB2 UDB and ESS Sample Configuration 12 Sample configuration of SAP R/3 with DB2 UDB and IBM ESS In this configuration, we will work with a standard SAP R/3 installation and describe the following different scenarios that use the DB2 UDB split mirror functionality: • Creating a clone SA...
Page 20 - logical volumes
SAP R/3 with DB2 UDB and ESS Sample Configuration 14 lsdev –C | grep 2105 3. Use the ESS Command Line Interface command rsList2105s to display the mapping of host physical volume name to ESS volume serial number for all disks assigned to the host system: cd /usr/opt/ibm2105cli ./rsList2105s.sh 4. De...
Page 21 - Configuring a system with two hosts; C o p y S e rv ic e s S e rv e r E S S C S S; The host name of the Primary server is MACHA.
Configuring a Two Host System 15 Configuring a system with two hosts Overview 1. Install the ESS CLI on the Primary Server. 2. Assign ESS disks to both servers. 3. Install DB2 for AIX on both servers. 4. Install a standard SAP R/3 system on the Primary Server. Figure 2 shows the configuration we use...
Page 22 - ESS volumes
Configuring a Two Host System 16 • The host name of the Backup server is MACHB. • The host name of the ESS Copy Services Server is ESSCSS. • The name of the SAP system is TS1; its system number is 00. • To achieve optimal performance the disks are spread equally over all 8 LSSs of the ESS. • The Pri...
Page 23 - From each AIX server run
Configuring a Two Host System 17 o hdisk42 o hdisk40 o hdisk38 o hdisk37 o hdisk43 • The source and target volume of each FlashCopy pair reside in the same ESS LSS. Note: The root userid must be used to execute all ESS and AIX commands, and to install DB2 and create the DB2 instance. The remainder o...
Page 24 - Create volume groups
Configuring a Two Host System 18 For the Split Mirror Restore Scenario we need FlashCopy tasks for the database data filesystems only without the ‘no copy’ option. We also need FlashCopy tasks for establishing reverse FlashCopy pairs for the database data filesystems. Although these could be defined...
Page 25 - mkvg –f –y sapvg –s 64 hdisk15; Alternatively, issue the following command; Create logical volumes
Configuring a Two Host System 19 Alternatively, issue the following command: mkvg –f –y sapvg –s 64 hdisk15 # smit vg ->Add a Volume Group Alternatively, issue the following command : mkvg –f –y dbvg –s 64 hdisk9 hdisk11 hdisk21 hdisk26 hdisk28 hdisk29 hdisk33 hdisk34 hdisk41 Create logical volum...
Page 26 - Alternatively, issue the following command:; mklv –y saplv sapvg 60
Configuring a Two Host System 20 Alternatively, issue the following command: mklv –y saplv sapvg 60 #smit lv ->Add a Logical Volume ->VOLUME GROUP name [dbvg]
Page 27 - Alternatively, issue the following commands:; mklv –y dblv dbvg 60 hdisk26; Create file systems
Configuring a Two Host System 21 Alternatively, issue the following commands: mklv –y dblv dbvg 60 hdisk26 mklv –y data1lv dbvg 295 hdisk9mklv –y data2lv dbvg 295 hdisk33mklv –y data3lv dbvg 295 hdisk11mklv –y data4lv dbvg 295 hdisk29mklv –y data5lv dbvg 295 hdisk21mklv –y data6lv dbvg 295 hdisk41mk...
Page 29 - Mount the file systems:
Configuring a Two Host System 23 chfs -a size=14000000 /db2/TS1/sapdata6chfs -a size=14000000 /db2/TS1/sapdata7chfs -a size=14000000 /db2/TS1/log_dirchfs -a size=14000000 /db2/TS1/db2ts1/NODE0000 Mount the file systems: mount /usr/sap mount /db2/TS1/db2ts1/NODE0000mount /db2/TS1/sapdata1mount /db2/T...
Page 30 - Installation Guide; to
Configuring a Two Host System 24 /db2/TS1/log_dir . Loading the data into the database may last several hours. For more details about installing an SAP R/3 system please refer to the SAP R/3 Installation Guide . 8. Flash the SAP software to the target disk and system: a. Create the group dbts1adm an...
Page 32 - db2 “set write resume for database”
Snapshot Database Scenario 26 Snapshot database scenario This scenario starts with SAP R/3 system TS1 running on the Primary server and clients using the Primary database. The Backup server has TS1 and DB2 stopped and DB2 file systems for data and logs unmounted. 1. From the Primary Server issue the...
Page 34 - in the directory; Windows
Standby Database Scenario 28 Standby database scenario This scenario starts with the SAP R/3 system TS1 running on the Primary server. On the Backup server, TS1 is stopped and the DB2 filesystems for data and logs are unmounted. This scenario assumes that the FlashCopy pairs and tasks are already de...
Page 35 - db2start; rollforward; db2 “rollforward database ts1 to end of logs”; or; ts1dblog
Standby Database Scenario 29 6. Start the DB2 instance db2ts1 on the Backup server: db2start 7. Place the Backup database into a rollforward pending state, and take it out of its suspended state: db2inidb ts1 as standby 8. As DB2 log files are successfully getting archived to the archive directory o...
Page 36 - db2 “rollforward database ts1 to end of logs and stop”; command
Standby Database Scenario 30 before the logic error occurred. If the database needs to be recovered to the point when the Primary server failed, then a rollforward to end of logs should be performed: db2 “rollforward database ts1 to end of logs and stop” or db2 “rollforward database ts1 to 2000-06-1...
Page 37 - Split-Mirror online backup scenario; SAP Database Administration Guide: IBM DB2
Split-Mirror Online Backup Scenario 31 Split-Mirror online backup scenario This scenario starts with the SAP R/3 system TS1 running on the Primary server. The Backup server has TS1 stopped and DB2 file systems for data and logs unmounted. Attention: This scenario is currently not supported for datab...
Page 38 - restore
Split-Mirror Online Backup Scenario 32 7. The following command places the Backup database into a rollforward pending state and take it out of a suspended state: db2inidb ts1 as standby 8. Perform a DB2 backup on the Backup server using the supported backup system: db2 “backup database ts1 to /backu...
Page 39 - startsap
Split-Mirror Online Backup Scenario 33 5. Start the SAP system TS1 by logging on as ts1adm user and issuing the following command: startsap
Page 40 - Split-mirror restore scenario
Split-Mirror Restore Scenario 34 Split-mirror restore scenario This scenario starts with the SAP R/3 system TS1 running on the Primary server. The Backup server has TS1 stopped and DB2 file system for data and logs unmounted. 1. Edit the userexit program and place it in the appropriate directory on ...
Page 41 - Start the DB2 instance on the Primary server:; and issuing the following command:; Summary
Split-Mirror Restore Scenario 35 mount /db2/TS1/sapdata6mount /db2/TS1/sapdata7 9. Start the DB2 instance on the Primary server: db2start 10. On the Primary database issue the db2inidb command to take the database image out of a suspended state and place it into a rollforward pending state: db2inidb...
