473,898 Members | 2,907 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Different NUMBLOCKPAGES across Partitions (DPF)?

I have a Windows DPF (v8.2.2) environment.
2 Nodes
5 Partitions
Server1 - Cat (0) Data (1) Data (2)
Server2 - Data (3) Data (4)

I want to use block-based IO, but I do not want the same size block
area of the bufferpool in each partition, I want a smaller value in the
catalog partition - because the bufferpool size is much smaller.

My (uniform) page size is 16k, my data partitions have a size of 10,000
pages, numblockpages=5 ,000 and blocksize=4

Every time I connect/activate I get the error that my numblockpages
exceeds the maximum size.

I am trying to execute this:
alter bufferpool pm_16k_bp dbpartitionnum 0 numblockpages 1000
or
alter bufferpool pm_16k_bp dbpartitionnum 0 size 2000 numblockpages
1000 blocksize 4
or
?

It returns:
SQL0104N An unexpected token "numblockpa ges" was found following "_bp
dbpartitionnum 0".
I cannot figure out the syntax for this.

Please forward an example if you can.

Thanks in advance.
John

Nov 12 '05 #1
3 2476
jc******@yahoo. com wrote:
I have a Windows DPF (v8.2.2) environment.
2 Nodes
5 Partitions
Server1 - Cat (0) Data (1) Data (2)
Server2 - Data (3) Data (4)

I want to use block-based IO, but I do not want the same size block
area of the bufferpool in each partition, I want a smaller value in the
catalog partition - because the bufferpool size is much smaller.

My (uniform) page size is 16k, my data partitions have a size of 10,000
pages, numblockpages=5 ,000 and blocksize=4

Every time I connect/activate I get the error that my numblockpages
exceeds the maximum size.

I am trying to execute this:
alter bufferpool pm_16k_bp dbpartitionnum 0 numblockpages 1000
or
alter bufferpool pm_16k_bp dbpartitionnum 0 size 2000 numblockpages
1000 blocksize 4
or
?

It returns:
SQL0104N An unexpected token "numblockpa ges" was found following "_bp
dbpartitionnum 0".


You can either specify "DBPARTITIO NNUM ... SIZE ..." or "NUMBLOCKPA GES ..."
but not both together. Have a look at the syntax diagram:
http://publib.boulder.ibm.com/infoce...n/r0000885.htm
(the description how to read them is here:
http://publib.boulder.ibm.com/infoce...n/r0006726.htm)

You can define a buffer pool that only resides on certain partitions.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2
Knut,

Thanks for the reply. I was trying to get away with only using one
bufferpool - while dedicating as much memory to my data partitions - I
did not want the catalog partition to get the memory that it will never
consume.

I thought of just creating a single partition bufferpool in Partion 0,
but that causes a problem for tempspace. Temprory tablespaces belong
to IBMTEMPGROUP which exists across all partitions. So, I still need a
bufferpool (for tempspace) that will span all partitions.

It appears that my best option would be to keep the single BP, minimize
the size on Partition 0, and minimize the size of the NUMBLOCKPAGES
area in all Partitions.

Thanks..John

Nov 12 '05 #3
Ian
jc******@yahoo. com wrote:
Knut,

Thanks for the reply. I was trying to get away with only using one
bufferpool - while dedicating as much memory to my data partitions - I
did not want the catalog partition to get the memory that it will never
consume.

I thought of just creating a single partition bufferpool in Partion 0,
but that causes a problem for tempspace. Temprory tablespaces belong
to IBMTEMPGROUP which exists across all partitions. So, I still need a
bufferpool (for tempspace) that will span all partitions.

It appears that my best option would be to keep the single BP, minimize
the size on Partition 0, and minimize the size of the NUMBLOCKPAGES
area in all Partitions.

Thanks..John


John,

It is a lot easier to manage if you create separate bufferpools --
assuming you have a nodegroup that encompasses your 4 data partitions,
create the bufferpool for the nodegroup that needs it.

The ability to change bufferpool sizes per partition is convenient
in situations where it's necessary (i.e. different servers have
differing amounts of real memory), but it makes managing things
more complicated in the future.

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4169
by: curious_one | last post by:
Hi, Is there a way to access a single instance of an object(singleton class) across different processes ? thanks curious.one
8
2588
by: Joachim Mueller | last post by:
Have written a litte sql for showing the utilization of the tablespace. (found it within the newsgroup from Paul Vernon). Looks fine for an one Partition System only. But how i can I see on which Partiton the Tablesapces reside. select substr(TABLESPACE_NAME,1, 18) as TABLESPACE_NAME, case when TABLESPACE_TYPE = 0 then 'DMS' else 'SMS' end as TBS_TYPE,
1
1551
by: mairhtin o'feannag | last post by:
Hello, I am about to (fingers and mouse at the ready) install DB2 on a Linux machine using the db2setup command. All is well. But .... During the install it asks if I want to create an instance, which I believe I do. My hesitation is that this computer will be the co- ordinator node for a multi-node (two computers) system in the very near future. I need to have a single node for now, using many disks and partition across the disks...
2
3693
by: wombat53 | last post by:
Hi Group Are there any DB2 UDB ESE DPF V8.2 users exploiting "buffered inserts" (BIND parm INSERT BUF) *and* "multi-row INSERTS" (many rows associated with the VALUES clause of the INSERT to minimize number of calls to the RDMBS engine) in an SQL PL Stored Procedure? I ask, as the latter would imply embedded DYNAMIC SQL due to potentially varying number of rows to be inserted (assume it's varying), and so, the SQL INSERT would have be...
6
4094
by: Sam Durai | last post by:
A join query is running against my db which is logically partitioned. The join involves a partitioned table (has around 300 Million rows) which is spread across 7 partitions and a small non-partitioned table (has around 2000 rows). Joining the table based on the partitioning key The query has been running for the past 30 mins without fetching any result set and usually I understand that it would run only for less than 5 mins. ...
3
1418
by: VMK | last post by:
Guys, Couple of days ago when I asked to attend db2 session, there instructor told me a different thing, I just want to confirm that is true or not. Here we go... In DPF if we configure a tablespace(4K Page size) across multiple partitions, each partition supports 64GB(Max). This is what he said, is
10
10308
by: Hardy | last post by:
Hi gurus, I know many of you are very senior DBAs and experts from IBM internal, so I really want to know your advice on this basic topic. "why dpf?" usually there's a rumor, em, I believe it's a rumor, that DPF can help you get greater performance, so even only one server, many IBM presales will sell DPF feature with the performance story. DPF license is not a cheap one:) I believe DPF is much more for scalability than performance.
2
1661
by: Sam Durai | last post by:
In Information Center it says; "Restrictions on database partitions - The use of any features of the native XML data store will prevent future use of the database partitioning feature available with DB2 Enterprise Server Edition. - An XML column or XML schema repository (XSR) object cannot be defined in a table of a database with more than one database partition defined. - If a database is defined with a single database partition and...
2
2404
by: 4.spam | last post by:
Hello, all. DB2 v9.5.1 ESE, Windows 2003 Server 64-bit, 4 CPU (8 cores) each, DPF environment. There are 2 DPF instances on the same set of 5 computers. One computer holds coordinator partitions and other 4 hold partitioned tables (2 logical nodes per computer). Application: DataStage v8 running some (say 32) parallel massive single row inserts
0
9841
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10949
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10484
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7187
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5882
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6077
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4296
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3306
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.