Hello,
Is this an upgrade or would/could 9.5 install separately?
Thanks
Graham

On Nov 8, 9:21*am, Graham Hobbs <gho... (AT) cdpwise (DOT) net> wrote:
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/infoce.../c0023662.html

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:
--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On Mon, 08 Nov 2010 15:58:54 -0500, Helmut Tessarek
<tessarek (AT) evermeet (DOT) cx> wrote:

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

Hi Graham,

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>

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.
*/

On Mon, 08 Nov 2010 19:27:30 -0500, Helmut Tessarek
<tessarek (AT) evermeet (DOT) cx> wrote:

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

Hi Graham,

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.
*/