Posted: Mon Apr 27, 2009 2:36 am
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.
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.