IBM V7.2 manual Db2inidb ts1 as standby, Db2 rollforward database ts1 to end of logs

Page 35

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 on the Primary database, make them available to the retrieve path for the Backup database. Be careful not to roll forward through a log file on the Backup server that is only partially copied to the retrieve directory.

9.On the Backup database, roll forward through the DB2 logs that have been archived from the Primary database. The rollforward command gives you the options to roll forward to end of logs or to a point in time. Rolling forward to a point in time can be useful if the intention is to keep the Backup database a constant amount of time behind the Primary database:

db2 “rollforward database ts1 to end of logs”

or

db2 “rollforward database ts1 to 2000-06-19- 19.56.00.0000”

Note: The retrieved log files are copied to /db2/TS1/log_dir by DB2 during the rollforward, which is the current mount point for the log directory. Ensure that the instance owner has write access to this directory and that the directory is large enough. When the log logical volume is copied, and /db2/TS1/log_dir is mounted, the contents of the /db2/TS1/log_dir mount point will no longer be visible. This does not cause a problem, because any log files that may have been in this directory can still be retrieved from the retrieve path.

10.Continue with iterations of the previous rollforward commands until the Primary database fails, a database application logic error occurs, or until use of the Backup database is desired.

If you do not need to roll forward through the most current logs from the Primary system, then proceed to step 16.

11.At this point, ensure all log files that have been archived on the Primary server are available to the Backup server.

12.Copy the log pair from the Primary server:

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

ts1dblog

and wait for FlashCopy task to finish.

13.Mount the log filesystem on the Backup server: mount /db2/TS1/log_dir

14.Issue a rollforward stop command on the Backup database. If a database application logic error occurred, the user must rollforward to a point-in-time

Standby Database Scenario

29

Image 35
Contents October Page AIX DB2 TrademarksTable of contents Abstract About the authors DB2 UDB suspended I/O overview Db2inidb DB2 UDB commandsSet write suspend Set write resumeDB2 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 Usr/sap SID trans SAP softwarePage Conceptual overview Sample configuration of SAP R/3 with DB2 UDB and IBM ESSCreating and assigning ESS logical volumes Installing Advanced Copy ServicesInstalling the Command Line Interface on AIX Cd /usr/opt/ibm2105cli RsList2105s.sh Lsdev -C grepConfiguring a system with two hosts ESS volumes Logical subsystem Configuring a Two Host System Create volume groups # smit vg -Add a Volume GroupCreate logical volumes Add a Volume GroupMklv -y saplv sapvg #smit lv Add a Logical Volume -VOLUME Group name dbvg#smit fs Create file systemsCrfs -v jfs -d saplv -m /usr/sap -A yes -p rw #smit fs Chown ts1admsapsys /usr/sap Chfs -a size=14000000 /db2/TS1/db2ts1/NODE0000Mount /usr/sap Usr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss Ts1sap Usr/sap/TS1/SYS/profile as followsDb2 catalog db TS1 on /db2/TS1 Db2inidb ts1 as snapshot Snapshot database scenarioDb2 set write suspend for database Usr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss ts1dbSnapshot Database Scenario Usr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss ts1dbdata Standby database scenarioUsr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss Ts1dblog Db2inidb ts1 as standbyDb2 rollforward database ts1 to end of logs Db2 rollforward database ts1 to end of logs and stop Db2 connect to ts1 Db2 set write suspend for database Split-Mirror online backup scenarioDb2 rollforward database ts1 to end of logs and stop or Db2 backup database ts1 to /backupfsDb2 restore database ts1 from /backupfs Usr/opt/ibm2105cli/rsExecuteTask.sh -v -s Esscss ts1dbwdStartsap Db2 set write resume for database Split-mirror restore scenarioDb2inidb ts1 as mirror Mount /db2/TS1/sapdata6 mount /db2/TS1/sapdata7

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.