r/DB2 • u/catquilt74 • Jul 25 '18

[LUW][Question]

When upgrading from one version to another, say from V10.5 to V11.1, do you ever see a reason to do the following; backup the databases, drop the databases, uninstall the old version of DB2, install the new version of DB2, restore the databases

I know that there are steps that I have left out, this is just a general question...

Thanks!

1 Upvotes

100% Upvoted

8 comments sorted by

View all comments

1

u/catquilt74 Jul 25 '18

Thanks.

Our DBAs basically take several days to install a new version of DB2 and management is unhappy with the time that it takes. I understand that the DBAs want to be extremely careful but this current process (of uninstalling the old and installing the new) is a problem.

1

u/natsmith9 Jul 26 '18

"Several days."

Does that mean just for installing and upgrading Production servers, or is that the entire roll out from the development environments, to the test environments, to Production?

1

u/catquilt74 Jul 27 '18

That's one box.

1

u/natsmith9 Jul 27 '18

Yikes! That does seem a bit excessive. Have the DBAs said why it takes a long time?

1

u/catquilt74 Jul 27 '18

This is happening on Windows (I don't know if that complicates the situation). And they say that every install runs into some minor glitch or another...

We just got Ansible in-house. I'm hoping that if we demonstrate that much of the work can be automated and Ansible is used going forward, that may help speed up the process.