IBM E027SLL-H Troubleshooting Guide - Page 244
Oracle problem with JDBC drivers prior to 11.1.0.7, Database contents are incorrect after
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 244 highlights
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.batscript 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
-
1
-
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
10
-
11
-
12
-
13
-
14
-
15
-
16
-
17
-
18
-
19
-
20
-
21
-
22
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
-
41
-
42
-
43
-
44
-
45
-
46
-
47
-
48
-
49
-
50
-
51
-
52
-
53
-
54
-
55
-
56
-
57
-
58
-
59
-
60
-
61
-
62
-
63
-
64
-
65
-
66
-
67
-
68
-
69
-
70
-
71
-
72
-
73
-
74
-
75
-
76
-
77
-
78
-
79
-
80
-
81
-
82
-
83
-
84
-
85
-
86
-
87
-
88
-
89
-
90
-
91
-
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
-
100
-
101
-
102
-
103
-
104
-
105
-
106
-
107
-
108
-
109
-
110
-
111
-
112
-
113
-
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
-
122
-
123
-
124
-
125
-
126
-
127
-
128
-
129
-
130
-
131
-
132
-
133
-
134
-
135
-
136
-
137
-
138
-
139
-
140
-
141
-
142
-
143
-
144
-
145
-
146
-
147
-
148
-
149
-
150
-
151
-
152
-
153
-
154
-
155
-
156
-
157
-
158
-
159
-
160
-
161
-
162
-
163
-
164
-
165
-
166
-
167
-
168
-
169
-
170
-
171
-
172
-
173
-
174
-
175
-
176
-
177
-
178
-
179
-
180
-
181
-
182
-
183
-
184
-
185
-
186
-
187
-
188
-
189
-
190
-
191
-
192
-
193
-
194
-
195
-
196
-
197
-
198
-
199
-
200
-
201
-
202
-
203
-
204
-
205
-
206
-
207
-
208
-
209
-
210
-
211
-
212
-
213
-
214
-
215
-
216
-
217
-
218
-
219
-
220
-
221
-
222
-
223
-
224
-
225
-
226
-
227
-
228
-
229
-
230
-
231
-
232
-
233
-
234
-
235
-
236
-
237
-
238
-
239
-
240
-
241
-
242
-
243
-
244
-
245
-
246
-
247
-
248
-
249
-
250
-
251
-
252
-
253
-
254
-
255
-
256
-
257
-
258
-
259
-
260
-
261
-
262
-
263
-
264
-
265
-
266
-
267
-
268
-
269
-
270
-
271
-
272
-
273
-
274
-
275
-
276
-
277
-
278
-
279
-
280
-
281
-
282
-
283
-
284
-
285
-
286
-
287
-
288
-
289
-
290
-
291
-
292
-
293
-
294
-
295
-
296
-
297
-
298
-
299
-
300
-
301
-
302
-
303
-
304
-
305
-
306
-
307
-
308
-
309
-
310