Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Incorrect schema migration scripts created or aborts if chose to run now.
Description
When trying to migrate databases with Toad for DB2 3.0.0. I can create scripts for the migration but cannot use the Execute Scripts Now option. If the option is used, it aborts out before script creation completes. If I choose to just create scripts and this will complete but with some errors. When reviewing the scripts he notices some incorrect settings/mappings.
In the migration wizard I have sets some Transformation rules, specifying 2 mapping changes during the migration, by adjusting the tablespace names it maps to in the target database and changing the schema names it maps to.
There are instances where SET SCHEMA = USERS@ and SET SCHEMA = DB2ADMIN@ commands sprinkled throughout the code, 2 just before each object, but why? And why is it set to USERS@ and DB2ADMIN@ when the migration should be setting to NEWUSER in the target database?
There are also instances where there are CREATE ALIAS statements that note for DB2ADMIN, instead of NEWUSER. But other create object statments do correctly notE the new target schema. Why does it seem to be inconsistant?
Sample from script: CREATE ALIAS PUBLIC.TCONTACT_CLIENT_HOLD FOR DB2ADMIN.TCONTACT_CLIENT_HOLD@
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.