Db2 backup only transaction log filesSQL Server Transaction log Backup FrequencyTransaction Log backup fails if no full backup existsHow do I backup the transaction log for a mirrored database in SQL Server?Transaction log: Truncate vs. backupTransaction log backup size changeSQL Server transaction log BACKUPS are very largeMSSQL Reduce Backup/Transaction Log Size Retaining Point-In-Time RestoreExchange 2003: When do transaction logs get committed and why is the archive bit not set?Restore transaction log backup - media family errorWhat is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?
How can I support myself financially as a 17 year old with a loan?
How to explain the behaviour of TreeForm?
Sed Usage to update GRUB file
What is the most remote airport from the center of the city it supposedly serves?
Upside-Down Pyramid Addition...REVERSED!
Besides the up and down quark, what other quarks are present in daily matter around us?
Should my Json storage handle exceptions?
LightGBM results differently depending on the order of the data
In a vacuum triode, what prevents the grid from acting as another anode?
SFINAE works with deduction but fails with substitution
To customize a predefined symbol with different colors
What happens to matryoshka Mordenkainen's Magnificent Mansions?
Pressure to defend the relevance of one's area of mathematics
Why was the battle set up *outside* Winterfell?
Manager is threatning to grade me poorly if I don't complete the project
For a benzene shown in a skeletal structure, what does a substituent to the center of the ring mean?
How to improve/restore vintage Peugeot bike, or is it even worth it?
Is one octave above tonic also considered as tonic?
Do I really need diodes to receive MIDI?
Identifying my late father's D&D stuff found in the attic
Identifying a transmission to myself
What is the unit of the area when geometry attributes are calculated in QGIS?
In Avengers 1, why does Thanos need Loki?
Unknowingly ran an infinite loop in terminal
Db2 backup only transaction log files
SQL Server Transaction log Backup FrequencyTransaction Log backup fails if no full backup existsHow do I backup the transaction log for a mirrored database in SQL Server?Transaction log: Truncate vs. backupTransaction log backup size changeSQL Server transaction log BACKUPS are very largeMSSQL Reduce Backup/Transaction Log Size Retaining Point-In-Time RestoreExchange 2003: When do transaction logs get committed and why is the archive bit not set?Restore transaction log backup - media family errorWhat is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
What is the possibility to take transaction log (Archive log) backup in Db2 database.
I know that online backup takes archive log backup by default but what If I want the archive log backup after few hours of online incremental backup.
backup db2 transaction-log
asked Apr 23 at 8:27
NaveedNaveed
32
add a comment |
What is the possibility to take transaction log (Archive log) backup in Db2 database.
I know that online backup takes archive log backup by default but what If I want the archive log backup after few hours of online incremental backup.
backup db2 transaction-log
asked Apr 23 at 8:27
NaveedNaveed
32
This question really belongs on dba.stackexchange.com.
– Ian Bjorhovde
Apr 23 at 20:27
I haven't use this fourm before. But thanks for advising the same. I will be careful next time.
– Naveed
Apr 24 at 10:15
add a comment |
What is the possibility to take transaction log (Archive log) backup in Db2 database.
I know that online backup takes archive log backup by default but what If I want the archive log backup after few hours of online incremental backup.
backup db2 transaction-log
asked Apr 23 at 8:27
NaveedNaveed
32
What is the possibility to take transaction log (Archive log) backup in Db2 database.
I know that online backup takes archive log backup by default but what If I want the archive log backup after few hours of online incremental backup.
backup db2 transaction-log
backup db2 transaction-log
asked Apr 23 at 8:27
NaveedNaveed
32
asked Apr 23 at 8:27
NaveedNaveed
32
asked Apr 23 at 8:27
NaveedNaveed
32
asked Apr 23 at 8:27
NaveedNaveed
32
asked Apr 23 at 8:27
NaveedNaveed
32
32
This question really belongs on dba.stackexchange.com.
– Ian Bjorhovde
Apr 23 at 20:27
I haven't use this fourm before. But thanks for advising the same. I will be careful next time.
– Naveed
Apr 24 at 10:15
add a comment |
This question really belongs on dba.stackexchange.com.
– Ian Bjorhovde
Apr 23 at 20:27
I haven't use this fourm before. But thanks for advising the same. I will be careful next time.
– Naveed
Apr 24 at 10:15
This question really belongs on dba.stackexchange.com.
– Ian Bjorhovde
Apr 23 at 20:27
This question really belongs on dba.stackexchange.com.
– Ian Bjorhovde
Apr 23 at 20:27
I haven't use this fourm before. But thanks for advising the same. I will be careful next time.
– Naveed
Apr 24 at 10:15
I haven't use this fourm before. But thanks for advising the same. I will be careful next time.
– Naveed
Apr 24 at 10:15
add a comment |
1 Answer
1
active
oldest
votes
The answer to this depends on how you are currently backing up your archive log files now.
If you currently have set LOGARCHMETH1 to DISK:/path/, Db2 simply archives log files that contain no active transactions to the specified path. This is not a backup, this only moves the log files out of the active log path. You still need to configure normal file system backups of the archive log path to protect the archive log files that you may need for a recovery. You can perform these backups as often as you require, independently from database backups (i.e. BACKUP DATABASE).
If you're using an enterprise storage management product like TSM, NetBackup or similar, Db2 can leverage these and send the archive log files immediately to the storage manager – you would set LOGARCHMETH1 to a different value. With this kind of configuration, your archive log files can be considered to be "backed up" as soon as the archiving process completes, as the files are no longer sitting on the primary database server.
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f964169%2fdb2-backup-only-transaction-log-files%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The answer to this depends on how you are currently backing up your archive log files now.
If you currently have set LOGARCHMETH1 to DISK:/path/, Db2 simply archives log files that contain no active transactions to the specified path. This is not a backup, this only moves the log files out of the active log path. You still need to configure normal file system backups of the archive log path to protect the archive log files that you may need for a recovery. You can perform these backups as often as you require, independently from database backups (i.e. BACKUP DATABASE).
If you're using an enterprise storage management product like TSM, NetBackup or similar, Db2 can leverage these and send the archive log files immediately to the storage manager – you would set LOGARCHMETH1 to a different value. With this kind of configuration, your archive log files can be considered to be "backed up" as soon as the archiving process completes, as the files are no longer sitting on the primary database server.
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
add a comment |
The answer to this depends on how you are currently backing up your archive log files now.
If you currently have set LOGARCHMETH1 to DISK:/path/, Db2 simply archives log files that contain no active transactions to the specified path. This is not a backup, this only moves the log files out of the active log path. You still need to configure normal file system backups of the archive log path to protect the archive log files that you may need for a recovery. You can perform these backups as often as you require, independently from database backups (i.e. BACKUP DATABASE).
If you're using an enterprise storage management product like TSM, NetBackup or similar, Db2 can leverage these and send the archive log files immediately to the storage manager – you would set LOGARCHMETH1 to a different value. With this kind of configuration, your archive log files can be considered to be "backed up" as soon as the archiving process completes, as the files are no longer sitting on the primary database server.
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
add a comment |
The answer to this depends on how you are currently backing up your archive log files now.
If you currently have set LOGARCHMETH1 to DISK:/path/, Db2 simply archives log files that contain no active transactions to the specified path. This is not a backup, this only moves the log files out of the active log path. You still need to configure normal file system backups of the archive log path to protect the archive log files that you may need for a recovery. You can perform these backups as often as you require, independently from database backups (i.e. BACKUP DATABASE).
If you're using an enterprise storage management product like TSM, NetBackup or similar, Db2 can leverage these and send the archive log files immediately to the storage manager – you would set LOGARCHMETH1 to a different value. With this kind of configuration, your archive log files can be considered to be "backed up" as soon as the archiving process completes, as the files are no longer sitting on the primary database server.
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
The answer to this depends on how you are currently backing up your archive log files now.
If you currently have set LOGARCHMETH1 to DISK:/path/, Db2 simply archives log files that contain no active transactions to the specified path. This is not a backup, this only moves the log files out of the active log path. You still need to configure normal file system backups of the archive log path to protect the archive log files that you may need for a recovery. You can perform these backups as often as you require, independently from database backups (i.e. BACKUP DATABASE).
If you're using an enterprise storage management product like TSM, NetBackup or similar, Db2 can leverage these and send the archive log files immediately to the storage manager – you would set LOGARCHMETH1 to a different value. With this kind of configuration, your archive log files can be considered to be "backed up" as soon as the archiving process completes, as the files are no longer sitting on the primary database server.
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
answered Apr 23 at 20:34
Ian BjorhovdeIan Bjorhovde
44622
44622
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f964169%2fdb2-backup-only-transaction-log-files%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This question really belongs on dba.stackexchange.com.
– Ian Bjorhovde
Apr 23 at 20:27
I haven't use this fourm before. But thanks for advising the same. I will be careful next time.
– Naveed
Apr 24 at 10:15