IBM Support

ITCAM for MS Applications SQL Server agent Silent Installation/Configuration

Technical Blog Post


Abstract

ITCAM for MS Applications SQL Server agent Silent Installation/Configuration

Body

Is it possible to install (and config) the ITCAM MS-Applications MSSQL agent (KOQ) silently?

We have logged onto a server where the agent has been manually installed and configured and exported the responsible file by using the utility in kinconfg and its generated the following...

[INSTALLATION SECTION]
License Agreement=I agree to use the software only in accordance with the installed license.
Install Directory=C:\IBM\ITM
Install Folder=IBM Tivoli Monitoring
EncryptionKey=
[AGENT_INSTANCES]
KOQ64CMA=DMGBVSQL01
[FEATURES]
KGL64CMA=Tivoli Enterprise Monitoring Agent Framework(86-x64 only)
KOQ64CMA=Monitoring Agent for Microsoft SQL Server(86-x64 only)
[CMA_CONFIG]
Disable_HTTP=Y
Protocol1=IP.PIPE
IPPIPE_Host=hostname.ibm.com
IPPIPE_Port=1918
IPPIPE_Partition=
FTO Flag=Y
FTO_Protocol1=IP.PIPE
FTO_IPPIPE_Host=hostname.ibm.com

Where do we set the instance settings such as DBSETTINGS.db_login=UserId

https://www.ibm.com/support/knowledgecenter/en/SSDKXQ_6.3.1/com.ibm.itcamms.doc_6.3.1/sql/configsettings.html

Answer:

ITCAM for MS Applications MS-SQL agent does not allow silent configuration for multi-instances agents like OQ agent.

This is also the reason why there are not available response files or documentation in the Installation guide manuals.

In the response file even if you add the agent specific parameters it does not configure the agent.

For local as well as for Remote configuration we have to use either GUI or CLI (tacmd).

So basically you an silently install the agent, but then you need to use TEP client or tacmd AddSystem like:

tacmd addSystem -t OQ -n Primary:myhostname:NT -p
DBSETTINGS.db_login=sa
DBSETTINGS.db_password=sapwd
DBSETTINGS.db_home="C:\Program Files\Microsoft SQL Server\MSSQL"
DBSETTINGS.db_errorlog="C:\Program FilesçMicrosoft SQL
Server\MSSQL\LOG\ERRORLOG"
DBSETTINGS.db_winauth=1
DBSETTINGS.db_lldbconn=0
DBSETTINGS.db_include=£master££temp%
INSTANCE=MyServer
DBSETTINGS.db_tbld_weekly=1
DBSETTINGS.db_tbld_coll_stime_hour=23
DBSETTINGS.db_tbld_coll_stime_minute=59
..
..

in order to create and configure the new instance.

 

[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

UID

ibm11083129