Installing DB2 on Solaris 10

[ReeseDog]

I have a AIX backup of DB2 (8.2) and i was told i needed to have a unix
OS installed to be able to restore this database. So now i have
installed Solaris 10 (x86 hardware). I copied the DB2.tar file to a
folder i created in /export/home/db2, and unzipped everything. My issue
is now when i try to run the 'install or setup' files, i get a message
in the terminal window that says 'cannot execute'. I made sure to give
the entire folder and all sub folders full permission, but im not sure
if that is the issue?

Im not a Unix or BD2 expert, so any suggestions are much appreciated.
Thanks

[Larry Menard]

Just a shot in the dark... if the 'install or setup files' are shell
scripts, make sure the shell program it points to on line 1 really exists.
For example, if it's "#!/usr/bin/ksh", make sure that file or symlink
"/usr/bin/ksh" really exists and works. If not, it returns a similar error.
;-)

--
--------------------
Larry Menard
"Defender of Geese and of All Things Natural"
"ReeseDog" <de*****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I have a AIX backup of DB2 (8.2) and i was told i needed to have a unix
OS installed to be able to restore this database. So now i have
installed Solaris 10 (x86 hardware). I copied the DB2.tar file to a
folder i created in /export/home/db2, and unzipped everything. My issue
is now when i try to run the 'install or setup' files, i get a message
in the terminal window that says 'cannot execute'. I made sure to give
the entire folder and all sub folders full permission, but im not sure
if that is the issue?

Im not a Unix or BD2 expert, so any suggestions are much appreciated.
Thanks

[Mark A]

"ReeseDog" <de*****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I have a AIX backup of DB2 (8.2) and i was told i needed to have a unix
OS installed to be able to restore this database. So now i have
installed Solaris 10 (x86 hardware). I copied the DB2.tar file to a
folder i created in /export/home/db2, and unzipped everything. My issue
is now when i try to run the 'install or setup' files, i get a message
in the terminal window that says 'cannot execute'. I made sure to give
the entire folder and all sub folders full permission, but im not sure
if that is the issue?

Im not a Unix or BD2 expert, so any suggestions are much appreciated.
Thanks

You can install DB2 on Solaris, backup the DB2 database on AIX (with DB2
backup db command, not an OS backup), and then restore the DB2 database (DB2
restore db command) on your existing Solaris DB2 instance.

Not sure if you can restore the OS level backup and get it to work,
especially since the OS is different.

[dotyet]

Are you trying to *RESTORE* a database backup, or are you trying to
installing from an AIX based image of DB2 software?

i don't think DB2 for AIX will install on Solaris x86. (2 different
machine architectures PowerPC/RISC vs Intel)

It might install on Solaris sparc, but you need to try that.

regards,
dotyet
ReeseDog wrote:

I have a AIX backup of DB2 (8.2) and i was told i needed to have a unix
OS installed to be able to restore this database. So now i have
installed Solaris 10 (x86 hardware). I copied the DB2.tar file to a
folder i created in /export/home/db2, and unzipped everything. My issue
is now when i try to run the 'install or setup' files, i get a message
in the terminal window that says 'cannot execute'. I made sure to give
the entire folder and all sub folders full permission, but im not sure
if that is the issue?

Im not a Unix or BD2 expert, so any suggestions are much appreciated.
Thanks

[Ian]

ReeseDog wrote:

I have a AIX backup of DB2 (8.2) and i was told i needed to have a unix
OS installed to be able to restore this database. So now i have
installed Solaris 10 (x86 hardware). I copied the DB2.tar file to a
folder i created in /export/home/db2, and unzipped everything. My issue
is now when i try to run the 'install or setup' files, i get a message
in the terminal window that says 'cannot execute'. I made sure to give
the entire folder and all sub folders full permission, but im not sure
if that is the issue?

Im not a Unix or BD2 expert, so any suggestions are much appreciated.
Thanks

There is no DB2 that runs on Solaris x86, so what you describe isn't
even feasible.

If you have Sun SPARC hardware you could restore your database; however
you need to have a backup image of the database, not a tar file
containing all of the data files that make up the instance and database.
You would install DB2 normally (using the DB2 install CD), create an
instance, etc.

The backup image would have a file name like:

SAMPLE.0.db2inst1.NODE0000.CATN0000.20051210020110 .001

(SAMPLE is the name of the database, and 'db2inst1' is the name of the
DB2 instance on your AIX box).

Good luck,

[ReeseDog]

I have the Solaris 10 install on x86, and i downloaded db2 for solaris
for 32bit machines (hoping/thinking that this would be good.)

I have a backup image of DB2 from a AIX machine. (at least i think it
is) Here are the the 4 files i received.
DB.0.db2inst.NODE0000.CATN0000.2005.001
DB.0.db2inst.NODE0000.CATN0000.2005.002
DB.0.db2inst.NODE0000.CATN0000.2005.003
DB.info
I was told that the only way to restore this backup or image was to do
it on a Unix machine, (i tried on a winx86 box already).

So now going back to the ibm site looking at the DB2 download for
solaris, it says its for 32bit machines and not specifically for x86 or
sparc.
I hope i didnt leave out any info.

So assuming that i have to use the files i have on a Unix based machine
and IBM doesnt have any versions of DB2 for Unix on x86 hardware. Am i
sol?

Is there any suggestions as to what i could do to get this database up
and running.

Thanks for all the help and information.

[dotyet]

DB2 for Solaris x86 does not exist. I think your only option is to
either restore it on an existing AIX box or on a Solaris sparc box or
on an HP-UX box.

if you have the source database running and accessible, you can try
db2move/db2look to move the database across platforms.

good luck.

rgds,
dotyet

ReeseDog wrote:

I have the Solaris 10 install on x86, and i downloaded db2 for solaris
for 32bit machines (hoping/thinking that this would be good.)

I have a backup image of DB2 from a AIX machine. (at least i think it
is) Here are the the 4 files i received.
DB.0.db2inst.NODE0000.CATN0000.2005.001
DB.0.db2inst.NODE0000.CATN0000.2005.002
DB.0.db2inst.NODE0000.CATN0000.2005.003
DB.info
I was told that the only way to restore this backup or image was to do
it on a Unix machine, (i tried on a winx86 box already).

So now going back to the ibm site looking at the DB2 download for
solaris, it says its for 32bit machines and not specifically for x86 or
sparc.
I hope i didnt leave out any info.

So assuming that i have to use the files i have on a Unix based machine
and IBM doesnt have any versions of DB2 for Unix on x86 hardware. Am i
sol?

Is there any suggestions as to what i could do to get this database up
and running.

Thanks for all the help and information.

[ReeseDog]

I do not have access to the source database. I just have the 4 files
that they sent me.

Is there a way for them to re-create a backup on the AIX system that i
could then restore on a windows system?

That would be the perfect solution for me :)

[dotyet]

if they have an AIX environment, then either they can restore this
database backup in the existing db2 instance or they can restore the
database in a new instance. once that is done, then they need to a run
db2look (DDL Generation to create database objects) and db2move (EXPORT
actual user data).

once that is done, you can create the database objects in windows using
the db2look output file and use db2move to IMPORT/LOAD the user data.

technically, this is the only way to deploy/move an existing unix db2
database on to a windows platform.

take a look at the following commands:

db2move
db2look
restore
rollforward
good luck!

rgds,
dotyet

ReeseDog wrote:

I do not have access to the source database. I just have the 4 files
that they sent me.

Is there a way for them to re-create a backup on the AIX system that i
could then restore on a windows system?

That would be the perfect solution for me :)