Informix Dynamic Server V10 . . . Extended Functionality for Modern Business

290 Informix Dynamic Server V10 . . . Extended Functionality for Modern Business

ALTER FRAGMENT ON INDEX state_ind

MODIFY PARTITION az_part

TO PARTITION part_az (state = "AZ")

IN dbspace3;

ALTER FRAGMENT ON INDEX state_ind

INIT FRAGMENT BY EXPRESSION

PARTITION az_part (state = "AZ") IN dbspace2,

PARTITION ca_part (state = "CA") IN dbspace2,

PARTITION wa_part (state = "WA") IN dbspace3,

PARTITION ny_part (state = "NY") IN dbspace3,

REMAINDER IN dbspace3;

10.1.5 System catalog information for fragments

System catalog, sysfragments, has a partition column varchar (128,0) which

provides the partition name for a given fragment. If you create a fragmented table

with partitions, each row in the sysfragments system catalog contains a partition

name in the partition column. If you create a fragmented table without partitions,

the name of the dbspace appears in the partition column. The server will

continue to use the dbspace varchar(128,0) field for storing dbspace names.

Example 10-10 shows the sysfragments catalog entry for STATE = “AZ” fragment

expression.

Example 10-10 Sysfragments catalog entry

> SELECT * FROM sysfragments WHERE partition ="az_part";

fragtype T

tabid 102

indexname

colno 0

partn 2097159

strategy E

location L

servername

evalpos 0

exprtext (state = 'AZ' )

exprbin <BYTE value>

exprarr <BYTE value>

flags 0

dbspace dbspace1

levels 0