IBM DB2 for i: Troubleshooting Database Transfer | HCL Digital Experience

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.

Tip: If you must go through the wizard again, download the wizard selections that you made to save time. Then, cancel the configuration. Start the process over and upload your saved selections. Correct or enter values for the parameters that caused the failure.

Back up the properties files that the wizard uses during the configuration

About this task: During this step, the wizard attempts to back up the wkplc.properties, wkplc_dbdomain.properties, and wkplc_dbtype.properties files.

Table 1. Appropriate actions for step: Back up the properties files that the wizard uses during the configurationIf you must run a configuration again, the table helps you determine what actions are appropriate.
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 users and groups

About this task:

During this step, you create the database configuration users and groups on the database server.

If you need a runtime user for day-to-day operations, you must create the runtime database users and groups on the database server.

Use the database user IDs and group names that are entered in the wizard when you create the database users and groups.

Table 2. Appropriate actions for step: Manual Step: Create the database users and groupsIf you must run a configuration again, the table helps you determine what actions are appropriate.
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 users and groups were not created correctly, you can repeat these instructions. For example, you might encounter a failure in the setup database step if the database users and groups are created incorrectly. You can repeat these instructions to correct the issue and then perform the setup database step again.
Skip the step	If you successfully created the database users and groups 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

Create your databases

Table 3. Appropriate actions for step: Create your databasesIf you must run a configuration again, the table helps you determine what actions are appropriate.
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.

Manual Step: Download the script and run it on the database server to create your database

During this step, you download a script to create your database.

Table 4. Appropriate actions for step: Manual Step: Download the script and run it on the database server to create your databaseIf you must run a configuration again, the table helps you determine what actions are appropriate.
Actions	Notes
Run the step again	You cannot rerun a manual step, but you can perform the instructions for the step again without harm. In this step, you download a script to run. The type of failure you encounter determines whether you can run the script 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	Not applicable

Set up your database

Use the ERRORCODE and SQLSTATE associated with the error message in the ConfigTrace.log to determine the source of the problem.

Table 5. Appropriate actions for step: Set up your databaseIf you must run a configuration again, the table helps you determine what actions are appropriate.
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, you must create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run. For example, if you entered the wrong path to your database library, you must upload your saved selections, correct the path, and then configure your system with new scripts.
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

Manual Step: Download the script and run it on the database server to set up your database

During this step, you set permissions on your database.

Table 6. Appropriate actions for step: Manual Step: Download the script and run it on the database server to set up your databaseIf you must run a configuration again, the table helps you determine what actions are appropriate.
Actions	Notes
Run the step again	You cannot rerun a manual step, but you can perform the instructions for the step again without harm. In this step, you download a script to run. The type of failure you encounter determines whether you can run the script 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 downloaded script again if the issue for the failure does not affect any values that you entered in the wizard. For example, if you created database users and groups incorrectly on your database server, you can correct the issue and run the step again. If you need to update values, you must create new scripts in the wizard. Upload your saved selections, change the affected values, and create new scripts to run.
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

Manual Step: Set up JCR collation for correct language locale order

Table 7. Appropriate actions for step: Manual Step: Set up JCR collation for correct language locale orderIf you must run a configuration again, the table helps you determine what actions are appropriate.
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	You must remove the database and create the database again.

Manual Step: Restart the DB2® server

During this step, you set global database default values that are required for the database that you created. These global values do not take effect until you restart your database server.

Table 8. Appropriate actions for step: Manual Step: Restart the DB2® serverIf you must run a configuration again, the table helps you determine what actions are appropriate.
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. If you already restarted your database server, you can skip this step.
Clean up step	None required

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.

Table 9. Appropriate actions for step: Validate the database connection and environmentIf you must run a configuration again, the table helps you determine what actions are appropriate.
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

Table 10. Appropriate actions for step: Stop the portal serverIf you must run a configuration again, the table helps you determine what actions are appropriate.
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

Table 11. Appropriate actions for step: Transfer the databaseIf you must run a configuration again, the table helps you determine what actions are appropriate.
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

Table 12. Appropriate actions for step: Grant privileges to the database runtime usersIf you must run a configuration again, the table helps you determine what actions are appropriate.
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

Manual Step: Download the script and run it on the database server to grant privileges to the runtime user

Table 13. Appropriate actions for step: Manual Step: Download the script and run it on the database server to grant privileges to the runtime userIf you must run a configuration again, the table helps you determine what actions are appropriate.
Actions	Notes
Run the step again	You cannot rerun a manual step, but you can perform the instructions for the step again without harm. In this step, you download a script to run. The type of failure you encounter determines whether you can run the script again. You can run the downloaded script again if the issue for the failure does not affect any values that you entered in the wizard. For example, if you created runtime users and groups incorrectly on your database server, you can correct the issue and run the script again. 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

Configure the JCR domain to support large files

Table 14. Appropriate actions for step: Configure the JCR domain to support large filesIf you must run a configuration again, the table helps you determine what actions are appropriate.
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

Start the portal server

Table 15. Appropriate actions for step: Start the portal serverIf you must run a configuration again, the table helps you determine what actions are appropriate.
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