DB2 V9.1 to 9.5

Please be also aware that you can't access the same database locally
from both instances at the same time.

You can catalog the database via a loopback address though.

Your choices are as follows:

Install new version additionally to the existing one:
- backup in 9.1 / (redirected) restore in 9.5 (drawback: twice the space
and not in sync)
- catalog 9.1 database in 9.5 (drawback: server 9.1 / client 9.5 and
both instances have to be up)

Upgrade 9.1 code to 9.5
- migrate 9.1 database to 9.5

So long,
Helmut

On 11/08/2010 02:28 PM, Ian wrote:
> On Nov 8, 9:21 am, Graham Hobbs wrote:
>> Hello,
>> Is this an upgrade or would/could 9.5 install separately?
>
> You can install 9.5 on the same system as 9.1, and have different
> instances running on both code levels simultaneously.
>
> Depending on your platform (i.e. Windows vs UNIX/Linux) there are
> definitely caveats for how to handle this during the install, etc, so
> make sure you read the documentation.
> http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2...w.qb.mi
>
>

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/
 >> Stay informed about: DB2 V9.1 to 9.5 

On Mon, 08 Nov 2010 15:58:54 -0500, Helmut Tessarek
wrote:

>Please be also aware that you can't access the same database locally
>from both instances at the same time.
>
>You can catalog the database via a loopback address though.
>
>Your choices are as follows:
>
>Install new version additionally to the existing one:
>- backup in 9.1 / (redirected) restore in 9.5 (drawback: twice the space
>and not in sync)
>- catalog 9.1 database in 9.5 (drawback: server 9.1 / client 9.5 and
>both instances have to be up)
>
>Upgrade 9.1 code to 9.5
>- migrate 9.1 database to 9.5
>
>So long,
> Helmut
>
>On 11/08/2010 02:28 PM, Ian wrote:
>> On Nov 8, 9:21 am, Graham Hobbs wrote:
>>> Hello,
>>> Is this an upgrade or would/could 9.5 install separately?
>>
>> You can install 9.5 on the same system as 9.1, and have different
>> instances running on both code levels simultaneously.
>>
>> Depending on your platform (i.e. Windows vs UNIX/Linux) there are
>> definitely caveats for how to handle this during the install, etc, so
>> make sure you read the documentation.
>> http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2...w.qb.mi
>>
>>
So I can upgrade 9.1 to 9.5 and I am sure the documentation will tell
me how to migrate my databases and tables. This is what I will do.
Thanks chaps.

Just for reassurance .. three years ago I installed DB2 Express (guess
this was 9.1) in a small operation on a laptop with RDz and TXSeries,
created a few tables. I was pleased that without ANY tinkering my
Cobol/CICS pgms successfully accessed the tables - am hoping that
going to 9.5 will produce the same pleasure:-).
Graham
 >> Stay informed about: DB2 V9.1 to 9.5 

Hi Graham,

> So I can upgrade 9.1 to 9.5 and I am sure the documentation will tell
> me how to migrate my databases and tables. This is what I will do.
> Thanks chaps.

Yes, you can. The documentation has all the info you will need.
On Unix the steps are as follows:
../db2_install
/opt/ibm/db2/V9.7/instance/db2imigr <instance user>
su - <instance user>
db2start
db2 migrate db <dbname>

> Just for reassurance .. three years ago I installed DB2 Express (guess
> this was 9.1) in a small operation on a laptop with RDz and TXSeries,
> created a few tables. I was pleased that without ANY tinkering my
> Cobol/CICS pgms successfully accessed the tables - am hoping that
> going to 9.5 will produce the same pleasure:-).

I don't see why it shouldn't work with 9.5. That is, if RDz and TXSeries are
compatible with 9.5, but I'm pretty sure they are.

Btw, the latest DB2 Version is 9.7. DB2 9.8, if you are a pureScale customer.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/
 >> Stay informed about: DB2 V9.1 to 9.5 

On Mon, 08 Nov 2010 19:27:30 -0500, Helmut Tessarek
wrote:

>Hi Graham,
>
>> So I can upgrade 9.1 to 9.5 and I am sure the documentation will tell
>> me how to migrate my databases and tables. This is what I will do.
>> Thanks chaps.
>
>Yes, you can. The documentation has all the info you will need.
>On Unix the steps are as follows:
>./db2_install
>/opt/ibm/db2/V9.7/instance/db2imigr <instance user>
>su - <instance user>
>db2start
>db2 migrate db <dbname>
>
>> Just for reassurance .. three years ago I installed DB2 Express (guess
>> this was 9.1) in a small operation on a laptop with RDz and TXSeries,
>> created a few tables. I was pleased that without ANY tinkering my
>> Cobol/CICS pgms successfully accessed the tables - am hoping that
>> going to 9.5 will produce the same pleasure:-).
>
>I don't see why it shouldn't work with 9.5. That is, if RDz and TXSeries are
>compatible with 9.5, but I'm pretty sure they are.
>
>Btw, the latest DB2 Version is 9.7. DB2 9.8, if you are a pureScale customer.
---
Hi Helmut,
Keep forgetting to mention - am Windows XP:( Such is life. I got 9.5
thru Partnerworld and the Software Access Catalogue and my RDz and TXS
are partnered therewith so that's the option I was offered.
Thanks for install/migrate tips and everything!
Graham
 >> Stay informed about: DB2 V9.1 to 9.5 

Hi Graham,

> Keep forgetting to mention - am Windows XP:( Such is life. I got 9.5

No problem, the steps are a little bit different, but it works too.
I'm not using Windows, so I can't write down the necessary steps off the top
of my head.
But you'll find them in the documentation.

Cheers,
Helmut

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/
 >> Stay informed about: DB2 V9.1 to 9.5