Error activating a database/cannot allocate agent

[michaelg]

Hi there,

I previously posted this to the DB2-Express-C forum at ibm.com, but
this group seems to get more traffic so I've reposted it here. The
previous (off-group) post is at the URL below and unless anyone can't
access it I won't repost the attachments inline here.

http://www-128.ibm.com/developerwork...=170162&cat=81

The post read:

I'm running a 32-bit Fedora 4 linux box with 2GB of RAM. I've
installed DB2 Express-C 9.12 manually, and while I can create a
database using

db2 "CREATE DATABASE src_prod AUTOMATIC STORAGE YES ON /home/db2inst1/
data USING CODESET UTF-8 TERRITORY GB PAGESIZE 8 K"

I cannot then activate it using

db2 "ACTIVATE DATABASE src_prod"

I get the following error:

to stdout:
SQL1225N The request failed because an operating system process,
thread, or
swap space limit was reached. SQLSTATE=57049

db2inst1.nfy:
ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".

I'm no linux guru or DB2 guru, but I'm willing to have a damn good
try. However, I've got to the point where I don't know what to do -
fiddle with the kernel settings or simply play with the DB2 registry
settings? I've had a good google around, but found no concrete steps I
can take to get out of this problem.

I've attached a tar.gz file containing the files

db2diag.log
db2inst1.nfy
db2 "get dbm cfg" dbm.cfg
/etc/sysctl.conf

Hopefully these can help someone get me out of this hole! Installing
DB2 shouldn't be this hard! It worked fine on my Ubuntu laptop...

Cheers

Michael

[Knokmans]

Michael,

I also had similar problems running DB2 9.1 on FC4 after applying a fixpack
(1 or 2).
For me running DB2 9.1 without any fixpacks works OK. (uninstall and install
again. Problem behaviour is the same for Express-C as for Express and ESE).

If you don't want "restriction" you should try a different Linux
distribution.

Knôkmans

"michaelg" <mi************@gmail.comwrote in message
news:11**********************@o61g2000hsh.googlegr oups.com...

Hi there,

I previously posted this to the DB2-Express-C forum at ibm.com, but
this group seems to get more traffic so I've reposted it here. The
previous (off-group) post is at the URL below and unless anyone can't
access it I won't repost the attachments inline here.

http://www-128.ibm.com/developerwork...=170162&cat=81

The post read:

I'm running a 32-bit Fedora 4 linux box with 2GB of RAM. I've
installed DB2 Express-C 9.12 manually, and while I can create a
database using

db2 "CREATE DATABASE src_prod AUTOMATIC STORAGE YES ON /home/db2inst1/
data USING CODESET UTF-8 TERRITORY GB PAGESIZE 8 K"

I cannot then activate it using

db2 "ACTIVATE DATABASE src_prod"

I get the following error:

to stdout:
SQL1225N The request failed because an operating system process,
thread, or
swap space limit was reached. SQLSTATE=57049

db2inst1.nfy:
ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".

I'm no linux guru or DB2 guru, but I'm willing to have a damn good
try. However, I've got to the point where I don't know what to do -
fiddle with the kernel settings or simply play with the DB2 registry
settings? I've had a good google around, but found no concrete steps I
can take to get out of this problem.

I've attached a tar.gz file containing the files

db2diag.log
db2inst1.nfy
db2 "get dbm cfg" dbm.cfg
/etc/sysctl.conf

Hopefully these can help someone get me out of this hole! Installing
DB2 shouldn't be this hard! It worked fine on my Ubuntu laptop...

Cheers

Michael

[michaelg]

On 26 Jul, 11:04, "Knokmans" <[e-mail]:

I also had similar problems running DB2 9.1 on FC4 after applying a fixpack
(1 or 2).
For me running DB2 9.1 without any fixpacks works OK. (uninstall and install
again. Problem behaviour is the same for Express-C as for Express and ESE).

If you don't want "restriction" you should try a different Linux
distribution.

Knôkmans

Hi Knôkmans,

Thanks for your comment. This is a clean install of the 9.012 DB2
Express-C for Linux. Hopefully if the problem is not confined to my
server it may get some more visibility.

Cheers

Michael

[Knokmans]

Michael,

If you enter the command /opt/ibm/db2/V9.1/bin/db2level it will give info
about the software level.
DB2 v9.1 without fixpack has info like this: Informational tokens are "DB2
v9.1.0.0"
Yours might be like this: Informational tokens are "DB2 v9.1.0.2"
That means fixpack 2 !!

I dont' know if downloading Express-C v9.1 fixpack 0 is still possible.
If you also have non-free DB2 software you might download DB2 Express (not
the -C version) FP 0 from Passport Advantage
Before starting the install procedure replace the .lic file which is in the
....../db2/license directory with db2exp_uw.lic which is provided by the
Express-C version you already have.
Install the DB2 software and you have an Express-C running

I don't know how simple you can arrange a different distribution... might be
more simple than the above story..

Knôkmans

"michaelg" <mi************@gmail.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...
On 26 Jul, 11:04, "Knokmans" <[e-mail]:

I also had similar problems running DB2 9.1 on FC4 after applying a
fixpack
(1 or 2).
For me running DB2 9.1 without any fixpacks works OK. (uninstall and
install
again. Problem behaviour is the same for Express-C as for Express and
ESE).

If you don't want "restriction" you should try a different Linux
distribution.

Knôkmans

Hi Knôkmans,

Thanks for your comment. This is a clean install of the 9.012 DB2
Express-C for Linux. Hopefully if the problem is not confined to my
server it may get some more visibility.

Cheers

Michael

[michaelg]

On 26 Jul, 14:45, "Knokmans" <[e-mail]:

Michael,

If you enter the command /opt/ibm/db2/V9.1/bin/db2level it will give info
about the software level.
DB2 v9.1 without fixpack has info like this: Informational tokens are "DB2
v9.1.0.0"
Yours might be like this: Informational tokens are "DB2 v9.1.0.2"
That means fixpack 2 !!

I dont' know if downloading Express-C v9.1 fixpack 0 is still possible.
If you also have non-free DB2 software you might download DB2 Express (not
the -C version) FP 0 from Passport Advantage
Before starting the install procedure replace the .lic file which is in the
...../db2/license directory with db2exp_uw.lic which is provided by the
Express-C version you already have.
Install the DB2 software and you have an Express-C running

I don't know how simple you can arrange a different distribution... mightbe
more simple than the above story..

Knôkmans

Thanks - I ran the command and got the following output:

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL09012"
with level identifier "01030107".
Informational tokens are "DB2 v9.1.0.2", "special_17369",
"MI00183_17369", and
Fix Pack "2".
Product is installed at "/opt/ibm/db2/V9.1".

I do have an older download for linux on my laptop but would rather
fix the problem than "downgrade" to an earlier release. Surely someone
must have an idea about which settings to change so that either more
agents are available or DB2 doesn't request so many!

Cheers

Michael