IBM E027SLL-H Troubleshooting Guide - Page 247
Too much historical data is collected, Warehouse Proxy agent failed to export data, There are ORACLE
![]() |
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 247 highlights
Wild card matching is not supported. The only way to mimic that functionality would be to use the substring or scan for string functions instead of the default value and equals. The equals operator only works with full matches. Too much historical data is collected The Summarization and Pruning agent is responsible for generating and storing summarized data, and pruning the data based on information that is stored in the Tivoli Data Warehouse. The data in the data warehouse is a historical record of activity and conditions in your enterprise. The size of summarization data that is collected depends on the following criteria: v The number of agents collecting data v The number of table collected per agent v The size of the table (number and size of columns) v The collection interval (for example 5, 10, 15 or minutes) Pruning data is deleting old data automatically, rather than manually. To reduce the data that is collected, limit the size of your database tables by regularly pruning old data from the data warehouse. If you installed the Summarization and Pruning agent, your configuration settings are set to default values. You can view the current values in the History Collection Configuration window. Refer to "Changing configuration settings using the History Collection Configuration window in the Tivoli Enterprise Portal" in the IBM Tivoli Monitoring Administrator's Guide for instructions. If you need to install the Summarization and Pruning agent, see the IBM Tivoli Monitoring Installation and Setup Guide. There you can find information for environment-wide capacity planning. You can find agent-specific capacity planning information in the user guide for the specific monitoring agent. Warehouse Proxy agent failed to export data The ODBC connection enables the Warehouse Proxy agent to export data to the warehouse database. The WAREHOUSELOG table lets you know how many exports succeeded and how many failed because of an ODBC error or a TIMEOUT issue. See the IBM Tivoli Monitoring Installation and Setup Guide for more information about the WAREHOUSELOG table and configuring the Warehouse Proxy agent. There are ORACLE or DB2 errors in the khdras1.log file About this task The following errors can occur in the khdras1.log if the globalization system environment variable is not set correctly: ORACLE error: [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column 1. Set the environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as a system environment on the Windows computer on which the Warehouse Proxy is installed. 2. Restart the Windows computer so that the Warehouse Proxy windows service recognizes the change. Chapter 13. Database troubleshooting 229
-
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
![]() |
![]() |
![](/manual_guide/products/ibm-e027sllh-troubleshooting-guide-7c8d102/247.png)