mibconfig.dbserver table

The mibconfig.dbserver table defines the structure for MIB identifier and log-in information.

The table below describes the mibconfig.dbserver table.

Table 1. mibconfig.dbserver Database Table Schema  

Column name

Constraints

Data type

Description

 
m_DbId

NOT NULL

Text

Database identifier.

 
m_DbName

NOT NULL

Text

Name of the database.

 
m_EncryptedPwd
   Integer Flag indicating whether the passwords in the OQL insert are encrypted:
  • 0: No
  • 1: Yes
 
m_IsDB2HADREnabled
   Integer

Flag indicates whether the DB2 database is running in HADR mode:

  • 0: Database is not running in HADR mode.
  • 1: Database is running in HADR mode.
 
m_Hostname

NOT NULL

Text

Hostname of the database server.

 
m_OracleService
   Integer

If you are using Oracle, this flag indicates whether a connection is being made to a service or an SID. If you are using a topology database other than Oracle, this flag is ignored. The default is 0.

  • 0: Connect using an Oracle SID.
  • 1: Connect using an Oracle service name.
 
m_Password

NOT NULL

Text

Password for the database.

 
m_PortNum
  

Integer

Port for the database, if not accepting the default.

 
m_Schema

NOT NULL

Text

Name of the database schema.

 
m_Server

NOT NULL

Text

Database server: Oracle or Db2.

 
m_Username

NOT NULL

Text

Username for the database.

Example inserts into the mibconfig.server table in the DbLogins.cfg file

The following inserts are configured in the default $NCHOME/etc/precision/MibDbLogin.cfg configuration file.
insert into mibconfig.dbserver
(
    m_DbId,
    m_Server,
    m_DbName,
    m_Schema,
    m_Hostname,
    m_Username,
    m_Password,
    m_PortNum,
    m_EncryptedPwd,
    m_OracleService
)
values
(
    "MIB",  -- Logical name for this conection (don't change it)
    "db2",
    "NCIM",
    "ncmib",
    "localhost",
    "ncim",
    "ncim",
    50000,
    0,
    1
);