DB2 for z/OS: Database transfer
Your portal is installed with an Apache Derby database. The database that is immediately available for use is good for demonstration and portlet and theme development environments. Otherwise, you must configure portal to use a production-level database. Use the Configuration Wizard to transfer the data and configure a new database server.
Configuration Wizard
The primary Configuration Wizard options are based on your target configuration topology, such as a stand-alone server or a cluster. The database transfer option is included with both Set Up a Stand-alone Server and Set Up a Cluster. For the stand-alone server topology, run the database transfer option before you run the federated security option. For the cluster option, run the database transfer before you create your deployment manager profile.
Validation
Prevent a possible database transfer failure by validating your entries in the wizard. When you chose to validate settings for the Database Transfer option, field syntax and database connection validations are performed to prevent a possible failure before you run the configuration.
Syntax validation checks that you:
- Enter a valid port number in the range of 1 - 65535.
- Use the correct format for your host name.
The database connection validation checks that a connection can be made to your database server. The wizard can connect to your database server to validate the host name and port number values that you enter.
On the Database Settings panel, you can choose to turn validation on or off by selecting Yes or No to the Connect to database server to validate settings option. Select No, if you know that your parameters are correct and your database server is unavailable at the time of creating your instructions.
Transferring data to a different database server
Depending on your environment, the wizard generates a configuration process. The following steps reflect all possible steps in the configuration process. The steps do not represent a literal configuration. The steps are provided as a reference.
If you click View Step Command, you can see the task and properties associated with each step in the wizard.
- Back up the properties files that the wizard uses during the
configuration.
- Condition
- None
- ConfigEngine task
- backup-property-files-for-dbxfer
- Manual Step: Create the database users and
groups.
- Condition
- None
- ConfigEngine task
- None
- Manual Step: Create the database
configuration users on DB2® for z/OS®.
- Condition
- None
- ConfigEngine task
- None
- Manual Step: Download the script and
view instructions to delete existing databases.
- Condition
- None
- ConfigEngine task
- None
- Manual Step: Download the script and
view instructions to create your databases.
- Condition
- None
- ConfigEngine task
- None
- Validate the database connection and environment.
- Condition
- None
- ConfigEngine task
- validate-database validate-database-environment
- Stop the portal server.
- Condition
- collation support
- ConfigEngine task
- stop-portal-server
- Transfer the database.
- Condition
- None
- ConfigEngine task
- database-transfer enable-profiles-check-managed package-profiles
- Grant privileges to the database runtime
users.
- Condition
- None
- ConfigEngine task
- grant-runtime-db-user-privileges
- Connect to your databases.
- Condition
- None
- ConfigEngine task
- None
- Manual Step: Download the script and
view instructions to reset the check pending status on portal table spaces.
- Condition
- None
- ConfigEngine task
- None
- Reset the web content manager
event log.
- Condition
- None
- ConfigEngine task
- None
- Start the portal server.
- Condition
- None
- ConfigEngine task
- start-portal-server
What to do next
You transferred your data from Apache Derby to your preferred database.
One quick way to test your database configuration is to log in and explore the site to validate the site is working as you expected.
Go to http://host_name:port/context_root/default_portal_home. For example, go to http://host_name:10039/wps/portal.
Next, you can use other options to configure your environment more.If you are setting up a stand-alone server environment, you can use the Enable Federated Security option to add an LDAP user registry.
If you are setting up a cluster environment, you can use the Create a Deployment Manager option to create a deployment manager profile that is augmented with WebSphere® Portal resources.