Manuals / IBM / Computer Equipment / Server

IBM V7.2 manual DB2 UDB commands

Models: V7.2

1 41

Download 41 pages 52.55 Kb

Page 9

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

DB2 UDB commands

3

Image 9

IBM V7.2 manual DB2 UDB commands

Contents

Brigitte Bläser - IBM Germany Böblingen Laboratory OctoberEnzo Cialini - IBM Toronto Laboratory Aslam Nomani - IBM Toronto LaboratoryPage Trademarks Table of contents Table of contentsOverview Abstract AbstractAbout the authors About the authorsDB2 UDB suspended I/O overview DB2 UDB suspended I/O overviewset write suspend DB2 UDB commandsset write resume db2inidbDB2 UDB commands Overview of IBM 2105 Enterprise Storage Server SG245757 Implementing ESS Copy Services on UNIX and Windows NT/2000SG245465 IBM Enterprise Storage Server Overview of Copy Services Overview of FlashCopy Overview of the ESS Copy Services Web interface Overview of ESS Command Line Interface CLI Overview of ESS Command Line Interface CLIrsExecuteTask ESS Copy Services CLI command descriptionrsList2105s rsPrimeServerSAP software Overview of standard SAP R/3 system installation with DB2 UDBDetailed discussions about the layout of a SAP R/3 system on an ESS are contained in the following white papers FlashCopy Sample configuration of SAP R/3 with DB2 UDB and IBM ESSIBM ESS F20 Primary Backup Server Server Snapshot for reporting, testing, etcInstalling the Command Line Interface on AIX Installing Advanced Copy ServicesCreating and assigning ESS logical volumes b. Select Open Systems Storage - Modify Volume Assignments - Addcd /usr/opt/ibm2105cli rsList2105s.sh lsdev -C grepConfiguring a system with two hosts PrimaryBackup ServerServer MACHAMACHB SAP R/3 TS1Copy Services Server ESSCSS OverviewLogical subsystem ESS volumesESS volumes 009 ando hdisk42 o hdisk40 o hdisk38 o hdisk37 o hdisk43 # smit vg -Add a Volume Group # smit vg Add a Logical Volume -VOLUME GROUP name sapvg#smit lv Add a Volume Groupmklv -y saplv sapvg #smit lv Add a Logical Volume -VOLUME GROUP name dbvgConfiguring a Two Host System Alternatively, issue the following commands Create file systemsAdd a Standard Journaled File System Add a Standard Journaled File System crfs -v jfs -d saplv -m /usr/sap -A yes -p rw #smit fsMount the file systems sapenvMACHA.csh to .dbenvMACHB.csh and sapenvMACHB.csh respectively usr/sap/TS1/SYS/profile as followsChange the names of the profiles exist on the Backup server Snapshot database scenario Snapshot Database Scenario Standby database scenario db2 “rollforward database ts1 to 2000-06-19- 19.56.00.0000” db2 “rollforward database ts1 to 2000-06-19-20.57.00.0000 and stop” Split-Mirror online backup scenario stopsap startsap Split-Mirror Online Backup ScenarioSplit-Mirror Restore Scenario Split-mirror restore scenarioSummary