IBM BS029ML Self Help Guide - Page 83

What is about to happen

Page 83 highlights

Table 3-1 Database Transfer Preparation Checklist Step Task 1 Install, configure, and tune your database management system. 2 Assign an ID or privilege that will be used by WebSphere Portal Server(s) for system to system communications from the portal to the database. 3 Create the WebSphere Portal database(s) on the database server. 4 If you are using the Type 4 JDBC driver, copy the required files from your database server to your WebSphere Portal Server(s). 5 If you are using the Type 2 JDBC driver, install the database client on the WebSphere Portal Server(s). 6 Make a file system backup of WebSphere Portal Server. 7 Make a secondary backup of wpconfig_properties, wpconfig_dbdomain.properties, and wpconfig_dbtype.properties. 8 Enter database values in wpconfig.properties, wpconfig_dbdomain.properties, and wpconfig_dbtype.properties. 9 Validate the database configuration by running the Validate database connection tasks. 10 Check the InfoCenter to reconfirm that you have met all the prerequisites for hardware, software, and configuration for your database server and client. 11 Problem Avoidance: Use the IBM Support Assistant to perform a search on "database transfer and WebSphere Portal V6" to review all TechNotes and solutions associated with this task. 12 Stop all WebSphere Portal Server(s): In a clustered environment, verify the Deployment Manager is started and all node agents are running and synchronized. Completed † † 3.2.3 What is about to happen We recommend that you perform the database transfer before you use WebSphere Portal extensively if you choose to transfer data to another supported database, since large amounts of data in the databases can cause the database transfer to fail if your Java heap size is not large enough. Since data is added to the database as you use WebSphere Portal, you should perform the database transfer as soon as it is practical to do so to avoid problems due to the amount of data you are transferring. You can transfer data from any supported database type to any other supported database type, which means the source database does not have to be the default database that is created during installation. In order to transfer data between supported databases, you must edit the wpconfig_sourceDb.properties file and update it with the source databases' information. This file is a copy of wpconfig_dbdomain.properties that is created automatically during installation. Chapter 3. WebSphere Portal installation 69

  • 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

Chapter 3. WebSphere Portal installation
69
Table 3-1
Database Transfer Preparation Checklist
3.2.3
What is about to happen
We recommend that you perform the database transfer before you use WebSphere Portal
extensively if you choose to transfer data to another supported database, since large
amounts of data in the databases can cause the database transfer to fail if your Java heap
size is not large enough. Since data is added to the database as you use WebSphere Portal,
you should perform the database transfer as soon as it is practical to do so to avoid problems
due to the amount of data you are transferring.
You can transfer data from any supported database type to any other supported database
type, which means the source database does not have to be the default database that is
created during installation. In order to transfer data between supported databases, you must
edit the wpconfig_sourceDb.properties file and update it with the source databases’
information. This file is a copy of wpconfig_dbdomain.properties that is created automatically
during installation.
Step
Task
Completed
1
Install, configure, and tune your database management system.
2
Assign an ID or privilege that will be used by WebSphere Portal Server(s)
for system to system communications from the portal to the database.
3
Create the WebSphere Portal database(s) on the database server.
4
If you are using the Type 4 JDBC driver, copy the required files from your
database server to your WebSphere Portal Server(s).
5
If you are using the Type 2 JDBC driver, install the database client on the
WebSphere Portal Server(s).
6
Make a file system backup of WebSphere Portal Server.
7
Make a secondary backup of wpconfig_properties,
wpconfig_dbdomain.properties, and wpconfig_dbtype.properties.
8
Enter database values in wpconfig.properties,
wpconfig_dbdomain.properties, and wpconfig_dbtype.properties.
9
Validate the database configuration by running the Validate database
connection tasks.
10
Check the InfoCenter to reconfirm that you have met all the prerequisites
for hardware, software, and configuration for your database server and
client.
11
Problem Avoidance: Use the IBM Support Assistant to perform a search on
“database transfer and WebSphere Portal V6” to review all TechNotes and
solutions associated with this task.
12
Stop all WebSphere Portal Server(s): In a clustered environment, verify the
Deployment Manager is started and all node agents are running and
synchronized.