DB2 AIX Create Database fails with Memory Allocation Error

[Puppy]

I am trying to create a new database using DB2 UDB 8.1 on AIX. When I
attempt to use the control center GUI, the error being returned is:
SQL1224N, SQLSTATE 55032.
When I attempt to use the command line, I get: SQL00083.

What I can't believe is that there would be a memory allocation error
b/c the 32 bit version of DB2 is running and there's nothing else
active on the server.

Any ideas?

Thanks,

Ari

[dotyet]

this first step would be to have a look at your db2diag.log file, if
need be, bring it to level 4.

secondly, have a look at various database manager level configuration
parameters. maybe some parameter was mistakenly assigned some wrong
value. you might want to have a look at the various *_SZ kind of
parameters.

thirdly, you might want to try the command line equivalent of the
create database statement!!

hth,
dotyet
ar******@hotmail.com (Puppy) wrote in message news:<fe**************************@posting.google. com>...

I am trying to create a new database using DB2 UDB 8.1 on AIX. When I
attempt to use the control center GUI, the error being returned is:
SQL1224N, SQLSTATE 55032.
When I attempt to use the command line, I get: SQL00083.

What I can't believe is that there would be a memory allocation error
b/c the 32 bit version of DB2 is running and there's nothing else
active on the server.

Any ideas?

Thanks,

Ari

[ari_weil]

I've looked at the DB2 diag log file and have tried manually applying
the CREATE DATABASE command, both to no avail. I'm afraid this one's
got me a bit stumped. I've been administering DB2 on Windows, Linux
and the AS/400 for years, but this is my first go at an AIX environment
and I'm finding it challenging to say the least.

[ari_weil]

Turns out there's either a compatibility issue with DB2 8.1 and AIX 5.1
or the install was FUBAR ... installed 8.1 on AIX 5.2 and I'm making
progress...

[fraffin]

It is implied in your post that your attempting to create a 64 bit
instance on a server already running a 32 bit instance. Have you
confirmed that 64 bit mode is enabled at the OS level? It's been a
while, but I believe the command is bootinfo -K.

[fraffin]

It is implied in your post that your attempting to create a 64 bit
instance on a server already running a 32 bit instance. Have you
confirmed that 64 bit mode is enabled at the OS level? It's been a
while, but I believe the command is bootinfo -K.

[fraffin]

It is implied in your post that your attempting to create a 64 bit
instance on a server already running a 32 bit instance. Have you
confirmed that 64 bit mode is enabled at the OS level? It's been a
while, but I believe the command is bootinfo -K.

[dotyet]

what does the log say, when you run the create database command? can
you post a snippet here?

hth,
dotyet

ar******@hotmail.com wrote in message news:<11**********************@f14g2000cwb.googleg roups.com>...

I've looked at the DB2 diag log file and have tried manually applying
the CREATE DATABASE command, both to no avail. I'm afraid this one's
got me a bit stumped. I've been administering DB2 on Windows, Linux
and the AS/400 for years, but this is my first go at an AIX environment
and I'm finding it challenging to say the least.