Error activating a database/cannot allocate agent
in [DB2]
|
Prev: DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
Next: Restoring the event monitor file
From: michaelg on 26 Jul 2007 04:41 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/developerworks/forums/dw_thread.jsp?forum=295&thread=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
From: Knokmans on 26 Jul 2007 06:04 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" <michael.guyver(a)gmail.com> wrote in message news:1185439286.969628.234200(a)o61g2000hsh.googlegroups.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/developerworks/forums/dw_thread.jsp?forum=295&thread=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 >
From: michaelg on 26 Jul 2007 07:41 On 26 Jul, 11:04, "Knokmans" <knokm...(a)nospam.com> wrote: > 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
From: Knokmans on 26 Jul 2007 09:45 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" <michael.guyver(a)gmail.com> wrote in message news:1185450064.807067.178570(a)22g2000hsm.googlegroups.com... On 26 Jul, 11:04, "Knokmans" <knokm...(a)nospam.com> wrote: > 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
From: michaelg on 26 Jul 2007 12:44
On 26 Jul, 14:45, "Knokmans" <knokm...(a)nospam.com> wrote: > 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 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 |