config.dbserver table

The config.dbserver table defines the structure for database identifier and log-in information.

The table below describes the config.dbserver table.

Table 1. config.dbserver database table schema  

Column name

Constraints

Data type

Description
m_ConnectionString  

Text

Oracle only: optional connection string override.
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_Hostname

NOT NULL

Text

Hostname of the database server.
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_IsKerberos   Boolean integer

Indicates whether to use Kerberos authentication:

  • 0: Use SQL Server (username/password) authentication.
  • 1: Use Kerberos authentication.
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 config.server table in the DbLogins.cfg file

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

//
// The poll data database
//
insert into config.dbserver
(
	m_DbId,
	m_Server,
	m_DbName,
	m_Schema,
	m_Hostname,
	m_Username,
	m_Password,
	m_PortNum,
	m_EncryptedPwd,
       m_OracleService
)
values
(
	"POLLDATA",   -- Logical name for this connection (don't change it)
	"db2",
	"NCIM",
	"ncpolldata",
	"localhost",
	"ncim",
	"ncim",
	50000,
	0,
       1
);

//
// The GUI database
//
insert into config.dbserver
(
	m_DbId,
	m_Server,
	m_DbName,
	m_Schema,
	m_Hostname,
	m_Username,
	m_Password,
	m_PortNum,
	m_EncryptedPwd,
       m_OracleService
)
values
(
	"NCPGUI",   -- Logical name for this connection (don't change it)
	"db2",
	"NCIM",
	"ncpgui",
	"localhost",
	"ncim",
	"ncim",
	50000,
	0,
       1
);

//
// The embedded discovery database
//
insert into config.dbserver
(
	m_DbId,
	m_Server,
	m_DbName,
	m_Schema,
	m_Hostname,
	m_Username,
	m_Password,
	m_PortNum,
       m_EncryptedPwd,
       m_OracleService
)
values
(
	"DNCIM",  -- Logical name for this connection (don't change it)
	"SQLITE",
	"main",
	"dncim",
	"localhost",
	"root",
	"admin",
	0,
       0,
       1
);

Example inserts into the config.server table in the DbLogins.cfg file to define a third-party database

The following insert defines identifier and connection information for a third-party Tivoli Data Warehouse database.
Example insert for a TDW Database that could be used by
the MACFromTDWDatabase agent.
insert into config.dbserver
(
    m_DbId,
    m_Server,
    m_DbName,
    m_Schema,
    m_Hostname,
    m_Username,
    m_Password,
    m_PortNum,
    m_EncryptedPwd,
    m_OracleService
)
values
(
    "TDW",
    "oracle", // doesn't have to be oracle
    "SOMEDB",
    "SOMESCHEMA",
    "someServer.someWhere.com",
    "a_tdw_user",
    "a_tdw_password",
    1521, // default port for oracle
    0,
    1
);