Results 1 to 2 of 2

Thread: MDC tables

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: MDC tables

    how to identify MDC tables in database system tables stores the info ??

    regds
    paul

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    got it

    CLUSTERED CHAR (1) Y Y = Table is multidimensionally clustered (even if only by one dimension)
    Null value = Table is not multidimensionally clustered

    ACTIVE_BLOCKS BIGINT Total number of active blocks in the table, or -1. Applies to multidimensional clustering (MDC) tables only.

    in syscat.tables
    regds
    paul

Posting Permissions

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