Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

[Ian]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

Mark A wrote:[color=blue]
> "Smutny30" <smutny30@poczt a.onet.pl> wrote in message
> news:d4m11i$35b $1@news.onet.pl ...
>[color=green]
>>Hello , I found out that db2icrt has -w switch that declares the instance
>>to be 32 or 64. Is it a correct way ?
>>
>>sincerely Olek[/color]
>
> Yes, but you will have create a new instance, you cannot change the existing
> 32 bit instance to 64 bit.[/color]

Yes, you can. db2iupdt -w 64 <instance>

[Smutny30]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

Uzytkownik "Ian" <ianbjor@mobile audio.com> napisal w wiadomosci
news:426fbba1_5 @newsfeed.slurp .net...[color=blue]
> Smutny30 wrote:[color=green]
>> U¿ytkownik "Mark A" <nobody@nowhere .com> napisa³ w wiadomo¶ci
>> news:ua6dnT5C-aSu7_PfRVn-iQ@comcast.com. ..
>>[color=darkred]
>>>"Smutny30" <smutny30@poczt a.onet.pl> wrote in message
>>>news:d4lql3$ l29$1@news.onet .pl...
>>>[/color][/color][/color]
[color=blue]
> Also make sure that you're running a 64-bit kernel. The p5 servers with
> AIX 5.3 preloaded I've worked on have all come with the 32 bit kernel
> by default instead of the 64-bit kernel. 'bootinfo -K' will tell you
> what kernel you have.
>[/color]

Hello Ian , I'm 64-bit

bash-2.05b# bootinfo -K
64

Ian, maybe you know wheather I should change daemons:

# bash
bash-2.05b# ps -ef | grep db2
dasusr1 327836 1 0 14:29:08 - 0:01
/u01/home/dasusr1/das/bin/db2fmd -i dasusr1 -m
/u01/home/dasusr1/das/lib/libdb2dasgcf.a
root 643326 1 0 14:29:08 - 0:09
/usr/opt/db2_08_01/bin/db2fmcd


Both db2fmd and db2fmcd have their 64-bit versions.

Currently I run 64-bit instance with these 32-bit daemons.

Sincerely Olek

[Mark A]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

"Ian" <ianbjor@mobile audio.com> wrote in message
news:426fbbb9_5 @newsfeed.slurp .net...[color=blue][color=green]
>>
>> Yes, but you will have create a new instance, you cannot change the
>> existing 32 bit instance to 64 bit.[/color]
>
> Yes, you can. db2iupdt -w 64 <instance>
>[/color]

Thanks, I didn't know that.

Here is doc for db2iupdt from the 8.1 Command Reference:

-w WordWidth
Specifies the width, in bits, of the instance to be created. Valid values
are 32 and 64. This parameter is only valid on AIX, HP-UX, and the Solaris
Operating Environment. The requisite version of DB2 must be installed
(32-bit or 64-bit).

and the doc for db2iupdt in 8.2 Command Reference:

-w WordWidth
Specifies the width, in bits, of the instance to be created. Valid values
are 31, 32, and 64. This parameter is only valid on AIX, HP-UX, Linux for
AMD64, and the Solaris Operating Environment. The requisite version of DB2
must be installed (31-bit, 32-bit, or 64-bit). The default value is the bit
width of the instance that is being updated.

I noitce that in both cases, the say "of the instance to be created". I
wonder why that is? Just a typo?

[Ian]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

Mark A wrote:[color=blue]
> "Ian" <ianbjor@mobile audio.com> wrote in message
> news:426fbbb9_5 @newsfeed.slurp .net...
>[color=green][color=darkred]
>>>Yes, but you will have create a new instance, you cannot change the
>>>existing 32 bit instance to 64 bit.[/color]
>>
>>Yes, you can. db2iupdt -w 64 <instance>
>>[/color]
>
> Thanks, I didn't know that.
>
> Here is doc for db2iupdt from the 8.1 Command Reference:
>
> -w WordWidth
> Specifies the width, in bits, of the instance to be created. Valid values
> are 32 and 64. This parameter is only valid on AIX, HP-UX, and the Solaris
> Operating Environment. The requisite version of DB2 must be installed
> (32-bit or 64-bit).
>
> and the doc for db2iupdt in 8.2 Command Reference:
>
> -w WordWidth
> Specifies the width, in bits, of the instance to be created. Valid values
> are 31, 32, and 64. This parameter is only valid on AIX, HP-UX, Linux for
> AMD64, and the Solaris Operating Environment. The requisite version of DB2
> must be installed (31-bit, 32-bit, or 64-bit). The default value is the bit
> width of the instance that is being updated.
>
> I noitce that in both cases, the say "of the instance to be created". I
> wonder why that is? Just a typo?
>
>[/color]

Probably a typo. My guess is that the person writing the doc copied the
text from the 'db2icrt' command.

[Mark A]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

"Ian" <ianbjor@mobile audio.com> wrote in message
news:42702b2a$1 _3@newsfeed.slu rp.net...[color=blue][color=green]
>> I noitce that in both cases, the say "of the instance to be created". I
>> wonder why that is? Just a typo?[/color]
>
> Probably a typo. My guess is that the person writing the doc copied the
> text from the 'db2icrt' command.
>[/color]
Probably, but since they changed the text for 8.2, I would have thought that
some would have read the text and noticed it.

[Jurgen Haan]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

Smutny30 wrote:[color=blue]
>
> I have now my 64-bit DB2 instance up and runing, and allocating all 2,4 GB
> for bufferpools. Great appreciation for all the people that helped me to
> solve it.
>
> sincerely Olek
>[/color]

Plz. post solution, may help a lot of people who are stuck.

-R-

[Mark A]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

"Jurgen Haan" <jurgen@fake.do m> wrote in message
news:427098e1$0 $157$e4fe514c@n ews.xs4all.nl.. .[color=blue][color=green]
>> I have now my 64-bit DB2 instance up and runing, and allocating all 2,4
>> GB for bufferpools. Great appreciation for all the people that helped me
>> to solve it.
>>
>> sincerely Olek[/color]
>
> Plz. post solution, may help a lot of people who are stuck.
>
> -R-
>[/color]
The solution was to create a 64 bit instance instead of a 32 bit instance.
That way, the limit on the amount of memory that a DB2 instance can use is
no longer restricted to 1.75 GB for AIX (limit depends on OS).

[Jurgen Haan]

Re: Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

Mark A wrote:[color=blue]
> "Jurgen Haan" <jurgen@fake.do m> wrote in message
> news:427098e1$0 $157$e4fe514c@n ews.xs4all.nl.. .
>[color=green][color=darkred]
>>>I have now my 64-bit DB2 instance up and runing, and allocating all 2,4
>>>GB for bufferpools. Great appreciation for all the people that helped me
>>>to solve it.
>>>
>>>sincerely Olek[/color]
>>
>>Plz. post solution, may help a lot of people who are stuck.
>>
>>-R-
>>[/color]
>
> The solution was to create a 64 bit instance instead of a 32 bit instance.
> That way, the limit on the amount of memory that a DB2 instance can use is
> no longer restricted to 1.75 GB for AIX (limit depends on OS).
>
>[/color]

Ah... apologies. Due to the seperate post in the thread I thought it was
solved by different means than the mere 32 -> 64 bit conversion.

-R-