You can set eh residency in the follwoing manner-
SET TABLE abc RESIDENT
Specifies that all pages of the table named abc and its attached
index pages are to be resident.
SET TABLE abc RESIDENT on dbs1,dbs3
Specifies that only pages from the fragments in dbs1 and dbs3 are to be
resident. These pages will include both table and index pages for the
SET TABLE abc RESIDENT WITH INDEX ALL
Specifies that the table and its detached indexes will be resident.
SET INDEX abcindex RESIDENT
Specifies that only the pages of the detached index abcindex will be
SET INDEX abc ON dbs3
Specifies that only the detached index fragment in dbs3 will be resident.
Note multiple SET commands may be used repeatedly on the same table or detached index. Note also that memory residency does not span the life of the server. This means that when IDS is restarted, memory residency must be reestablished for tables and indexes.