IBM E027SLL-H Troubleshooting Guide - Page 242
DB2 pureScale environment
![]() |
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 242 highlights
If the Windows Local Security Settings are enabled for long or complex passwords, ensure your password meets those syntax requirements for these IDs. If your Windows environment requires you to change passwords regularly do the following to change the portal server database user account password. Note: The following instructions do not apply in UNIX-based systems. 1. On the computer where the portal server is installed, be sure you are logged on to Windows with an ID having administrator authority. 2. From your Windows desktop, select Start > Programs > IBM Tivoli Monitoring > Manage Tivoli Enterprise Monitoring Services. 3. Right-click the Tivoli Enterprise Portal Server and select Advanced > Utilities > Build Tivoli Enterprise Portal Server Databasefrom the menu. 4. Click DB2 to open the Tivoli Enterprise Portal Server Data Source Config Parameters window. 5. Enter the Admin Password. 6. Enter the new Database Password for the portal server database user ID. DB2 pureScale environment The DB2 pureScale environment has some restrictions on tablespace and table creation on the Tivoli Data Warehouse. In a DB2 pureScale environment, the Warehouse Proxy Agent can not create the regular tablespace ITMREG8K The Tivoli Data Warehouse requires one bufferpool and three tablespaces to begin its operation. The bufferpool and tablespaces are created by the warehouse user before the Warehouse Proxy Agent starts, provided the warehouse user has administrative authority to the database. A warehouse user with limited authority cannot create the required bufferpool and tablespaces. Therefore, the procedure to limit the authority of the warehouse user includes steps to create the bufferpool and tablespaces in advance. However, in a DB2 pureScale environment, the Warehouse Proxy agent cannot create the regular tablespace ITMREG8K. The workaround is to connect to the warehouse database with the Warehouse Proxy Agent user, for example, "ITMUser". Then create the tablespaces using the following SQL statements: db2 create regular tablespace ITMREG8K pagesize 8k managed by automatic storage bufferpool ITMBUF8k db2 create user temporary tablespace ITMUSER8K pagesize 8k managed by automatic storage bufferpool ITMBUF8k db2 create system temporary tablespace ITMSYS8K pagesize 8k managed by automatic storage bufferpool ITMBUF8k In a DB2 pureScale environment, the summarization and pruning agent cannot create the table WAREHOUSEMARKER A dimension is a clustering key for a table. One or more dimensions can be selected for a table. When you have more than one dimension on a table, it is considered to be a multidimensionally clustered table. Such a table is created by using the CREATE TABLE statement with the ORGANIZE BY DIMENSIONS clause. The DB2 pureScale environment does not support multidimensional clustering table creation. Therefore, you can not use the ORGANIZE BY DIMENSIONS(OBJECT) clause required to create the table 224 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
![]() |
![]() |
![](/manual_guide/products/ibm-e027sllh-troubleshooting-guide-7c8d102/242.png)