I am wondering about the fact that the standby is loaded from the primary backup using restore without rolling forward. So the standby is in “roll forward pending ”. Now if you allow ROS, how can a read be done if the status is “roll forward pending “?
I managed to setup the HADR but I can't seem to figure out the TSA cluster haicu setup. The issues that I have is with the VIP and the quorum setups. For VIP I think that I need a 3rd VM but not sure. Can anyone help to setup the network. Thank you!
I have another video on my channel which talks about TSA. You do not need 3rd Node. 2 Nodes are enough to setup TSA with db2haicu. th-cam.com/video/AYfi0Odk9pA/w-d-xo.html Please watch above video.
Some HADR related parameters are Static which means they are read only when Database is started. So you do not need to restart the instance however database needs to be de-activated/activated for these parameters to take effect.
@@DB2_Oracle thanks! The thing is that primary one cant be stopped. I was thinking to configure a basic HADR. The only "special" thing the readonly on standby. Do you think that a deactivate/activate will be required?
@@RafaelFajardoguitar OK. I just tested this on DB2 11.5 and I was able to setup HADR without de-activating Primary. When I change the HADR parameters, it says, we need to re-activate the database however without re-activating, I was able to initiate the pair. Also, I did some transactions and did the takeover and those transactions were present on New Primary (Old Standby). However, below message was seen when I set the HADR Parameters. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. SQL1363W One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, the database must be shutdown and reactivated before the configuration parameter changes become effective. So, although it worked, I want you to be careful with it.
Hi Monish, Actually the LOGINDEXBUILD parameter is set to ON because it will help to log the index creation, deletion operations when a fail over is performed to standby. INDEXREC RESTART is done to rebuild the invalid indexes after a taker over operation is performed.
Thankyou Subodh.
Nicely Done. Cheers
Very good documents... I am going to setup db2 HADR for SAP... This will help me lot.... Can you please share that word doc
Very useful video bro. Clear explanation 👍
Which cluster mechanism you have used!?
I want to use pacemaker will it work!?
Yes.. It will work
I am wondering about the fact that the standby is loaded from the primary backup using restore without rolling forward. So the standby is in “roll forward pending ”. Now if you allow ROS, how can a read be done if the status is “roll forward pending “?
Excellent
I managed to setup the HADR but I can't seem to figure out the TSA cluster haicu setup. The issues that I have is with the VIP and the quorum setups. For VIP I think that I need a 3rd VM but not sure. Can anyone help to setup the network. Thank you!
I have another video on my channel which talks about TSA.
You do not need 3rd Node. 2 Nodes are enough to setup TSA with db2haicu.
th-cam.com/video/AYfi0Odk9pA/w-d-xo.html
Please watch above video.
Do I have to recycle the instance or deactivate/activate primary database after configure HADR?
Some HADR related parameters are Static which means they are read only when Database is started.
So you do not need to restart the instance however database needs to be de-activated/activated for these parameters to take effect.
@@DB2_Oracle thanks! The thing is that primary one cant be stopped. I was thinking to configure a basic HADR. The only "special" thing the readonly on standby. Do you think that a deactivate/activate will be required?
@@RafaelFajardoguitar OK. I just tested this on DB2 11.5 and I was able to setup HADR without de-activating Primary. When I change the HADR parameters, it says, we need to re-activate the database however without re-activating, I was able to initiate the pair. Also, I did some transactions and did the takeover and those transactions were present on New Primary (Old Standby). However, below message was seen when I set the HADR Parameters.
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
So, although it worked, I want you to be careful with it.
Perfect! Those parameters you changed just could take effect after reactivation. It sounds good to me. Many many thanks!
Very nice one
Why I cannot connect to my standby database when the hadr is working,it shows that "The command is not supported on an HADR standby database"
You need to enable HADR Reads on Standby feature - Set DB2_HADR_ROS Registry Variable
Hi Subodh !!! why have you set the parameters LOGINDEXBUILD ON and INDEXREC RESTART ?
Hi Monish, Actually the LOGINDEXBUILD parameter is set to ON because it will help to log the index creation, deletion operations when a fail over is performed to standby. INDEXREC RESTART is done to rebuild the invalid indexes after a taker over operation is performed.
Thanks, Can you send us the document/script you are using ?
Hi bro can share script for drop HADR database
Uploaded- Follow the link in the Description
can you post the document and the script ?
Can you post pdf and script
please share script
Its already in the description
Hi, Is there any way to contact you? I'm looking for paid services if you have.
I dont do personal trainings.