Results 1 to 3 of 3

Thread: SET Command

  1. #1
    Join Date
    Jun 2003
    Posts
    38

    Unanswered: SET Command

    Hi,

    Can anyone tell me the syntax of SET TABLE command. I am using IDS 9.3

    The SET TABLE command is used to turn on the the resident state of one or more fragments of a table.

    Regards,
    Anu_R

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    SET TABLE tab1 MEMORY_RESIDENT
    SET INDEX index1 (dbspace1, dbspace2) MEMORY_RESIDENT;
    SET TABLE tab1 (dbspace1) NON_RESIDENT
    Fred Prose

  3. #3
    Join Date
    Nov 2003
    Location
    Pune, India
    Posts
    22
    Hi,
    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
    attached index.

    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
    resident.

    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.
    Regards,
    Amit.K.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •