Oninit cdi / Archive
Talk to an expert →

DROPPING BUFFERPOOL

Posted in 2010

Topics: Storage & Space Management, Server Administration

TATIANA FLORES — — source: IIUG Forums & Mailing Lists

HI FOLKS! I AM WONDERING IF I CAN DROP A BUFFERPOOL REMOVING ONLY THE BUFFERPOOL ENTRY FROM THE ONCONFIG FILE AND RESTARTING THE ENGINE? I CREATED A DBSPACE WITH A PAGE SIZE OF 4K, BUT ACTUALLY I WAS NEEDING ONE OF 8K .. BUT THE ENTRY OF 4K STILL IN ONCONFIG. I WILL THANK YOU YOUR COMMENTS. REGARDS

↪ replying to TATIANA FLORES
Art Kagel — — source: IIUG Forums & Mailing Lists

Yes. That will do the trick assuming you have dropped the 4k dbspace. If it is not already there you can also put on the entry for the 8k bufferpool. Art On Nov 18, 2010 3:05 PM, "TATIANA FLORES" <jessytapoli@hotmail.com> wrote: > HI FOLKS! > > I AM WONDERING IF I CAN DROP A BUFFERPOOL REMOVING ONLY THE BUFFERPOOL ENTRY > FROM THE ONCONFIG FILE AND RESTARTING THE ENGINE? > > I CREATED A DBSPACE WITH A PAGE SIZE OF 4K, BUT ACTUALLY I WAS NEEDING ONE OF > 8K .. BUT THE ENTRY OF 4K STILL IN ONCONFIG. > > I WILL THANK YOU YOUR COMMENTS. > > REGARDS > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --20cf3054a5dfe27aba04955a0653

↪ replying to Art Kagel
Tatiana Flores — — source: IIUG Forums & Mailing Lists

Yeah!!!... the dbspace was dropped before... thank you very much. Grettings!! > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: DROPPING BUFFERPOOL [21997] > Date: Thu, 18 Nov 2010 15:56:45 -0500 > > Yes. That will do the trick assuming you have dropped the 4k dbspace. If > it is not already there you can also put on the entry for the 8k bufferpool. > > Art > On Nov 18, 2010 3:05 PM, "TATIANA FLORES" <jessytapoli@hotmail.com> wrote: > > HI FOLKS! > > > > I AM WONDERING IF I CAN DROP A BUFFERPOOL REMOVING ONLY THE BUFFERPOOL > ENTRY > > FROM THE ONCONFIG FILE AND RESTARTING THE ENGINE? > > > > I CREATED A DBSPACE WITH A PAGE SIZE OF 4K, BUT ACTUALLY I WAS NEEDING ONE > OF > > 8K .. BUT THE ENTRY OF 4K STILL IN ONCONFIG. > > > > I WILL THANK YOU YOUR COMMENTS. > > > > REGARDS > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --20cf3054a5dfe27aba04955a0653 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Glossary