IBM E027SLL-H Troubleshooting Guide - Page 241
Database troubleshooting
![]() |
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 241 highlights
Chapter 13. Database troubleshooting Review the common problems and resolutions to prevent data loss and solve problems with the Tivoli Data Warehouse and Warehouse agents. Data loss prevention This section provides information about utilities you can use to back up and restore Tivoli Enterprise Portal Server databases. Backing up the database for recovery purposes You can use the following utilities to back up the database: Table 18. Utilities for backing up the database migrateexport.bat migrateimport.bat The migrate-export.bat utility backs up the entire database by writing its contents as insert statements to a flat file called saveexport.sql located in install_dir\cnps\sqllib. It can also be used to move the contents of the database from one database instance to another. You might use this utility to move the contents of the database from one windows server to another. This utility is used to read the contents of the saveexport .sql file created in the migrate-export process and insert them back into the database. This utility can be used to recover the database. It reads the contents in the install_dir\cnps\sqllib\saveexport.sql and rebuilds the database tables and contents. You can also use the migrate-import.bat to move the contents of the database to another windows server running the database. 1. Run migrate-export.bat. 2. Copy the saveexport.sql file from the old Tivoli Enterprise Portal Server to the new portal server into the install_dir\cnps\sqllib directory. 3. Run migrate-import.bat to read and build the database tables and contents on the new system. Restoring the original database contents The migrate-clean.bat utility cleans the contents of the database. Use the migrate-clean.bat file with caution. You must backup the database before running the migrate-clean.bat file or you lose all customization of the database. When you restart the Tivoli Enterprise Portal Server, the database is restored to its original state after installation. This is a quick way to reset the database back to its original state. After running this bat file and restarting the Tivoli Enterprise Monitoring Server, the original content provided with Tivoli Monitoring is restored to the database. If you modify your password or if it expires The database requires the following user IDs: db2admin This ID is added when you install the database and is required by the product installer when you configure the Tivoli Enterprise Portal Server data source. TEPS This ID is added during installation for creating the portal server data source. © Copyright IBM Corp. 2005, 2012 223
-
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/241.png)