Recovery model of current database
I want to know how can I change the recovery model of my current database. I am having sysadm rights.Operating system is windows, Db2 10.5.
can some one let me know the command please
db2
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Dec 17 '14 at 11:19
This question came from our site for professional and enthusiast programmers.
add a comment |
I want to know how can I change the recovery model of my current database. I am having sysadm rights.Operating system is windows, Db2 10.5.
can some one let me know the command please
db2
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Dec 17 '14 at 11:19
This question came from our site for professional and enthusiast programmers.
What do you understand by recovery model? this is too broad. BTW, this question does not belong to SOF.
– AngocA
Dec 17 '14 at 10:07
Thanks for the reply.I want to set my recovery model to simple.According to my understanding at certain point of time database requires some recovery .This recovery can be done in simple,full,checked etc. I just want to find out my current recovery model & to change that model to simple.Kindly excuse me if i am wrong at any point. new to db2
– HABBIE
Dec 17 '14 at 10:23
You are confusing DB2 and SQL Server.
– mustaccio
Dec 17 '14 at 12:30
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
– Chris Aldrich
Dec 17 '14 at 14:15
add a comment |
I want to know how can I change the recovery model of my current database. I am having sysadm rights.Operating system is windows, Db2 10.5.
can some one let me know the command please
db2
I want to know how can I change the recovery model of my current database. I am having sysadm rights.Operating system is windows, Db2 10.5.
can some one let me know the command please
db2
db2
asked Dec 17 '14 at 10:01
HABBIE
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Dec 17 '14 at 11:19
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Dec 17 '14 at 11:19
This question came from our site for professional and enthusiast programmers.
What do you understand by recovery model? this is too broad. BTW, this question does not belong to SOF.
– AngocA
Dec 17 '14 at 10:07
Thanks for the reply.I want to set my recovery model to simple.According to my understanding at certain point of time database requires some recovery .This recovery can be done in simple,full,checked etc. I just want to find out my current recovery model & to change that model to simple.Kindly excuse me if i am wrong at any point. new to db2
– HABBIE
Dec 17 '14 at 10:23
You are confusing DB2 and SQL Server.
– mustaccio
Dec 17 '14 at 12:30
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
– Chris Aldrich
Dec 17 '14 at 14:15
add a comment |
What do you understand by recovery model? this is too broad. BTW, this question does not belong to SOF.
– AngocA
Dec 17 '14 at 10:07
Thanks for the reply.I want to set my recovery model to simple.According to my understanding at certain point of time database requires some recovery .This recovery can be done in simple,full,checked etc. I just want to find out my current recovery model & to change that model to simple.Kindly excuse me if i am wrong at any point. new to db2
– HABBIE
Dec 17 '14 at 10:23
You are confusing DB2 and SQL Server.
– mustaccio
Dec 17 '14 at 12:30
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
– Chris Aldrich
Dec 17 '14 at 14:15
What do you understand by recovery model? this is too broad. BTW, this question does not belong to SOF.
– AngocA
Dec 17 '14 at 10:07
What do you understand by recovery model? this is too broad. BTW, this question does not belong to SOF.
– AngocA
Dec 17 '14 at 10:07
Thanks for the reply.I want to set my recovery model to simple.According to my understanding at certain point of time database requires some recovery .This recovery can be done in simple,full,checked etc. I just want to find out my current recovery model & to change that model to simple.Kindly excuse me if i am wrong at any point. new to db2
– HABBIE
Dec 17 '14 at 10:23
Thanks for the reply.I want to set my recovery model to simple.According to my understanding at certain point of time database requires some recovery .This recovery can be done in simple,full,checked etc. I just want to find out my current recovery model & to change that model to simple.Kindly excuse me if i am wrong at any point. new to db2
– HABBIE
Dec 17 '14 at 10:23
You are confusing DB2 and SQL Server.
– mustaccio
Dec 17 '14 at 12:30
You are confusing DB2 and SQL Server.
– mustaccio
Dec 17 '14 at 12:30
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
– Chris Aldrich
Dec 17 '14 at 14:15
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
– Chris Aldrich
Dec 17 '14 at 14:15
add a comment |
1 Answer
1
active
oldest
votes
In DB2, the SQL Server's recovery model simple equivalent is called circular.
<p>C:WINDOWSsystem32>db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" <p>
<p> First log archive method (LOGARCHMETH1) = OFF </p>
<p> Second log archive method (LOGARCHMETH2) = OFF </p>
If both logarchmeth1 and logarchmeth2 are set to OFF, the database uses circular logging and is not rollforward recoverable.
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
answered May 6 '16 at 13:21
DBplatzDBplatz
112
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f86389%2frecovery-model-of-current-database%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
In DB2, the SQL Server's recovery model simple equivalent is called circular.
<p>C:WINDOWSsystem32>db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" <p>
<p> First log archive method (LOGARCHMETH1) = OFF </p>
<p> Second log archive method (LOGARCHMETH2) = OFF </p>
If both logarchmeth1 and logarchmeth2 are set to OFF, the database uses circular logging and is not rollforward recoverable.
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
answered May 6 '16 at 13:21
DBplatzDBplatz
112
add a comment |
In DB2, the SQL Server's recovery model simple equivalent is called circular.
<p>C:WINDOWSsystem32>db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" <p>
<p> First log archive method (LOGARCHMETH1) = OFF </p>
<p> Second log archive method (LOGARCHMETH2) = OFF </p>
If both logarchmeth1 and logarchmeth2 are set to OFF, the database uses circular logging and is not rollforward recoverable.
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
answered May 6 '16 at 13:21
DBplatzDBplatz
112
add a comment |
In DB2, the SQL Server's recovery model simple equivalent is called circular.
<p>C:WINDOWSsystem32>db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" <p>
<p> First log archive method (LOGARCHMETH1) = OFF </p>
<p> Second log archive method (LOGARCHMETH2) = OFF </p>
If both logarchmeth1 and logarchmeth2 are set to OFF, the database uses circular logging and is not rollforward recoverable.
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
answered May 6 '16 at 13:21
DBplatzDBplatz
112
In DB2, the SQL Server's recovery model simple equivalent is called circular.
<p>C:WINDOWSsystem32>db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" <p>
<p> First log archive method (LOGARCHMETH1) = OFF </p>
<p> Second log archive method (LOGARCHMETH2) = OFF </p>
If both logarchmeth1 and logarchmeth2 are set to OFF, the database uses circular logging and is not rollforward recoverable.
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
answered May 6 '16 at 13:21
DBplatzDBplatz
112
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
edited May 6 '16 at 14:02
LowlyDBA
7,04252542
7,04252542
answered May 6 '16 at 13:21
DBplatzDBplatz
112
answered May 6 '16 at 13:21
DBplatzDBplatz
112
answered May 6 '16 at 13:21
DBplatzDBplatz
112
112
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f86389%2frecovery-model-of-current-database%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
What do you understand by recovery model? this is too broad. BTW, this question does not belong to SOF.
– AngocA
Dec 17 '14 at 10:07
Thanks for the reply.I want to set my recovery model to simple.According to my understanding at certain point of time database requires some recovery .This recovery can be done in simple,full,checked etc. I just want to find out my current recovery model & to change that model to simple.Kindly excuse me if i am wrong at any point. new to db2
– HABBIE
Dec 17 '14 at 10:23
You are confusing DB2 and SQL Server.
– mustaccio
Dec 17 '14 at 12:30
Simplest would be to make sure LOGARCHMETH1 is set to OFF. Then you only have circular logging and can only offline backups.
– Chris Aldrich
Dec 17 '14 at 14:15