Edit the DBTUNE File

When an Oracle or SQLServer database is converted to an ArcFM database, the corresponding DBTUNE file can contain the keywords that are passed from ArcFM when the ArcFM System tables are created. Below is the text that can be added to your DBTUNE file for either Oracle or SQLServer if you choose to take advantage of this configuration option.

  • For Oracle databases: Append the following text to your DBTUNE file. This also provides support for BLOB fields in the ArcFM System tables. You need to edit the TABLESPACE value to reference an existing tablespace. e.g., “MINER” and “MINER_LOB_SEGMENT.” If you choose not to modify your DBTUNE settings, the ArcFM System tables will be created in the default tablespace assigned to the SDE user.

    ##MM_STORED_DISPLAYS
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (MAP) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_PAGE_TEMPLATES
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (TEMPLATE) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_PACKAGES
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (CONTENTS) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_PERSIST_INFO
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER ZZTABS LOB (Data) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_DESIGNER_FEAT
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (Attributes) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_DESIGNER_CU
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (MMCompatibleUnit) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_EDIT_LOG
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (Data) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_DOCUMENTS
    ATTRIBUTE_BINARY           "BLOB"
    B_STORAGE                  "PCTFREE 0 INITRANS 4 TABLESPACE MINER LOB (DOCUMENT) STORE AS (TABLESPACE MINER_LOB_SEGMENT CACHE PCTVERSION 0)"
    B_INDEX_XML                "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_USER               "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4  NOLOGGING"
    B_INDEX_ROWID              "TABLESPACE MINER_DATA_IX PCTFREE 0 INITRANS 4"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    

  • For SQLServer: Append the following into your DBTUNE file. This allows the database to recognize the keywords passed by ArcFM when the ArcFM System tables are created. You need to edit the filegroup value, e.g., “MINER” and “MINER_DATA_IX” to reference an existing SQL Server filegroup. If you choose not to modify your DBTUNE settings, the ArcFM System tables will be created in the primary filegroup defined for the SDE user.

    ##MM_STORED_DISPLAYS
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_PAGE_TEMPLATES
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_PACKAGES
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_PERSIST_INFO
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_DESIGNER_FEAT
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_DESIGNER_CU
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_EDIT_LOG
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    ##MM_DOCUMENTS
    B_STORAGE                  "WITH FILLFACTOR = 75 on MINER"
    B_INDEX_XML                "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_USER               "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    B_INDEX_ROWID              "WITH FILLFACTOR = 75 on MINER_DATA_IX"
    UI_TEXT "Special Keyword for Miner system table of the same name"
    END
    

QR code for this page

Was this helpful?