| re: V8 DPF feature and instance creation
"mairhtin o'feannag" <irishboycaat@rocketmaildot.com> wrote in message
news:Xns9565724B2BD7Dirishboycarocketmail@64.164.9 8.50...[color=blue]
> 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 for performance. I then need the metrics of
> how long particular queries take. From there, I will add a second node
> and partition across the nodes and take the metrics of how long those
> same queries take. This is all for planning purposes on how many
> machines, and what kind of horse-power is needed.
>
> My question is : Do I create an instance now? Can I then add a node
> without re-creating the instance I already have?[/color]
Yes you can - db2 start database manager add dbpartitionnum .........
[color=blue]
>
> If I create an instance on this machine, should I use the PARTITIONED
> INSTANCE option of the setup? I will be partitioning across the three or
> so disks that I have (if I were to just stripe the TS across the disks, I
> cannot control where the partitions of the primary key are stored - I
> THINK) so I am inclined to think that I use the PARTITIONED INSTANCE
> option.
>[/color]
If you want to have multiple partiions, use the partitioned instance option
of the setup.
[color=blue]
> I'm kinda new to PDF, so please excuse any silliness to this post.
>
> Thanks,
>
> Mairhtin[/color]
| 
