Welcome
IBM® Workload Scheduler
Welcome to the IBM® Workload Scheduler documentation, where you can find information about how to install, maintain, and use IBM Workload Scheduler. The documentation has been updated for IBM Workload Scheduler Version 10.2.3.
Troubleshooting
Troubleshooting Dynamic Workload Console
Describes how to troubleshoot problems with the Dynamic Workload Console related to connections, performance, user access, reports, and others.
Troubleshooting problems with database
Import settings to DB2 repository fails

Product requirements
This section contains links to the IBM® Workload Scheduler Download Documents, System Requirements, and Release Notes.
Product Library in PDF format
This section contains links to the PDF versions of all the publications provided in IBM Documentation for IBM Workload Automation.
Considerations for GDPR readiness
Overview
Mobile Applications Userʼs Guide
Dynamic Workload Console User's Guide
AI Data Advisor (AIDA) User's Guide
Scheduling Job Integrations with IBM Workload Automation
IBM® Workload Scheduler
Welcome to the IBM® Workload Scheduler documentation, where you can find information about how to install, maintain, and use IBM Workload Scheduler. The documentation has been updated for IBM Workload Scheduler Version 10.2.3.
- Quick Start Guide
- Planning and Installation
- User's Guide and Reference
- Administration Guide
- Scheduling with the Agent for z/OS
- Database Views
- High Availability Cluster Environment
- Troubleshooting
  - Getting started
    Gives an overview of what troubleshooting information is contained in this publication, and where to find troubleshooting information which is not included.
  - Logs and traces
    Provides detailed information about logs and traces, and how to customize them and set the logging and tracing levels.
  - Capturing product data
    Describes the facilities available for data capture in the event of problems occurring. It provides full details of the Data capture utility and the provisions for first failure data capture.
  - Troubleshooting performance
    This refers you to the Administration Guide for the resolution of performance problems.
  - Troubleshooting networks
    Describes how to recover from short-term and long-term network outages and offers solutions to a series of network problems.
  - Troubleshooting engine problems
    Gives solutions to problems that might occur with the modules and programs that comprise the basic scheduling "engine" on the master domain manager.
  - Troubleshooting dynamic workload scheduling
    This section provides information that is useful in identifying and resolving problems with dynamic workload scheduling, including how to tune the job processing rate and how to solve common dynamic scheduling problems.
  - Troubleshooting when automatically adding dynamic agent workstations to the plan
    This section provides information that is useful in identifying and resolving problems in the IBM Workload Scheduler environment when you enable the automatic adding of dynamic agent workstations to the plan.
  - Troubleshooting Dynamic Workload Console
    Describes how to troubleshoot problems with the Dynamic Workload Console related to connections, performance, user access, reports, and others.
  - Troubleshooting workload service assurance
    Gives you troubleshooting information about workload service assurance by explaining how it works and how it exchanges information between the modules. In addition, it provides solutions to common problems.
  - Troubleshooting switch manager
    Provides troubleshooting information about the fault-tolerant switch manager in terms of the event counter, the Ftbox, and link problems. It also provides solutions to some common problems with the backup domain manager.
  - Synchronizing the database with the Symphony file
  - Corrupt Symphony recovery
    Explains the symptoms of Symphony file corruption and links you to tasks that can recover the file on the master domain manager, fault-tolerant agent, or lower domain manager.
  - Support information
  - Date and time format reference - strftime
- Driving IBM Workload Automation
- Extending IBM Workload Automation
IBM® Z Workload Scheduler
Welcome to the IBM® Z Workload Scheduler documentation, where you can find information about how to install, maintain, and use the product.
Messages and Codes
Glossary
Notices

Import preferences fails

When trying to import your settings repository from the XML file by specifying the Cancel and recreate option, the import operation fails and you receive the following message: AWSUI0924E Preferences import operation failed: Unable to create database. Moreover, the following error is logged in the SystemErr.log file: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: TDWC.TDWC_PREFERENCEABLE;TABLE.

Cause and solution:

This might occur because the database user with administrative authority specified to import the settings does not have the privileges required to drop the existing Dynamic Workload Console tables that were created with Dynamic Workload Console V8.6.0.0.

To solve this problem, provide the specified user with CONTROL privilege on all Dynamic Workload Console tables.

For example,

db2 "GRANT CONTROL ON TABLE TDWC.TDWC_CONFIGURATIONPROPERTY TO USER myuser"
	db2 "GRANT CONTROL ON TABLE TDWC.TDWC_CREDENTIAL TO USER myuser"
	db2 "GRANT CONTROL ON TABLE TDWC.TDWC_ENGINECONNECTION TO USER myuser"
	db2 "GRANT CONTROL ON TABLE TDWC.TDWC_MEQUERYTASK TO USER myuser"
	db2 "GRANT CONTROL ON TABLE TDWC.TDWC_PREFERENCEABLE TO USER myuser"
	db2 "GRANT CONTROL ON TABLE TDWC.TDWC_QUERYTASK TO USER myuser"
	db2 "GRANT CONTROL ON TABLE TDWC.TDWC_REPORTTASK TO USER myuser"