These system procedures support virtually hashed tables:
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.
sp_help – for virtually hashed table, reports:
That a table is virtually hashed
The hash_key_factors for the table
For example:
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
