IBM DB2 for i: Troubleshooting Database Transfer
If you encounter a failure during the configuration process, determine whether you can run the step again, skip the step, or if you must clean up the step. For some failed steps, learn how to correct the issue and recover from the failure.
Each potential step in the configuration is included. Because the steps vary depending on your selections, the steps are not numbered. Find the step that failed to learn more about correcting and recovering from the failure. If you need to change a value that you entered in the wizard, then you must run the configuration again.
Back up the properties files that the wizard uses during the configuration
Actions | Notes |
---|---|
Run the step again | You can run the step again without causing any harm. Alternatively, you can manually back up the properties files instead of running the step again. |
Skip the step | If
you already backed up your properties files before you started this configuration, you can skip this
step. If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required |
Manual Step: Create the database user profile on IBM® DB2® for i
Actions | Notes |
---|---|
Run the step again | You cannot rerun a manual step, but you can perform the
instructions for the step again without harm. If you realize in the configuration that the database user profile was not created correctly, you can repeat these instructions. |
Skip the step | If you successfully created the database user profile before you started this configuration, you can skip this step.If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required |
Manual Step: Create the database runtime users and groups
Actions | Notes |
---|---|
Run the step again | You cannot rerun a manual step, but you can perform the
instructions for the step again without harm. If you realize later in the configuration that the database runtime user was not created correctly, you can repeat these instructions. For example, you might encounter a failure when you set up your database if the database runtime user is created incorrectly. You can repeat these instructions to correct the issue. Then, you can repeat the setup database step again. |
Skip the step | If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required |
Create your databases
Actions | Notes |
---|---|
Run the step again | The type of failure that you encounter determines whether you can run the
step again. Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the reason for the failure. You can run the step again if the reason for the failure does not affect any values that you entered in the wizard. For example, if you forgot to copy the JDBC JAR files from your database to the portal server, you can copy the files to the portal server. Then, you can run the step again. If you need to update wizard values to correct the issue, do not run the step again. You must create new scripts in the wizard. Upload your saved selections, update your values, and create scripts. Examples of issues that result in you updating your values include entering the wrong port number or entering an incorrect host name into the wizard. |
Skip the step | If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required. If the step fails because you entered incorrect values in the wizard, remove the database manually, enter correct values to create your scripts, then run the configuration again. |
Validate the database connection and environment
During this step, you are validating that the database is still available and that you can successfully connect to the database.
Actions | Notes |
---|---|
Run the step again | You cannot rerun a manual step, but you can perform the instructions for the step again without harm. |
Skip the step | If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required |
Stop the portal server
Actions | Notes |
---|---|
Run the step again | You can run the step again without causing any harm. |
Skip the step | If you already stopped the portal server, you can skip this step. |
Clean up step | None required |
Transfer the database
Actions | Notes |
---|---|
Run the step again | The type of failure that you encounter determines whether you can run the
step again. Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the reason for the failure. You might have a portal failure that does not have a SQLSTATE error code that is associated with the error message. You can run the step again if the issue for the failure does not affect any values that you entered in the wizard. If you need to update values in the wizard, you must create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. You do not need to run previous successful steps. |
Skip the step | If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required |
Grant privileges to the database runtime users
Actions | Notes |
---|---|
Run the step again | The type of failure that you encounter determines whether you can run the
step again. You can run the step again if the issue for the failure does not affect any values that you entered in the wizard. If you need to update values in the wizard, you must create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. You do not need to run previous successful steps. |
Skip the step | If this step is successful, you can skip it if you encounter a failure in a later step and need to run the configuration again. |
Clean up step | None required |
Start the portal server
Actions | Notes |
---|---|
Run the step again | You can run the step again without causing any harm |
Skip the step | If you already started the portal server, you can skip this step. |
Clean up step | None required |