English dropdown-ico

Manual IBM V7.2

41 pages 0.36 mb
Download

Go to site of 41

Summary
  • IBM V7.2 - page 1

    Using IBM TotalStorage Enterprise Storage Server (ESS) ® with IBM ® DB2 ® UDB Enterprise Edition V7.2 and SAP ® R/3 ® October 2002 Brigit t e Bläser – IBM Germ any Böblingen Laboratory Enzo Cialini – IBM T oronto Laboratory Aslam Nomani – IBM T oronto Laboratory David Davis – IBM Storage Systems Group ...

  • IBM V7.2 - page 2

    . © Copy right International Business Machines Corporation 2002. All r ights reserved. ...

  • IBM V7.2 - page 3

    Trademarks ii Trademarks The f ollowing terms are t r adem ar k s or reg istered tradem ar ks of Internat ional Business Machines Corporation in the United St at es, ot her countries, or both: AIX DB2 DB2 Universal Database Enterprise St or age Server (ESS) ESCON FlashCopy IBM iSeries zSer ies The f ollowing terms are t rademark s SAP AG in Ger m a ...

  • IBM V7.2 - page 4

    Table of contents iii Table of contents ABSTRACT....................................................................................................................... .......................... IV ABOUT THE AUTHORS ........................................................................................................................... V DB2 UDB ...

  • IBM V7.2 - page 5

    Abstract iv A bstract SAP ® R/3™ and its components have been the success of more than 19, 000 installations in enter pr ises of every size in more than 106 countries worldwide. The SAP R/3 system is an open, int eg rated system t hat covers all business applicat ions including accounting and cont r olling , production and m at er ials managemen ...

  • IBM V7.2 - page 6

    About the authors v A bout the authors A slam No mani has been working with the I BM Database Technolog y team in the Toront o Labor at or y f or f ive years. For the past four years, he has work ed in t he DB2 UDB System Verificat ion Test depar tment. Aslam has worked extensively in testing DB2 UDB EE and DB2 UDB EEE in a high availability enviro ...

  • IBM V7.2 - page 7

    DB2 UDB sus pended I/O ov erview 1 DB2 UDB suspended I/O over vi ew DB2 UDB v 7.2 has implemented suspended I/O technology, w hich prov ides the capability to use split mirroring technology while DB2 is online. Suspended I/O supports continuous system availability by providing a full im plementation f or splitt ing a mirr or (pair) without shutt in ...

  • IBM V7.2 - page 8

    DB2 UDB co mmands 2 DB2 UDB commands W e use t he f ollowing commands: set w rite suspend The suspend command ( db2 set write suspend for dat abase) suspends all write operations to t he DB2 UDB dat abase (i.e., t o t ablespaces and log f iles) . Read operations are not suspended and ar e t hus allowed to continue. Applications can continue to proc ...

  • IBM V7.2 - page 9

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

  • IBM V7.2 - page 10

    Overvi ew of IBM 2105 Ent erprise St orage Serv er 4 Overv iew of IBM 2105 Enterprise Storage Server The IBM 2105 Enterprise St or ag e Server (ESS) pr ovides superior st orage sharing for Unix®, W indows NT®, W indow s 2000®, Novell Netware, iSeries™ and zSeries™ servers. W ith the ESS any combination of t hese het er og eneous platf or ms ...

  • IBM V7.2 - page 11

    Overview of FlashC opy 5 Overv iew of Copy Serv ices Copy Services is a separately priced feat ur e of the ESS, which provides powerful funct ions f or replicat ion of mission-crit ical dat a. For the O pen System s environment Copy Services off er point - in-time replicat ion with FlashCopy and dynamic synchronous mirror ing to a remot e ESS with ...

  • IBM V7.2 - page 12

    Overview of FlashC opy 6 ...

  • IBM V7.2 - page 13

    Overview of ESS Copy Services Web Interf ace 7 Overview of the ESS Copy Services Web interface The ESS Copy Services W eb int er f ace is used to creat e and m anage Copy Services tasks. T his W eb int er f ace consists of a number of HTML screens and Java™ applets and can be accessed from a standard W eb browser. A Copy Services task consists of ...

  • IBM V7.2 - page 14

    Overview of ESS Com man d Line In terface (CL I) 8 Overview of ESS Command Line Interface (CLI) The ESS Command Line I nterf ace consists of a num ber of scripts t o com m unicate with the ESS Copy Services server. The Comm and Line I nterf ace is Java-based and theref ore requir es the Java JDK version 1.1.8 to be installed on each host system fr ...

  • IBM V7.2 - page 15

    ESS Copy Serv ices CLI C omm an d Description 9 ESS Copy Serv ices CLI command description rsExecuteTask Executes one or more predef ined Copy Services Server tasks and waits f or the task s t o complete execution. T he com m and r eturns 0 f or successf ul completion and g reater-t han zero if t her e is an er r or. . Note : For FlashCopy task s, ...

  • IBM V7.2 - page 16

    Overview of Standard SAP R/3 Sy stem Ins tallation w ith DB2 UDB 10 Overview of standar d SA P R/3 sy stem installa ti on w ith DB2 UDB A SAP R/3 system is identif ied by a three character system identif ier <SI D> and a two digit system number bet ween 00 and 96. The f ollowing informa t ion about t he dir ect ory structure applies t o a Cen ...

  • IBM V7.2 - page 17

    Overview of Standard SAP R/3 Sy stem In stallation w ith DB2 UDB 11 Detailed discussions about the layout of a SAP R/3 system on an ESS ar e cont ained in the f ollowing white papers: • Sanjoy Das, Siegf ried Schmidt , Jens Claussen, BalaSanni Godavari: “ St or ag e Management f or SAP and DB2 UDB: Split Mirror Back up / Recovery with IBM Enter ...

  • IBM V7.2 - page 18

    SAP R/3 with DB2 UDB and ESS Sample Config uration 12 Sample configur ati on of SA P R/3 w ith DB2 UDB and IBM ESS In this conf igurat ion, we will w ork with a standard SAP R/3 installat ion and describe the following dif fer ent scenarios that use t he DB2 UDB split mirror f unctionality: • Creating a clone SAP system ( Snapshot dat abase scena ...

  • IBM V7.2 - page 19

    SAP R/3 with DB2 UDB and ESS Sample Config uration 13 volume groups are cr eat ed on t he Primary server f or the SAP system and the dat abase, respecti vely . DB2 Universal Database v7.2 for AIX® is used; DB2 UDB suspended I/O capabilities are available on all platfor m s suppor t ed by DB2 UDB. An IBM ESS 2105 F20 is used. The same scenarios als ...

  • IBM V7.2 - page 20

    SAP R/3 with DB2 UDB and ESS Sample Config uration 14 lsdev –C | grep 2105 3. Use the ESS Command Line I nt erf ace com m and r s List 2105s t o display the mapping of host physical volume name to ESS volume serial num ber f or all disk s assigned to the host system: cd /usr/opt/ibm2105cli ./rsList2105s.sh 4. Determine t he SCSI pat hs and disks ...

  • IBM V7.2 - page 21

    Configuri ng a Two Ho st System 15 Configuring a system with two hosts Overv iew 1. Install t he ESS CLI on t he Primary Server. 2. Assign ESS disks to both servers. 3. Install DB2 f or AIX on bot h servers. 4. Install a standar d SAP R/3 system on the Pr im ar y Server. Figure 2 shows the conf iguration we used f or t he FlashCopy examples. Pr i m ...

  • IBM V7.2 - page 22

    Configuri ng a Two Ho st System 16 • The host nam e of the Back up ser ver is MACHB. • The host nam e of the ESS Copy Services Server is ESSCSS. • The name of the SAP system is T S1; it s system num ber is 00. • To achieve optimal perf ormance t he disks are spr ead eq ually over all 8 LSSs of the ESS. • The Primar y server uses the sourc ...

  • IBM V7.2 - page 23

    Configuri ng a Two Ho st System 17 o hdisk42 o hdisk40 o hdisk38 o hdisk37 o hdisk43 • The source and t ar g et volume of each FlashCopy pair reside in t he same ESS LSS. Note: T he root userid must be used to execute all ESS and AIX com m ands, and to install DB2 and create t he DB2 inst ance. The rem ainder of t he DB2 commands are executed fro ...

  • IBM V7.2 - page 24

    Configuri ng a Two Ho st System 18 For the Split Mirror Rest or e Scenar io we need FlashCopy tasks f or the database data f ilesystems only without the ‘no copy’ option. W e also need FlashCopy tasks f or establishing r everse FlashCopy pairs for t he dat abase data f ilesystems. Alt hough these could be def ined with the no copy option this i ...

  • IBM V7.2 - page 25

    Configuri ng a Two Ho st System 19 Alternatively , issue the following command: mkvg –f –y sapvg –s 64 hdisk15 # smit vg ->A dd a Volume Group Alternatively, issue the f ollowing command : mkvg –f –y dbvg –s 64 hdisk9 hdisk11 hdisk21 hdisk26 hdisk28 hdisk29 hdisk33 hdisk34 hdisk41 Create logical volumes The f ollowing procedure creat ...

  • IBM V7.2 - page 26

    Configuri ng a Two Ho st System 20 Alternatively, issue the f ollowing command: mklv –y saplv sapvg 60 #smit lv ->A dd a Logical Volume - > VO LUME GROUP name [dbvg] ...

  • IBM V7.2 - page 27

    Configuri ng a Two Ho st System 21 Alternatively, issue the f ollowing commands: mklv –y dblv dbvg 60 hdisk26 mklv –y data1lv dbvg 295 hdisk9 mklv –y data2lv dbvg 295 hdisk33 mklv –y data3lv dbvg 295 hdisk11 mklv –y data4lv dbvg 295 hdisk29 mklv –y data5lv dbvg 295 hdisk21 mklv –y data6lv dbvg 295 hdisk41 mklv –y data7lv dbvg 295 hd ...

  • IBM V7.2 - page 28

    Configuri ng a Two Ho st System 22 Alternatively, issue the f ollowing command: crfs –v jfs –d saplv –m /usr/sap –A yes –p rw #smit fs ->A dd / Ch ange / Show / Delete File Sy stems ->Jou rnaled File Sy stems - >A dd a Journal ed Fi l e Sy stem on a Previously Defined Logical Volume ->A dd a Standard Journaled Fil e System Alt ...

  • IBM V7.2 - page 29

    Configuri ng a Two Ho st System 23 chfs -a size=14000000 /db2/TS1/sapdata6 chfs -a size=14000000 /db2/TS1/sapdata7 chfs -a size=14000000 /db2/TS1/log_dir chfs -a size=14000000 /db2/TS1/db2ts1/NODE0000 Mount the file systems: mount /usr/sap mount /db2/TS1/db2ts1/NODE0000 mount /db2/TS1/sapdata1 mount /db2/TS1/sapdata2 mount /db2/TS1/sapdata3 mount / ...

  • IBM V7.2 - page 30

    Configuri ng a Two Ho st System 24 /db2/TS1/log_dir . Loading the dat a int o t he database may last several hours. For more det ails about installing an SAP R/ 3 system please r ef er to t he SAP R/3 Install ation Gui de . 8. Flash the SAP sof t ware to t he t arget disk and system: a. Create the g roup dbts1adm and t he user t s 1adm on t he t ar ...

  • IBM V7.2 - page 31

    Configuri ng a Two Ho st System 25 11. On t he Backup server f rom the db2inst 1 inst ance, catalog t he dat abase T S1 even though the f ile systems that cont ain t he dat abase TS1 does not curr ent ly exist on the Backup server: db2 “catalog db TS1 on /db2/TS1” The base conf iguration is now done and the f ollowing sections will provide exam ...

  • IBM V7.2 - page 32

    Snapshot Databas e Scenario 26 Snapshot database scenario This scenario st ar t s with SAP R/3 system T S1 running on t he Pr im ar y server and clients using the Pr im ar y database. T he Backup server has T S1 and DB2 stopped and DB2 file systems for dat a and log s unmounted. 1. From the Pr im ar y Server issue t he suspend com m and on t he Pri ...

  • IBM V7.2 - page 33

    Snapshot Databas e Scenario 27 ...

  • IBM V7.2 - page 34

    Standby Database Scenario 28 Standby database scenario This scenario st ar t s with the SAP R/ 3 system T S1 running on the Pr imary server. On t he Backup server, T S1 is stopped and the DB2 f ilesystems for dat a and logs are unmounted. T his scenario assumes that t he FlashCopy pairs and t ask s are already defined on t he ESS Copy Services Serv ...

  • IBM V7.2 - page 35

    Standby Database Scenario 29 6. Start t he DB2 inst ance db2ts1 on the Back up ser ver: db2start 7. Place the Backup dat abase int o a rollf or ward pending st at e, and tak e it out of it s suspended state: db2inidb ts1 as standby 8. As DB2 log f iles are successfully g et t ing archived to the ar chive direct or y on the Primary database, m ak e ...

  • IBM V7.2 - page 36

    Standby Database Scenario 30 befor e t he log ic error occurr ed. I f the dat abase needs t o be recovered to the point when the Primary server f ailed, then a r ollf orward to end of logs should be perf ormed: db2 “rollforward database ts1 to end of logs and stop” or db2 “rollforward database ts1 to 2000-06-19-20.57.00.0000 and stop” 15. S ...

  • IBM V7.2 - page 37

    Split-Mirror Online Backup Scenario 31 Split-Mirror online backup scenario This scenario st ar t s with the SAP R/ 3 system T S1 running on the Pr imary server. The Backup server has T S1 st opped and DB2 f ile systems f or data and logs unmount ed. A tt ention: T his scenar io is cur r ently not supported f or databases t hat cont ain SMS tablespa ...

  • IBM V7.2 - page 38

    Split-Mirror Online Backup Scenario 32 7. The f ollowing command places the Back up dat abase into a rollf orward pending state and tak e it out of a suspended state: db2inidb ts1 as standby 8. Perf or m a DB2 back up on the Backup ser ver using the support ed back up system: db2 “backup database ts1 to /backupfs” 9. Stop the DB2 instance on t ...

  • IBM V7.2 - page 39

    Split-Mirror Online Backup Scenario 33 5. Start t he SAP system T S1 by logging on as t s1adm user and issuing t he following comm and: startsap ...

  • IBM V7.2 - page 40

    Split-Mirror Restore Scenario 34 Split-mirror restore scenario This scenario st ar t s with the SAP R/ 3 system T S1 running on the Pr imary server. The Back up ser ver has T S1 st opped and DB2 f ile system f or data and logs unmounted. 1. Edit the userexit pr og ram and place it in t he appropriate dir ect ory on the Primar y server so DB2 knows ...

  • IBM V7.2 - page 41

    Split-Mirror Restore Scenario 35 mount /db2/TS1/sapdata6 mount /db2/TS1/sapdata7 9. Start t he DB2 instance on the Prim ar y server: db2start 10. On t he Pr im ar y database issue the db2inidb command to t ak e the database image out of a suspended state and place it into a rollf orward pending state: db2inidb ts1 as mirror 11. O n t he Pr im ary d ...

Manufacturer IBM Category Server

Documents that we receive from a manufacturer of a IBM V7.2 can be divided into several groups. They are, among others:
- IBM technical drawings
- V7.2 manuals
- IBM product data sheets
- information booklets
- or energy labels IBM V7.2
All of them are important, but the most important information from the point of view of use of the device are in the user manual IBM V7.2.

A group of documents referred to as user manuals is also divided into more specific types, such as: Installation manuals IBM V7.2, service manual, brief instructions and user manuals IBM V7.2. Depending on your needs, you should look for the document you need. In our website you can view the most popular manual of the product IBM V7.2.

Similar manuals

A complete manual for the device IBM V7.2, how should it look like?
A manual, also referred to as a user manual, or simply "instructions" is a technical document designed to assist in the use IBM V7.2 by users. Manuals are usually written by a technical writer, but in a language understandable to all users of IBM V7.2.

A complete IBM manual, should contain several basic components. Some of them are less important, such as: cover / title page or copyright page. However, the remaining part should provide us with information that is important from the point of view of the user.

1. Preface and tips on how to use the manual IBM V7.2 - At the beginning of each manual we should find clues about how to use the guidelines. It should include information about the location of the Contents of the IBM V7.2, FAQ or common problems, i.e. places that are most often searched by users in each manual
2. Contents - index of all tips concerning the IBM V7.2, that we can find in the current document
3. Tips how to use the basic functions of the device IBM V7.2 - which should help us in our first steps of using IBM V7.2
4. Troubleshooting - systematic sequence of activities that will help us diagnose and subsequently solve the most important problems with IBM V7.2
5. FAQ - Frequently Asked Questions
6. Contact detailsInformation about where to look for contact to the manufacturer/service of IBM V7.2 in a specific country, if it was not possible to solve the problem on our own.

Do you have a question concerning IBM V7.2?

Use the form below

If you did not solve your problem by using a manual IBM V7.2, ask a question using the form below. If a user had a similar problem with IBM V7.2 it is likely that he will want to share the way to solve it.

Copy the text from the picture

Captcha
New picture

Comments (0)