IBM V7.2 Manuale Utente

Using IBM TotalStorage Enterprise Storage Server (ESS) ® with IBM® DB2® UDB Enterprise Edition V7.2 and SAP® R/3® October

Overview of IBM 2105 Enterprise Storage Server 4 Overview of IBM 2105 Enterprise Storage Server The IBM 2105 Enterprise Storage Server (ESS) provide

Overview of FlashCopy 5 Overview of Copy Services Copy Services is a separately priced feature of the ESS, which provides powerful functions for rep

Overview of FlashCopy 6

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

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 s

ESS Copy Services CLI Command Description 9 ESS Copy Services CLI command description rsExecuteTask Executes one or more predefined Copy Services S

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 i

Overview of Standard SAP R/3 System Installation with DB2 UDB 11 Detailed discussions about the layout of a SAP R/3 system on an ESS are contained in

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 w

SAP R/3 with DB2 UDB and ESS Sample Configuration 13 volume groups are created on the Primary server for the SAP system and the database, respectivel

. © Copyright International Business Machines Corporation 2002. All rights reserved.

SAP R/3 with DB2 UDB and ESS Sample Configuration 14 lsdev –C | grep 21053. Use the ESS Command Line Interface command rsList2105s to display the m

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

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 n

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

Configuring a Two Host System 18 For the Split Mirror Restore Scenario we need FlashCopy tasks for the database data filesystems only without the ‘n

Configuring a Two Host System 19 Alternatively, issue the following command: mkvg –f –y sapvg –s 64 hdisk15 # smit vg ->Add a Volume Grou

Configuring a Two Host System 20 Alternatively, issue the following command: mklv –y saplv sapvg 60 #smit lv ->Add a Logical Volume ->VO

Configuring a Two Host System 21 Alternatively, issue the following commands: mklv –y dblv dbvg 60 hdisk26mklv –y data1lv dbvg 295 hdisk9mklv –

Configuring a Two Host System 22 Alternatively, issue the following command: crfs –v jfs –d saplv –m /usr/sap –A yes –p rw #smit fs ->Add / Ch

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_dir

Trademarks iiTrademarks The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United

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

Configuring a Two Host System 25 11. On the Backup server from the db2inst1 instance, catalog the database TS1 even though the file systems that cont

Snapshot Database Scenario 26 Snapshot database scenario This scenario starts with SAP R/3 system TS1 running on the Primary server and clients usi

Snapshot Database Scenario 27

Standby Database Scenario 28 Standby database scenario This scenario starts with the SAP R/3 system TS1 running on the Primary server. On the Bac

Standby Database Scenario 29 6. Start the DB2 instance db2ts1 on the Backup server: db2start 7. Place the Backup database into a rollforwa

Standby Database Scenario 30 before the logic error occurred. If the database needs to be recovered to the point when the Primary server failed, th

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

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 su

Split-Mirror Online Backup Scenario 33 5. Start the SAP system TS1 by logging on as ts1adm user and issuing the following command: startsap

Table of contents iiiTable of contents ABSTRACT...

Split-Mirror Restore Scenario 34Split-mirror restore scenario This scenario starts with the SAP R/3 system TS1 running on the Primary server. The Ba

Split-Mirror Restore Scenario 35mount /db2/TS1/sapdata6mount /db2/TS1/sapdata7 9. Start the DB2 instance on the Primary server: db2start 10.

Abstract ivAbstract SAP® R/3™ and its components have been the success of more than 19,000 installations in enterprises of every size in more than 1

About the authors vAbout the authors Aslam Nomani has been working with the IBM Database Technology team in the Toronto Laboratory for five years.

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 capabilit

DB2 UDB commands 2DB2 UDB commands We use the following commands: set write suspend The suspend command (db2 set write suspend for database) suspe

DB2 UDB commands 3Universal Database V7 http://www7b.software.ibm.com/dmdd/library/techarticle/0204quazi/0204quazi.html..