DSR.ADMIN: Error creating a schema

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
adamski
Charter Member
Charter Member
Posts: 54
Joined: Thu Mar 20, 2003 5:02 pm

DSR.ADMIN: Error creating a schema

Post by adamski »

Hi All

Can anyone help out?

I get the below when I try to add a new project into the path where I have added previous ones successfully.

There apears to be plenty of disk space. I am logging in as dsadm, and I have permisisons.

Code: Select all

DSR.ADMIN: Error creating a schema Some users will not have access to this schema.
Read operation failure.  Internal file corruption detected.  File must be repaired.
Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It means that you have tried to create a schema while logged in as a user who does not have DBA privilege. Delete the project and start again, this time logged in with DBA privilege.

To find out which users have DBA privilege execute the following UniVerse command:

Code: Select all

SELECT NAME FROM UV_USERS WHERE DBAUTH = 'YES';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply