SEO

#1 (**permalink**) 02-27-2008, 03:07 AM

Hi All,

I have upgrade the OS from AIX5.1 to AIX5.2ML03 and installed DB2v8.2(
no FixPack) on RS/6000 H50. I find it is very slow when run command
db2icrt to create Instance and db2start.

The db2icrt took me 2-3 minutes to finish.
The db2start took more than 1 minutes to start( without any database).

The hardware config is 2CPU 1GB memory.

I did the same test on RS6000-43P140 AIX 5.1 and DB2 V7.1.
The db2crt and db2start take 30sec. ( Hardware configuration is 1CPU
233Mhz 128MB memory)

I want to know if the AIX5.2 works well with H50? I know H50 is old
machine but it should 3 time faster than 43P140 233Mhz.

Am I miss anything?

Thanks.

#2 (**permalink**) 02-27-2008, 03:07 AM

<linyy_ca@yahoo.com> wrote in message
news:1110466882.189972.174000@z14g2000cwz.googlegr oups.com...
> Hi All,
>
> I have upgrade the OS from AIX5.1 to AIX5.2ML03 and installed DB2v8.2(
> no FixPack) on RS/6000 H50. I find it is very slow when run command
> db2icrt to create Instance and db2start.
>

ML05 is the current level and should be installed any new server

> The db2icrt took me 2-3 minutes to finish.
> The db2start took more than 1 minutes to start( without any database).
>
> The hardware config is 2CPU 1GB memory.
>
> I did the same test on RS6000-43P140 AIX 5.1 and DB2 V7.1.
> The db2crt and db2start take 30sec. ( Hardware configuration is 1CPU
> 233Mhz 128MB memory)

You are comparing apples and oranges. V7.1 and V8.2 on 2 differnent OS
levels.

If you are using AIO for db2, you will need to check that on your new
server, the settings don't always survive the update/install process
Doug

>
> I want to know if the AIX5.2 works well with H50? I know H50 is old
> machine but it should 3 time faster than 43P140 233Mhz.
>
> Am I miss anything?
>
> Thanks.
>

#3 (**permalink**) 02-27-2008, 03:07 AM

linyy_ca@yahoo.com wrote:

> Hi All,
>
> I have upgrade the OS from AIX5.1 to AIX5.2ML03 and installed DB2v8.2(
> no FixPack) on RS/6000 H50. I find it is very slow when run command
> db2icrt to create Instance and db2start.
>
> The db2icrt took me 2-3 minutes to finish.
> The db2start took more than 1 minutes to start( without any database).
>
> The hardware config is 2CPU 1GB memory.
>
> I did the same test on RS6000-43P140 AIX 5.1 and DB2 V7.1.
> The db2crt and db2start take 30sec. ( Hardware configuration is 1CPU
> 233Mhz 128MB memory)
>
> I want to know if the AIX5.2 works well with H50? I know H50 is old
> machine but it should 3 time faster than 43P140 233Mhz.
>
> Am I miss anything?
>
> Thanks.

I would not attempt to run a database with 1GB memory. This is performance
suicide for DB2, Oracle or any other commercial database I know of.

#4 (**permalink**) 02-27-2008, 03:07 AM

I know they are different DB2 version and different OS. But that's only
environment I can find and compare. But on H50, the db2 command is
extremly slow. I don't believe it's normal.

I have checked the aioserver. It's enabled.
minserver=20 , maxserver=40.

Thanks.

#5 (**permalink**) 02-27-2008, 03:07 AM

Thanks for your reply. This just a dev environment.

#6 (**permalink**) 02-27-2008, 03:07 AM

Don Davis wrote:

>
> I would not attempt to run a database with 1GB memory. This is performance
> suicide for DB2, Oracle or any other commercial database I know of.

What if the database is 10Mb or 100Mb in size?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 command slow after Migrate to AIX5.2 ( RS/6000 H50)