Some common problems and issues can occur when you use
the Database Administration feature of IBM® Data
Studio.
Change command validation
If IBM Data
Studio
detects an error in the generated commands that are displayed in the
Review and Deploy catalog, the error is recorded in the Problems view.
Commands are not running when Kerberos authentication is used
When Secure Shell (SSH) protocol is used to access remote
database servers, the protocol relies on underlying RXA and RSE libraries.
Neither of these libraries support Kerberos authentication.
Finding data objects
Use Search to find data objects when you don't know
the physical data model in which the object is located.
Finding the DB2 instance name
Change commands that require the IBM Data
Server Client will request the DB2 instance
name.
Forward engineering
When you forward engineer changes, be sure to check the
DDL for objects that are derived from other objects, such as views,
materialized query tables, and aliases, to ensure that the correct
dependent objects are resolved
Turn off automatic key migration
If columns are being added to parent tables when you add
a new foreign key, turn automatic key migration off to eliminate this
behavior.