DB2 Installation on AIX 1

[scar1978]

Hi,
I need to install db2 - 8.1 on an AIX machine on which db2 - 7.1 already exists.

we need to keep both versions running.

Most funny part is i have never installed any thing on an unix machine.

I have been going thru some DB2 installation Docs but still lot of doubts since i have never done that before.

I will appreciate any help i can get.

Thanks

 

[aixnag]

Installing the second version of db2 is quite simple.

Steps:
1.Create a temp filesystem /dbsw about 4gb.
2.Create a filesystem for DB2 /usr/opt/db20801 about 2gb.
2.Copy the contents of the CD-ROM to the dbmisc (cp /cdrom/*.* /db2sw)
3.Change directory to db2sw (cd /db2sw)
4.Untar the contents in the same location (tar –xvf ese.sbcs.tar)
5.Change directory to db2 Installation binary fille (cd ese.sbcs)
6.Run the command (./ db2_install -b /usr/opt/db20801 -p DB2.ESE). This will Install the db2 binaries to /usr/opt/db20801. It will take 10 –15 mins for the Installation.
7.After Installation, Summary of Installation gets popped up . Please make sure all the components get Successfully Installed.
8.DB2 Software License gets updated by running the command
cd /usr/opt/db20801/adm
./db2licm -a /dbsw/ese.sbcs/db2/license/db2ese.lic -n db2ese 4


Hope it helps.


aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2

 

[scar1978]

Hi aixnag,

Thanks for the reply,
but there is a minor change in plans,
we are not going to keep db2 7.1,
can you please outline the steps that i need to do to migrate 7.1 to 8.1 on AIX

and also how to find out what are all the instances on an AIX box,and the databases in each instance.

list active databases is showing different values depending on db2profile i run
if i run the dbprofile in db2inst1 and the list active databases i am getting different values from the one if i run dbprofile in db2dev04.

i dont know if there are any other instances.. and if so how to find


Thanks..

 

[aixnag]

Let me know the following from the server
1. To find Aix ML level
#instfix -i |grep ML
2. To find the no. of instances in system.
#cd /usr/opt/db2_??_??/instance
#./db2ilist

3. To find the db2 version and databases in system.
- Login as each instance owner (as found in step 2)
$db2 list db directory #to database list
$db2level #to find version info.
$db2 get db cfg for <databasename> |grep -i -E "logretain|userexit" #to find whether db in offline or online mode.


As you have planned to migrate to 8.1 version, have you considered to which Fixpack level you wish to reach. 8.1 version have so many fixpacks. Talk to your application people and find out which one is ideal fixpack to work with application.

I will draft you highlevel steps once i receive above info.



aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2

 

[scar1978]

#instfix -i |grep ML OUTPUT

All filesets for 5.2.0.0_AIX_ML were found.
All filesets for 5200-01_AIX_ML were found.
All filesets for 5200-02_AIX_ML were found.
All filesets for 5200-03_AIX_ML were found.
All filesets for 5200-04_AIX_ML were found.
All filesets for 5200-05_AIX_ML were found.

Any fix pack is fine.i guess 8.1.2 is good.

Thanks Again

 

[scar1978]

Sorry aixnag

fixpak 7 is needed not 2...

so finally its 8.2.7

Thanks

 

[scar1978]

hi
one more question
to use db2setup i heard we need xwindows on the AIX box,
how to find if xwindows is installed on the machine?
if not installed how to install db2 with out it ?
Thanks

 

[aixnag]

Don't worry, even if you don't have Xwindows, still you can install DB2 using command line.

For Xwindows:-
Run #xclock -you should a see clock appearing on screen. if doesn't appear then you can
1.check the process using #ps -ef|grep X11
2.check the package using #lslpp -L|grep -i x11.base
3.check entry in inittab #cat /etc/inittab|grep rc.dt
if you would like to start X11 then
#/etc/rc.dt &

For DB2 migration:-
Send the details for point 2 and 3 as asked in previous post.


aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2