add fragment

IDS10 UC5 AIX 5.3 Tried adding a new fragment, threw a error, any idea? Thanks, Frank Error: alter fragment on table ds_head add partition pt5 (datatype_name [1,2] ='MS') in dbdata04 ; # ^ # 776: Alter fragment error: unable to move row(s) to new fragmentation scheme. # # 111: ISAM error: no record found. # # Table definition: create table "informix".ds_head ( inventory_id serial not null , dataset_name varchar(255,44) not null , dataset_size_bytes int8, datatype_name char(10) not null , datatype_version char(10), ingest_status char(10), ingest_dt datetime year to second not null , orig_data_filenm varchar(255,44) not null , distribution_site char(1) not null , data_source char(10), has_visual_file char(1), restriction_level smallint ) with crcols fragment by expression partition pt1 (datatype_name [1,2] = 'GV' ) in dbdata01 , partition pt2 (datatype_name [1,2] = 'GO' ) in dbdata02 , partition pt3 (datatype_name [1,2] = 'CW' ) in dbdata03 , partition pt4 (datatype_name [1,2] = 'NP' ) in dbdata04 , partition rmd remainder in dbdata05 extent size 8192 next size 8192 lock mode row;

Does the table has index(es) ? probably on datatype_name ? could be other cols as well . If yes, run oncheck -cI (capital I to check whether these indexes are ok. ISAM error -111 often points to corrupted indexes. For the sake of completness run oncheck -cD as well . You might also try to unload all rows to /dev/null , forcing an access plan over the index(es) . HTH Tilman