---
title: 13.4.3.1 Set Schema Name
description: "# Step 4: Set schema name to the location of the hivedata tables During the hivedata installation one of the tables created was the IM_DB_LOOKUP table. The IM needs to communicate with this table and in order to do this…"
url: "https://i2b2.org/docs/13-4-3-1-set-schema-name/"
updated: "2026-09-15"
category: "i2b2 Installation Guide / Chapter 4. Server Install Guide / B. Legacy Approach - Build Each Cell from Source / Chapter 13. Identity Management (IM) Cell Install / 13.4 Configuration / 13.4.3 Configure the IM Properties"
---

# 13.4.3.1 Set Schema Name

#

Step 4: Set schema name to the location of the hivedata tables

During the hivedata installation one of the tables created was the IM_DB_LOOKUP table. The IM needs to communicate with this table and in order to do this we need to tell it where to find the Hivedata tables. During this step we will set the database schema name for the hivedata.

### Prerequisite

You need to know the location of your Hivedata tables. These are owned by the PM cell.

### Steps to set the location of the IM_DB_LOOKUP table

These steps include example configurations for Oracle, PostgreSQL and SQL Server.

1. In the **im.properties** file scroll to the section called **Bootstrap schema name**.

2. Set the **imschema** to the name of the database / schema where your hivedata tables are located.

  **Bootstrap schema name**

**Oracle Configuration**

im.bootstrapdb.imschema=i2b2hive

**PostgreSQL Configuration**

im.bootstrapdb.imschema=i2b2hive

**SQL Server Configuration**

im.bootstrapdb.imschema=i2b2hive.dbo

3. Save your changes and close the file.