AIX clustered server: Verify IBM DB2 for i database connections
Prerequisites
AIX clustered server: Modify IBM DB2 for i database properties
AIX clustered server: Create IBM DB2 for i user profiles
AIX stand-alone server: Set up IBM DB2 for i databases automatically
AIX clustered server: Transfer IBM DB2 for i manuallyYou can verify the connection from a browser or from a command line.
To verify that WebSphere Portal is running from a browser, open the portal in a Web browser: http://hostname.yourco.com:port_number/wps/portal
There may be an error if any of the following conditions appear.
Verify the connection from a command line:
- When trying to access the portal you get a 503 error.
- If you had any locale problems with database, you could see invalid characters, such as ????, after logging in. This may happen if the character set of the database is not UTF-8 compliant.
- If something went wrong with the data that was transferred, you may not be able to login. WebSphere Portal will indicate you entered an invalid user ID and password even though you know it is valid.
- Open a command line on the local machine whereWebSphere Portal is installed.
- For WebSphere Portal on WAS (UserData path):
cd WP_PROFILE/ConfigEngine
- Enter the following command:
ConfigEngine.sh validate-database-connection -DTransferDomainList=release,community,customization,jcr,feedback,likeminds -DWasPassword=foo
You can specify the password on the command line rather than update wkplc_dbdomain.properties. For example:
ConfigEngine.sh -DPortalAdminPwd=foo -DWasPassword=foo validate-database
When installing WebSphere Portal, the passwords in wkplc_dbdomain.properties are automatically removed after configuration.
Parent
AIX clustered server: Set up a remote IBM DB2 for i
Previous
AIX clustered server: Transfer IBM DB2 for i manually