About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Welcome to the Jazz Community Forum
DB2 automatic backup after upgrading to DB2 v10.5 (RTC 5.0.2)
Hi,
I realize this might be slightly out of topic.
Since I upgraded to RTC 5 (from 4) and therefore also upgraded DB2 to 10.5 (from 9.7) I haven't been able to change my automatic maintenance. After upgrading, I realized that the DB2 administration tool was removed, and now only the IBM Data Studio (v4) was supported.
When using IBM DS, I can easily go to "Configure and setup up...." and then "Automatic maintenance" and then I can see all me current settings. But if I change these, and press "Run" I see that the command - containing all the correct info - is fired and runs success fully.
If I then open the "Automatic maintenance" section again, all my settings are reverted to my original settings. I changed for example the time to run online maintenance from 8 PM to 1 AM. After running the command and re-opening the section, it is back to 8 PM.
Does anyone have similar experiences? RTC is functioning perfectly though.
Thanks,
/Morten
I realize this might be slightly out of topic.
Since I upgraded to RTC 5 (from 4) and therefore also upgraded DB2 to 10.5 (from 9.7) I haven't been able to change my automatic maintenance. After upgrading, I realized that the DB2 administration tool was removed, and now only the IBM Data Studio (v4) was supported.
When using IBM DS, I can easily go to "Configure and setup up...." and then "Automatic maintenance" and then I can see all me current settings. But if I change these, and press "Run" I see that the command - containing all the correct info - is fired and runs success fully.
If I then open the "Automatic maintenance" section again, all my settings are reverted to my original settings. I changed for example the time to run online maintenance from 8 PM to 1 AM. After running the command and re-opening the section, it is back to 8 PM.
Does anyone have similar experiences? RTC is functioning perfectly though.
Thanks,
/Morten
Accepted answer
I found the solution.
It seems, even though I "connect" to the database with the correct credentials "db2admin" + password, IBM Data Studio will still run DB2 CLP (command line processor) with my windows credentials.
To make this work you should:
1. Try to run automatic maintenance and you normally would.
2. When Data Studio executes the command line, copy the entire command.
3. Run DB2 command window
4. connect to database with command "connect to <database> user <user> using <password>"
5. now paste the command and run manually.
Now, if you access the "Automatic maintenance" section in Data studio, you'll see that the configuration now has changed to whatever your command did.
Cheers,
/Morten.
It seems, even though I "connect" to the database with the correct credentials "db2admin" + password, IBM Data Studio will still run DB2 CLP (command line processor) with my windows credentials.
To make this work you should:
1. Try to run automatic maintenance and you normally would.
2. When Data Studio executes the command line, copy the entire command.
3. Run DB2 command window
4. connect to database with command "connect to <database> user <user> using <password>"
5. now paste the command and run manually.
Now, if you access the "Automatic maintenance" section in Data studio, you'll see that the configuration now has changed to whatever your command did.
Cheers,
/Morten.
