Timeline for DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 25, 2019 at 17:20 | history | edited | mustaccio | CC BY-SA 4.0 |
Moving additional info from comments to make this a self-contained answer
|
| Feb 24, 2015 at 13:31 | comment | added | Chris Aldrich | If you are speaking of HADR, generally speaking....it won't. It will read the logs and commit them to disk. It will only create its own logs if it becomes the primary. | |
| Feb 24, 2015 at 7:21 | comment | added | Dejan | Hi Chris, OK so you think this is OK. I am just concerned if database will know in which of those copied transaction logs it should write data into for the next transactions. | |
| Feb 23, 2015 at 16:57 | comment | added | Chris Aldrich | If you dont' want HADR, then yes, you could copy logs. Or even use the alternate/mirror log/archive parameters to get DB2 to copy the logs (possibly to a shared mount). | |
| Feb 23, 2015 at 16:56 | comment | added | Chris Aldrich | I know of TSA, but have not implemented HADR with it. Read up on Ember Crooks blog (db2commerce.com) for information on that. | |
| Feb 23, 2015 at 14:59 | comment | added | Dejan | Chris please tell us if this is feasible without HADR feature and TSA (I am familiar with that we implemented it for other customer but this customer does not want this option) | |
| Feb 23, 2015 at 14:52 | comment | added | Dejan | Hi Chris, no we are interested when Archive Mode is set with DISK option (unfortunately must be DISK because that is the requirement from the Customer). Please tell me if this is something which is possible or not? I am also confused little with the question from the customer but that is what they are asking us (I am aware that transaction logs are "active", database is populating them actively ) but please tell me if this is feasible or not? So we would copy ALL (online backup+archive logs+transaction logs) on another Disaster Recovery Server | |
| Feb 23, 2015 at 14:06 | history | answered | Chris Aldrich | CC BY-SA 3.0 |