IBM V7.2 manual Split-mirror restore scenario, Db2 set write resume for database

Page 40

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 the Primary server so DB2 knows where archived logs are located. The user exit program will archive the logs.

2.Issue the suspend command on the Primary database:

db2 “connect to ts1”

db2 “set write suspend for database”

3.Execute the FlashCopy task ts1dbdata from the Primary server as root user:

/usr/opt/ibm2105cli/rsExecuteTask.sh –v –s ESSCSS

ts1dbdatafc

Wait for rsExecuteTask to return.

4.Issue the resume command from the same connection in Step 2:

db2 “set write resume for database”

5.If the Primary database gets corrupted due to a database application error or some other error that prevents the database from being restarted, another FlashCopy task that copies the former target volumes to the former source volumes can then be executed. At this point, DB2 should no longer be running on the Primary server.

6.Unmount the /db2/TS1/… data file systems on the Primary server:

umount /db2/TS1/db2ts1/NODE0000 umount /db2/TS1/sapdata1 umount /db2/TS1/sapdata2 umount /db2/TS1/sapdata3 umount /db2/TS1/sapdata4 umount /db2/TS1/sapdata5 umount /db2/TS1/sapdata6 umount /db2/TS1/sapdata7

7.Execute the FlashCopy task ts1dbrev from the Primary server as root user:

/usr/opt/ibm2105cli/rsExecuteTask.sh –v –s ESSCSS

ts1dbdatarevfc

Wait for rsExecuteTask to return.

8.Mount the /db2/TS1/… data file systems on the Primary server:

mount /db2/TS1/db2ts1/NODE0000 mount /db2/TS1/sapdata1 mount /db2/TS1/sapdata2 mount /db2/TS1/sapdata3 mount /db2/TS1/sapdata4 mount /db2/TS1/sapdata5

Split-Mirror Restore Scenario

34

Image 40
Contents October Page Trademarks AIX DB2Table of contents Abstract About the authors DB2 UDB suspended I/O overview DB2 UDB commands Set write suspendSet write resume Db2inidbDB2 UDB commands Overview of IBM 2105 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 ESS Copy Services CLI command description SAP software Usr/sap SID transPage Sample configuration of SAP R/3 with DB2 UDB and IBM ESS Conceptual overviewInstalling the Command Line Interface on AIX Installing Advanced Copy ServicesCreating and assigning ESS logical volumes Lsdev -C grep Cd /usr/opt/ibm2105cli RsList2105s.shConfiguring a system with two hosts ESS volumes Logical subsystem Configuring a Two Host System # smit vg -Add a Volume Group Create volume groupsAdd a Volume Group Create logical volumesAdd a Logical Volume -VOLUME Group name dbvg Mklv -y saplv sapvg #smit lvCreate file systems #smit fsCrfs -v jfs -d saplv -m /usr/sap -A yes -p rw #smit fs Mount /usr/sap Chfs -a size=14000000 /db2/TS1/db2ts1/NODE0000Chown ts1admsapsys /usr/sap Usr/sap/TS1/SYS/profile as follows Usr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss Ts1sapDb2 catalog db TS1 on /db2/TS1 Snapshot database scenario Db2 set write suspend for databaseUsr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss ts1db Db2inidb ts1 as snapshotSnapshot Database Scenario Standby database scenario Usr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss ts1dbdataDb2 rollforward database ts1 to end of logs Db2inidb ts1 as standbyUsr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss Ts1dblog Db2 rollforward database ts1 to end of logs and stop Split-Mirror online backup scenario Db2 connect to ts1 Db2 set write suspend for databaseDb2 backup database ts1 to /backupfs Db2 restore database ts1 from /backupfsUsr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss ts1dbwd Db2 rollforward database ts1 to end of logs and stop orStartsap Split-mirror restore scenario Db2 set write resume for databaseMount /db2/TS1/sapdata6 mount /db2/TS1/sapdata7 Db2inidb ts1 as mirror

V7.2 specifications

IBM V7.2 represents a significant advancement in IBM's software solutions, offering enhanced capabilities and features that cater to businesses looking to optimize their data and application management. This version builds on the strengths of its predecessors while introducing innovative technologies that make it more robust and user-friendly.

One of the standout features of IBM V7.2 is its emphasis on data security. With the increasing threats to data integrity and privacy, IBM has integrated advanced security protocols to protect sensitive information. This includes enhanced encryption methods and access controls that ensure only authorized personnel can access critical data. Organizations can now manage their compliance requirements more effectively, reducing the risk of data breaches and meeting regulatory standards.

Another crucial characteristic of IBM V7.2 is its cloud-native capabilities. The updated platform supports modern cloud architectures, allowing businesses to transition to hybrid environments seamlessly. This versatility enables companies to utilize public and private clouds according to their specific needs, enhancing flexibility and scalability. Furthermore, IBM V7.2 leverages containerization technologies, which simplifies application deployment and management across diverse environments.

Performance improvements are also a key aspect of IBM V7.2. It introduces optimizations that accelerate data processing, allowing users to interact with applications and data more efficiently. The system’s enhanced memory management and workload automation capabilities ensure that resources are allocated optimally, reducing latency and improving overall operational efficiency.

Collaboration and integration are further enhanced in this version, making it easier for teams to work together and share insights. The platform includes tools that facilitate seamless integration with other enterprise applications, allowing organizations to streamline workflows and improve productivity.

Moreover, IBM V7.2 features AI-driven analytics, enabling organizations to harness their data for more informed decision-making. The inclusion of machine learning tools allows users to derive insights from large datasets, significantly benefiting business intelligence initiatives.

In summary, IBM V7.2 is a modern, secure, and efficient platform packed with features that address the evolving needs of businesses. Its focus on data security, cloud-native functionalities, performance enhancements, collaboration tools, and AI-driven analytics makes it a compelling choice for organizations eager to leverage technology for growth and innovation.