IBM BS029ML Self Help Guide - Page 82

before, all node agents should be running and synchronized

Page 82 highlights

4. If you are connecting to an external database remotely, create the database(s) you plan to utilize as instructed in the InfoCenter instructions. Users of DB2 have the convenience of having WebSphere Portal Server create the databases locally by running ./WPSconfig.sh/WPSconfig.bat create-local-database-db2 from the command line. 5. WebSphere Portal Server V6 allows for the use of the Type 4 JDBC™ driver for all supported databases, eliminating the need to install a local database client on the WebSphere Portal Server for those distributed environments. Before you begin the database transfer process, copy the required Type 4 jar file(s) for your database management system server over to your WebSphere Portal Server(s). Should you choose to have the local client installed for remote connection (required for supported platforms in which will use the Type 2 JDBC driver), you should install the database client on all WebSphere Portal Servers beforehand. Catalog the databases on the WebSphere Portal machine. Note that this is not required for those environments in which the database server will be installed locally. For more information about driver support, refer to "Supported hardware and software" on page 56. 6. For most platforms, you have the option of transferring the database manually using the command line, or transferring the database using the configuration wizard. Regardless of the process you choose, you will need to modify the wpconfig_dbdomain.properties, wpconfig_dbtype.properties, and wpconfig.properties with the values required in order to perform the database transfer, as both methods will pull the information from these files. Do not provide values for other parameters in the properties files other than those specified in the InfoCenter instructions. Note: If you are planning to use the optional LookAside feature in your portal implementation, do not set this value during the database transfer process. This value is set as a part of enabling security. 7. Verify the database connections from WebSphere Portal Server to your database(s) by running the validate database connection configuration tasks for the individual domains you will be transferring to your external database. If you receive failures, do not continue with the additional steps until the tasks run successfully. 8. Check the InfoCenter to re-confirm that you have followed all instructions for your Database Management system, including any system requirements or other modifications necessary for your database management system. You can access the InfoCenter at: http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index.jsp 9. Using support tools before you run installation and configuration tasks are another effective method of problem avoidance. By utilizing a tool such as IBM Support Assistant you can perform a search for "database transfer with WebSphere Portal Version 6" and review all TechNotes surrounding this topic. Refer to Appendix A, "Using IBM tools to find solutions and promote customer self-help" on page 169 for more information. 10.Stop WebSphere Portal Server if it is running. In a clustered environment, Deployment Manager and all node agents should be running and synchronized. Table 3-1 on page 69 gives you a checklist of all the required items for the database transfers preparation. 68 IBM WebSphere Portal V6 Self Help 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

68
IBM WebSphere Portal V6 Self Help Guide
4.
If you are connecting to an external database remotely, create the database(s) you plan to
utilize as instructed in the InfoCenter instructions. Users of DB2 have the convenience of
having WebSphere Portal Server create the databases locally by running
.
/WPSconfig.sh/WPSconfig.bat create-local-database-db2
from the command line.
5.
WebSphere Portal Server V6 allows for the use of the Type 4 JDBC™ driver for all
supported databases, eliminating the need to install a local database client on the
WebSphere Portal Server for those distributed environments. Before you begin the
database transfer process, copy the required Type 4 jar file(s) for your database
management system server over to your WebSphere Portal Server(s). Should you choose
to have the local client installed for remote connection (required for supported platforms in
which will use the Type 2 JDBC driver), you should install the database client on all
WebSphere Portal Servers beforehand. Catalog the databases on the WebSphere Portal
machine. Note that this is not required for those environments in which the database
server will be installed locally. For more information about driver support, refer to
“Supported hardware and software” on page 56.
6.
For most platforms, you have the option of transferring the database manually using the
command line, or transferring the database using the configuration wizard. Regardless of
the process you choose, you will need to modify the wpconfig_dbdomain.properties,
wpconfig_dbtype.properties, and wpconfig.properties with the values required in order to
perform the database transfer, as both methods will pull the information from these files.
Do not provide values for other parameters in the properties files other than those
specified in the InfoCenter instructions.
7.
Verify the database connections from WebSphere Portal Server to your database(s) by
running the validate database connection configuration tasks for the individual domains
you will be transferring to your external database. If you receive failures, do not continue
with the additional steps until the tasks run successfully.
8.
Check the InfoCenter to re-confirm that you have followed all instructions for your
Database Management system, including any system requirements or other modifications
necessary for your database management system. You can access the InfoCenter at:
9.
Using support tools
before
you run installation and configuration tasks are another
effective method of problem avoidance. By utilizing a tool such as IBM Support Assistant
you can perform a search for “database transfer with WebSphere Portal Version 6” and
review all TechNotes surrounding this topic. Refer to Appendix A, “Using IBM tools to find
solutions and promote customer self-help” on page 169 for more information.
10.Stop WebSphere Portal Server if it is running. In a clustered environment, Deployment
Manager and
all node agents should be running and synchronized
.
Table 3-1 on page 69 gives you a checklist of all the required items for the database transfers
preparation.
Note:
If you are planning to use the optional LookAside feature in your portal
implementation, do not set this value during the database transfer process. This value is
set as a part of enabling security.