IBM E027SLL-H - Tivoli Monitoring - PC, Troubleshooting Manual

Page: 244 / 310

1. From a Windows desktop, select Start > Control Panel > Administrative
Tools > Services .
2.
Scan the column on the right for the value
.\db2admin
.
3. Do the following for each
.\db2admin
value: Open the Properties window;
select the Log On tab; and type the new password for the user.
What to do next
For information on how to modify kernel parameters, see “Modifying kernel
parameters” (http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/
com.ibm.db2.luw.qb.server.doc/doc/t0008238.html)
Oracle problem with JDBC drivers prior to 11.1.0.7
You receive an error like the following on the Summarization and Pruning java log
when using Oracle:
== 509 t=work1 java.lang.ArrayIndexOutOfBoundsException
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers
(OraclePreparedStatement.java:2673)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch
(OraclePreparedStatement.java:10689)
at com.tivoli.twh.ksy.agg.BatchManager.executeBatch(BatchManager.java:381)
at com.tivoli.twh.ksy.agg.BatchManager.commit(BatchManager.java:488)
at com.tivoli.twh.ksy.agg.BatchManager.checkCommit(BatchManager.java:575)
at com.tivoli.twh.ksy.agg.RawTable.aggregateData(RawTable.java:2356)
at com.tivoli.twh.ksy.agg.Originnode.aggregateDataForNode
(Originnode.java:180)
at com.tivoli.twh.ksy.agg.RawTable.createAggregatesAndPrune
(RawTable.java:3286)
at com.tivoli.twh.ksy.agg.Worker.run(Worker.java:98)
Use a smaller number of rows per database transaction.
Database contents are incorrect after installation
Use the movefrome-m2i.bat script to migrate the contents of Microsoft SQL Server
to Universal Database if you have database migration problems.
You can run the
movefrom-m2i.bat
located in the
install_dir\cnps
directory to
recover the contents of the database. The
movefrom-m2i.bat
utility creates a flat file
from the SQL server database contents and imports into the Universal Database.
The utility runs during the installation of the Tivoli Enterprise Portal when the
option to migrate from Microsoft SQL Server to the Universal Database is selected
but can also be used after installation or routine Tivoli Enterprise Portal usage.
This migration utility can fail if the Tivoli Enterprise Portal userid and password
do not have the correct authority to connect to the Tivoli Enterprise Monitoring
ServerUniversal Database. The
movefrom-m2i.bat
script requires that the Microsoft
SQL server database is on the same Windows platform as the monitoring server
and the new Universal Database installation. Use this utility only after migration
problems and before customizing the monitoring server. The
movefrom-m2i.bat
is
only used to migrate the contents of Microsoft SQL Server to Universal Database.
226
IBM Tivoli Monitoring: Troubleshooting Guide