IBM E027SLL-H Troubleshooting Guide - Page 242

DB2 pureScale environment

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

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 Database
from 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