Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

db2 V9.5 SQL1084C

  
   Database Help (Home) -> DB2 RSS
Next:  "Trim" prompts when trying to print rep..  
Author Message
Lennart

External


Since: Jan 11, 2008
Posts: 124



(Msg. 1) Posted: Mon Sep 29, 2008 7:06 am
Post subject: db2 V9.5 SQL1084C
Archived from groups: comp>databases>ibm-db2 (more info?)
A while back I raised a discussion ( http://tinyurl.com/4h3qg7 )
regarding SQL1084C Shared memory segments cannot be allocated. We
still have this problem, so I thought I should bump the thread.

Current status:
[db2inst1@wbv7 ~/lelle/scripts]$ uname -a
Linux wbv7 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:58:04 EST 2007 i686 i686
i386 GNU/Linux

[db2inst1@wbv7 ~/lelle/scripts]$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXIA3295", and
Fix Pack
"0".
Product is installed at "/opt/IBM/db2/V9.5".

[db2inst1@wbv7 ~/lelle/scripts]$ cat /proc/meminfo
MemTotal: 3895372 kB

[db2inst1@wbv7 ~/lelle/scripts]$ cat /proc/sys/kernel/shmmax
3221225472

Thus, we have 4Gb physical memory, and are allowed to use 3Gb shared
memory.

Last time I ran into this problem I did some monitoring:

[db2inst1@wbv7 ~/lelle/scripts]$ cat determine_db2_memory.sh
#!/bin/sh

echo "Instance memory"
db2mtrk -i -v | grep "Total:"

echo "Database memory"
db2mtrk -d -v | grep "Total:" | awk '{ sum += $2 } END { print "
Total: " sum }'

echo "Agent private memory"
db2mtrk -p -v | grep "Total:" | awk '{ sum += $2 } END { print "
Total: " sum }'
[db2inst1@wbv7 ~/lelle/scripts]$ ./determine_db2_memory.sh
Instance memory
Total: 21364736 bytes
Database memory
Total: 413859840
Agent private memory
Total: 16187392

This sums up to well under 500Mb of memory, which would leave us with
2.5Gb free shared mem. Now this leaves me with a number of questions:

1. Is db2 using shared memory other than that shown by db2mtrk? If so,
how can I determine how much memory it is using?

2. Is db2 unable to use the additional 2.5Gb shared memory?

Any thoughts anyone?

 >> Stay informed about: db2 V9.5 SQL1084C 
Back to top
Login to vote
Lennart

External


Since: Jan 11, 2008
Posts: 124



(Msg. 2) Posted: Mon Sep 29, 2008 9:18 am
Post subject: Re: db2 V9.5 SQL1084C [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Sep 29, 4:06 pm, Lennart <Erik.Lennart.Jons... DeleteThis @gmail.com> wrote:
[...]
> 2. Is db2 unable to use the additional 2.5Gb shared memory?
>

Judging from dbm cfg it looks as if it is willing to use it:

[db2inst1@wbv7 ~]$ db2 get dbm cfg show detail | grep INSTANCE
Size of instance shared memory (4KB) (INSTANCE_MEMORY) =
AUTOMATIC(775441) AUTOMATIC(775441)


/Lennart

 >> Stay informed about: db2 V9.5 SQL1084C 
Back to top
Login to vote
Liam Finnie

External


Since: Apr 18, 2007
Posts: 9



(Msg. 3) Posted: Mon Sep 29, 2008 1:20 pm
Post subject: Re: db2 V9.5 SQL1084C [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Sep 29, 12:18 pm, Lennart <Erik.Lennart.Jons... RemoveThis @gmail.com> wrote:
> On Sep 29, 4:06 pm, Lennart <Erik.Lennart.Jons... RemoveThis @gmail.com> wrote:
> [...]
>
> > 2. Is db2 unable to use the additional 2.5Gb shared memory?
>
> Judging from dbm cfg it looks as if it is willing to use it:
>
> [db2inst1@wbv7 ~]$ db2 get dbm cfg show detail | grep INSTANCE
> Size of instance shared memory (4KB) (INSTANCE_MEMORY) =
> AUTOMATIC(775441) AUTOMATIC(775441)
>
> /Lennart

Hi Lennart,

I notice now that you're using 32-bit Linux - didn't realize that in
your previous posts. That's likely the reason why you could activate
more databases in previous releases - before 9.5, each database had
it's own address space, and agents working for a particular database
only map in the address space for the database they are working on.
With the threaded engine in 9.5, all database address spaces are
contained in a single process address space, which limits how many
databases you can activate. See the following link for more details:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/....ibm.db

db2mtrk won't show all memory allocated by the server. For more
accurate counters, you should use either the admin_get_dbp_mem_usage()
table function, or use 'db2pd -dbptnmem'.

Cheers,
Liam.
 >> Stay informed about: db2 V9.5 SQL1084C 
Back to top
Login to vote
Lennart

External


Since: Jan 11, 2008
Posts: 124



(Msg. 4) Posted: Mon Sep 29, 2008 8:32 pm
Post subject: Re: db2 V9.5 SQL1084C [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 29 Sep, 22:20, Liam Finnie <lfin....DeleteThis@ca.ibm.com> wrote:
> On Sep 29, 12:18 pm, Lennart <Erik.Lennart.Jons....DeleteThis@gmail.com> wrote:
>
> > On Sep 29, 4:06 pm, Lennart <Erik.Lennart.Jons....DeleteThis@gmail.com> wrote:
> > [...]
>
> > > 2. Is db2 unable to use the additional 2.5Gb shared memory?
>
> > Judging from dbm cfg it looks as if it is willing to use it:
>
> > [db2inst1@wbv7 ~]$ db2 get dbm cfg show detail | grep INSTANCE
> >  Size of instance shared memory (4KB)  (INSTANCE_MEMORY) =
> > AUTOMATIC(775441)          AUTOMATIC(775441)
>
> > /Lennart
>
> Hi Lennart,
>
> I notice now that you're using 32-bit Linux - didn't realize that in
> your previous posts.  That's likely the reason why you could activate
> more databases in previous releases - before 9.5, each database had
> it's own address space, and agents working for a particular database
> only map in the address space for the database they are working on.
> With the threaded engine in 9.5, all database address spaces are
> contained in a single process address space, which limits how many
> databases you can activate.  See the following link for more details:http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=...
>
> db2mtrk won't show all memory allocated by the server.  For more
> accurate counters, you should use either the admin_get_dbp_mem_usage()
> table function, or use 'db2pd -dbptnmem'.
>
> Cheers,
> Liam.

Thanx a lot Liam, this explain the problems I'm facing.


/Lennart
 >> Stay informed about: db2 V9.5 SQL1084C 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine - Environment: DB2 UDB LUW (AIX) 8.2 Database instance: test migration to 64 bit Clients: 32 bit, embedded sql, db2 clp When PATH/LIBPATH point to the 32 lib environment (/usr/opt/db2_08_01/bin and (/usr/opt/db2_08_01/lib) db2..

How to reterive the last 5 records in a table? - Hi I have a table which contains number of rows. I want to fetch the last 5 records from the table. I know for the first 'n' records we can use FETCH FIRST n ROWS ONLY command. But i want to fetch last 5 records. Can any one help in this... ..

&quot;FIND&quot; command is narrowed - In the ISPF editor I am using, for a particullar PO Dataset I am getting the result of FIND statement narrowed down to the colums 48-56. i.e. if I give "FIND 'TO' ALL", the result I am getting as "CHARS 'TO' - found 239 times within colum...

Schema mapper - As do all such projects, my latest venture into DB design has grown as the user becomes more educated to his needs, the design process and the capabilities of those involved. I am looking for a tool which I can point to a db2 dub schema and get a..

Sample package - Hi All, I want to create a very simple db2 package and bind it . The test is to bind multiple versions of a package. So I want to first create a package ,bind it and then modify it to create another version . Any ideas about how to complete this..
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]