Windows: C:\IBM\InformationServer\ASBServer\bin\AppServerAdmin.bat -db -user -password Start WebSphere Application server as root cd /opt/IBM/WebSphere/AppServer/bin ./startSever.sh server1
To complete the updates to the ISF configuration, run the AppServerAdmin.sh command to update the XMeta username and password. The command can be found in the InformationServer/ASBServer/bin directory. Replace the with your XMeta Database username and the with the correct password. Once the AppServerAdmin command has run successfully, as root, restart WebSphere. cd to the WebSphere/AppServer/bin directory and type ./startServer.sh server1.
Update WebSphere Application Server configuration (1 of 6)
Update WebSphere Application Server configuration (1 of 6) Login to WebSphere Application Sever Administrative console https://:9043/ibm/console
Login to the WebSphere Application Server Administrative Console. Click the Resources tab on the left side and then click JDBC Providers underneath. In the middle of the screen, select the server : server1 radio button, and click Apply. Next click ASB JDBC Provider link in the box below the Apply button.
Update WebSphere Application Server configuration (2 of 6)
Update WebSphere Application Server configuration (2 of 6)
In the ASB JDBC Provider window, click Data sources under Additional Properties on the right side of the screen.
Update WebSphere Application Server configuration (3 of 6)
Update WebSphere Application Server configuration (3 of 6) Open each data Source listed and perform steps listed
You may have more than one data source listed. Perform the steps described on each data source in the list. Click the link for the data source to be modified.
Update WebSphere Application Server configuration (4 of 6)
Update WebSphere Application Server configuration (4 of 6) Modify connection properties – DB2
For XMeta on DB2, scroll to the bottom of the screen for the data source and modify the connection properties as required. Click Apply.
Update WebSphere Application Server configuration (5 of 6)
Update WebSphere Application Server configuration (5 of 6) Modify connection properties – Oracle and SQL Server
For XMeta on Oracle and SQL Server, on the Configuration tab, click Custom Properties on the right side under the Additional Properties heading. Once in Custom Properties, click the settings that have changed and set them to the appropriate values. Click Apply.
Update WebSphere Application Server configuration (6 of 6)
Update WebSphere Application Server configuration (6 of 6)
In the Messages box at the top of the page click Save to save to the master configuration. Next, click the Save button in the next page.
Test connection
Test connection Test connection Stop and restart WebSphere
Once the changes have been saved, test your new connection by clicking the Test connection button at the top of the Data Sources page where you made the server changes. If the connection is successful, you will see a message at the top of the screen indicating success. If it is unsuccessful, go back and check the modified data source settings. Once the test completes successfully, go back and modify the remaining data sources in the same manor. After all changes have been made, saved, and successfully tested, stop and restart WebSphere.
Feedback
Feedback Your feedback is valuable You can help improve the quality of IBM Education Assistant content to better meet your needs by providing feedback. Did you find this module useful? Did it help you solve a problem or answer a question? Do you have suggestions for improvements? Click to send email feedback: mailto:iea@us.ibm.com?subject=Feedback_about_XmetaRepository.ppt This module is also available in PDF format at: ../XmetaRepository.pdf
You can help improve the quality of IBM Education Assistant content by providing feedback.
Trademarks