Oracle
XA prohibits required schema operations in a global transaction environment and
does not support local transactions. If you have schedulers that use an Oracle
XA data source, either temporarily change the scheduler configuration to use
a non-XA Oracle data source, or create the tables manually using the supplied
DDL files. If you use the administrative console to create or drop scheduler
tables for a scheduler configured to use an Oracle XA data source, then you
receive a SchedulerDataStoreException error message, and the operation fails.
Note: Limitations for DB2 z/OS databases
DB2 z/OS databases do
not support creating and dropping tables through the administrative console.
A database administrator is typically involved with defining and managing
databases on DB2 z/OS systems. The administration interface is targeted for
the non-database administrator or developer who does not want to know the
specifics of setting up the scheduler database. The scheduler has DDL files
available for the database administrator to create the required tables.