[Info-ingres] Table partitioning questions

Hi There,

Having just unwrapped a new IngresII R3, I thought I'd take it for a spin
while its still got that new database smell.

Version: II 3.0.2 (a64.lnx/111)

If I make an existing btree table partitioned with:
modify resultz to btree on cid, trid /*The original key structure*/
with partition=(hash on cid,trid 10 partitions (
resultz_pp1, resultz_pp2, resultz_pp3, resultz_pp4,
resultz_pp5, resultz_pp6, resultz_pp7, resultz_pp8,
resultz_pp9, resultz_pp10
));
commit;

I expected that I'd end up with 10 physical files and that the table
names associated would be resultz_pp1 etc. The table name resultz I
expected would be retained as an overall 'link', but have no physical
disk presence.

I though that by naming the partitions I should be able to separately
modify each of them,
eg modify resultz_pp1 to btree on cid, trid

Sadly not. I was wrong on every one of these points!

There are 11tables, the original resultz, and 10 tables named:
"ii19e pp0-resultz", "ii19f pp1-resultz" etc.

Now I can cope with the original table name remaining - but what
happened to my partition names?

I cant modify resultz_pp1 - the table is flagged as not existing.

I cant modify "ii19f pp1-resultz" - for the same reason.

If I run a help table resultz, I get the standard guff with the extra lines:
Type: user table (partitioned) /*Comforting!*/
Table partitioning definition:

partition = (HASH on cid, trid
partition resultz_pp1,
partition resultz_pp2,
partition resultz_pp3,
partition resultz_pp4,
partition resultz_pp5,
partition resultz_pp6,
partition resultz_pp7,
partition resultz_pp8,
partition resultz_pp9,
partition resultz_pp10
) /*which sort of says the partitioning bit*/

Anyone care to shed some light on this?

Martin Bowes
--
Random Duckman Quote #102:
Cornfed: Uh Oh.
Duckman: 'Uh Oh' as in 'Nice Work?'
Cornfed: No, as in 'You're screwed.'
.

Relevant Pages

  • Re: [Info-ingres] Table partitioning questions
    ... modify resultz to btree on cid, trid /*The original key structure*/ with partition=(hash on cid,trid 10 partitions ( ... I expected that I'd end up with 10 physical files and that the table ... I though that by naming the partitions I should be able to separately ... modify each of them, ...
    (comp.databases.ingres)
  • Re: raid-one
    ... It's a common question that people will ask whether they can modify ... them will warn about losing data as part of the operation. ... Not everybody partitions a drive before installing to it, ... I will add a place where they must show this basic knowledge or not try to do raid-1. ...
    (Fedora)
  • Re: raid-one
    ... Remember that when you write instructions, it's people who know little, ... It's a common question that people will ask whether they can modify ... them will warn about losing data as part of the operation. ... Not everybody partitions a drive before installing to it, ...
    (Fedora)
  • Re: install SuSE 9.0 onto a multi-partition drive with Windows, RedHat, BSD and Solaris
    ... I have made ext3 partitions under SUSE ... > That's because they attempt to parse the bootloader file and modify it ... Use only one set of tools to modify the ...
    (alt.os.linux.suse)