Visit Our UNIX and Linux User Community


migrating solaris DB servers to AIX - resources ?


 
Thread Tools Search this Thread
Operating Systems AIX migrating solaris DB servers to AIX - resources ?
# 1  
Old 11-03-2009
migrating solaris DB servers to AIX - resources ?

Hi Guys,

I have a new project where I have to migrate about 150+ database environments from various solaris systems running Solaris 8 / 10 and residing on very different sun boxes (from 25k down to ancient/unsupported hardware) to AIX (power6).

As special bonus for me, about half of these DBs are supposed to become migrated to Oracle once stable as Sybase DBs on AIX.

I know that I can use the RPE2 values to estimate the cpu requirements - but since the memory needs on Solaris seem pretty different from AIX, is there any safe way to estimate at least roughly the memory needs on AIX? For Sybase I can probably choose the value that's assigned to ASE and add 2-4 GB memory for the system and should be safe - but what do I do with oracle since here the memory usage seems to be highly depending on the DB connections and what they're doing?

Has anybody done similar tasks in the past and would be happy to share experiences.

Thank you and regards
zxmaus
# 2  
Old 11-03-2009
I'm in the midst of a similar project. I used the following script to determine shared memory usage on Solaris hosts for Sybase and Oracle. I ran this several times a day on each host, though the numbers really didn't change much. I found this to be much better than utilizing what the DB was configured to use, as this will show what the DB actually utilizes.

Code:
if ipcs -ma | grep sybase > /dev/null ; then
  echo Sybase
  ipcs -ma  | grep sybase | awk '{ T+=($10/1024/1024) } END { print T }'
elif ipcs -ma | grep oracle > /dev/null ; then
  echo Oracle
  ipcs -ma  | grep oracle | awk '{ T+=($10/1024/1024) } END { print T }'
fi

Padow

Previous Thread | Next Thread
Test Your Knowledge in Computers #547
Difficulty: Medium
unary operators only operate on universal variables.
True or False?

4 More Discussions You Might Find Interesting

1. AIX

Upgrading to AIX 7 vs migrating

Hi all, I have this weird notion that upgrading the TL does not cause the machine to wipe, but upgrading a major version (from aix 6 to 7) means it's actually a fresh install and will wipe the date and i have to install the software again (TSM server, for instance). Trying to google it, i came... (3 Replies)
Discussion started by: tde3000
3 Replies

2. AIX

AIX Servers Ugrading or Migrating

:( Hi Grue, I am very new in AIX/UNIX environment. Please give me answer that during the upgrading or Migrating to 6.1 the AIX Server the applications of this server is accessible to Apps users or not? Thanks (2 Replies)
Discussion started by: Tahniet
2 Replies

3. Red Hat

RHCE Servers Online Learning Resources..

Anybody knows about any reliable source where i can study Linux servers while sitting at my home. A single bit of information in this regards will be highly appreciated. thanks :-) (3 Replies)
Discussion started by: salman103
3 Replies

4. AIX

Problem with migrating from AIX 5.1 to 5.3

I'am migrating from AIX 5.1 to 5.3 during migration installation a receive message enough space for dir /usr. My question is : how i can resolve this problem ? i can't reboot my server i hope that there is a command to obtain a spece without go out from installation procedure pannel... I'am... (0 Replies)
Discussion started by: tt155
0 Replies

Featured Tech Videos