Virtually hashed tables are supported through system procedures.
sp_addsegment – you cannot create a segment on a device that already has an exclusive segment.
sp_extendsegment – you cannot extend a segment on a device that already has an exclusive segment, and you cannot extend an exclusive segment on a device that has another segment.
sp_placeobject – you cannot use sp_placeobject on a virtually hashed table, and you cannot place other objects on an exclusive segment.
sp_chgattribute – does not allow you to change attributes for virtually hashed tables.
That a table is virtually hashed
The hash_key_factors for the table
attribute_class attribute int_value char_value comments --------------------- --------------- ------------------------ -------------------------------------- ----------- misc table info hash key factors NULL id:10.0, id2:1.0, max_hash_key=1000.0 NULL