IBM® Infosphere DataStage Server Edition

[ray.wurlod]

For starters please delete your duplicate post.

Second, try to be just a tad more imaginative in your choice of topic. This will aid future searchers.

UV_SCHEMA is the system table that records the existence, creator and location of DataStage/SQL schemas - in the main these are equivalent to DataStage projects, except that the CATALOG schema contains the system tables themselves.

UV_SCHEMA is affected only by creating and deleting DataStage projects. It can be re-synchronized with the actual project using a command called VERIFY.SQL, but this command can only be executed by a user to whom DBA privilege has been granted. This may be entirely separate from Information Server credentials and DataStage Administrator role.