IBM E027SLL-H Troubleshooting Guide - Page 243

Receive First Steps error at the end of a DB2 installation, Windows portal server cannot connect

Page 243 highlights

WAREHOUSEMARKER. The workaround is to connect to the warehouse database with the Warehouse Proxy Agent user, for example, "ITMUser". Then create the table using the following SQL statement: CREATE TABLE "WHA_USER"."WAREHOUSEMARKER" ( "ORIGINNODE" CHAR(64) NOT NULL , "OBJECT" CHAR(64) NOT NULL , "MARKERTMZDIFF" INTEGER NOT NULL , "MARKERWRITETIME" CHAR(16) NOT NULL where "WHA_USER" represents the Warehouse Proxy Agent user, for example, "ITMUser". Receive First Steps error at the end of a DB2 installation At the end of my DB2 installation, I received an error that First Steps could not initialize because a supported browser was not present on my system. See"DB2 First Steps fails to launch (Windows)" (http://publib.boulder.ibm.com/infocenter/ db2luw/v9/topic/com.ibm.db2.udb.pd.doc/doc/c0025020.htm). Windows portal server cannot connect to the database If an error message displays indicating the connection failed for security reasons, the end user is logged in to the server with a userid with administrator authority, but is logged into the local domain instead of locally on the system. The user does not have authority to create a data source and register with Windows, or the authority to create a Windows user account. Procedure v Continue installing the software, using the following steps to resolve the error: 1. When the installation completes, log off the current Windows user session and log in with using the db2admin userid. 2. Run install_dir\installITM\DB2DataSource.exe from Windows Explorer or a command prompt. You can run this program again, even if one or more of the tasks completed the first time it ran. 3. Start the Tivoli Enterprise Monitoring Server after the software indicates the Tivoli Enterprise Portal Server configuration was successful. 4. v If the installation is complete but it does not start, the data source might not be defined. Review the install_dir\cnps\kfwras1.log file. If error messages similar to the following are present in the log, the data source was not defined:[IBM][ODBC Driver Manager] Data source name not found and no default driver specified. Use the follow steps to verify whether the data source was created and to resolve the problem: 1. Open the ODBC datasource window: Start > Settings > Control Panel > Administrative tools and double-click the Data Sources (ODBC) . 2. Verify that the IBM DB2 ODBC DRIVER datasource is defined. 3. If the IBM DB2 ODBC DRIVER data source is not present, run the install_dir\installITM\DB2DataSource.exe file. 4. Read the error messages after running the program. 5. If the error is security related or mentions incorrect user IDs or passwords, log in to the Windows server with the db2admin user account and run the db2datasource program. v If the password for db2admin changes, the logon information for the services must also change, otherwise the database does not start because the DB2 processes cannot logon. Use the following steps to resolve this problem: Chapter 13. Database troubleshooting 225

  • 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

WAREHOUSEMARKER. The workaround is to connect to the warehouse database
with the Warehouse Proxy Agent user, for example, “ITMUser”. Then create the
table using the following SQL statement:
CREATE TABLE "WHA_USER"."WAREHOUSEMARKER" ( "ORIGINNODE" CHAR(64) NOT NULL ,
"OBJECT" CHAR(64) NOT NULL , "MARKERTMZDIFF"
INTEGER NOT NULL , "MARKERWRITETIME" CHAR(16) NOT NULL
where
"WHA_USER"
represents the Warehouse Proxy Agent user, for example,
“ITMUser”.
Receive First Steps error at the end of a DB2 installation
At the end of my DB2 installation, I received an error that First Steps could not
initialize because a supported browser was not present on my system. See“DB2
First Steps fails to launch (Windows)” (http://publib.boulder.ibm.com/infocenter/
db2luw/v9/topic/com.ibm.db2.udb.pd.doc/doc/c0025020.htm).
Windows portal server cannot connect to the database
If an error message displays indicating the connection failed for security reasons,
the end user is logged in to the server with a userid with administrator authority,
but is logged into the local domain instead of locally on the system. The user does
not have authority to create a data source and register with Windows, or the
authority to create a Windows user account.
Procedure
v
Continue installing the software, using the following steps to resolve the error:
1.
When the installation completes, log off the current Windows user session
and log in with using the
db2admin
userid.
2.
Run
install_dir
\installITM\DB2DataSource.exe
from Windows Explorer or
a command prompt. You can run this program again, even if one or more of
the tasks completed the first time it ran.
3.
Start the Tivoli Enterprise Monitoring Server after the software indicates the
Tivoli Enterprise Portal Server configuration was successful.
4.
v
If the installation is complete but it does not start, the data source might not be
defined. Review the
install_dir
\cnps\kfwras1.log
file. If error messages
similar to the following are present in the log, the data source was not
defined:
[IBM][ODBC Driver Manager] Data source name not found and no
default driver specified.
Use the follow steps to verify whether the data
source was created and to resolve the problem:
1.
Open the ODBC datasource window:
Start
>
Settings
>
Control Panel
>
Administrative tools
and double-click the
Data Sources
(ODBC) .
2.
Verify that the IBM DB2 ODBC DRIVER datasource is defined.
3.
If the IBM DB2 ODBC DRIVER data source is not present, run the
install_dir
\installITM\DB2DataSource.exe
file.
4.
Read the error messages after running the program.
5.
If the error is security related or mentions incorrect user IDs or passwords,
log in to the Windows server with the
db2admin
user account and run the
db2datasource
program.
v
If the password for
db2admin
changes, the logon information for the services
must also change, otherwise the database does not start because the DB2
processes cannot logon. Use the following steps to resolve this problem:
Chapter 13. Database troubleshooting
225