Prev: question regarding runstats and table partitioning
Next: very dynamic cursor
From: Gladiator on 11 Apr 2010 13:05
Hello All ,

Is there any commands to find which is the coordinator partition ?

Thanks in advance.
From: Gladiator on 12 Apr 2010 02:53
Hello All ,

Also can someone explain how to make a partition as Coordinator
partition.


Thanks in advance.
From: whatever on 12 Apr 2010 15:10
On Apr 12, 2:53 am, Gladiator <vkamalnath1...(a)gmail.com> wrote:
> Hello All ,
>
> Also can someone explain how to make a partition as Coordinator
> partition.
>
> Thanks in advance.

From DB2 V9.5 Information center...assuming you are running V9.5

SELECT * FROM TABLE(DB_PARTITIONS()) AS T

Following is sample output from the LIST DATABASE PARTITION GROUPS
SHOW DETAIL command:
DATABASE PARTITION GROUP NAME PMAP_ID DATABASE PARTITION NUMBER
IN_USE
------------------------------ ------- -------------------------
------
IBMCATGROUP 0 0
Y
IBMDEFAULTGROUP 1 0 Y



The catalog partition is the database partition on which all system
catalog tables are stored. All access to system tables must go through
this database partition. All federated database objects (for example,
wrappers, servers, and nicknames) are stored in the system catalog
tables at this database partition.

If possible, you should create each database in a separate instance.
If this is not possible (that is, you must create more than one
database per instance), you should spread the catalog partitions among
the available database partitions. Doing this reduces contention for
catalog information at a single database partition.

When you create a database, it is automatically created across all the
database partitions defined in the db2nodes.cfg file

Cheers..
Shashi Mannepalli
From: Ian on 12 Apr 2010 20:16
On 4/11/10 10:05 AM, Gladiator wrote:
> Hello All ,
>
> Is there any commands to find which is the coordinator partition ?


Yes: execute the statement "VALUES CURRENT DBPARTITIONNUM"

Note: ANY database partition can be a coordinator partition.
Whichever partition your application connects to will be the
coordinator.





From: Mark A on 12 Apr 2010 20:26
"Ian" <ianbjor(a)mobileaudio.com> wrote in message
news:AJOwn.133118$Ye4.123760(a)newsfe11.iad...
>
> Yes: execute the statement "VALUES CURRENT DBPARTITIONNUM"
>
> Note: ANY database partition can be a coordinator partition.
> Whichever partition your application connects to will be the
> coordinator.

Let's say that there are 3 physical servers as follows:

Admin Node: Partition 0
Data Node 1: Partitions 1-4
Data Node 2: Partitions 5-9

Nodegroup 1 = partition 0
Nodegroup 2 = partitions 1-8

Note: In the above example, Partition 0 can contain data, and usually does
if it is non-partitioned data, but in theory could contain partitioned data
as well if included in a nodegroup with other partitions.

Let's assume a user logs on to Data Node 1 and connects to the database (not
to a partition). Which is coordinator partition?


 |  Next  |  Last
Pages: 1 2 3
Prev: question regarding runstats and table partitioning
Next: very dynamic cursor