DSXchange

Hi Arnd, Yes [-fix] was included, i have run fix again and this is the ouput from the LIST command: >LIST UV_SCHEMA ID.SUP WITH EVAL '@RECORD' LIKE ..UnkownString... @RECORD 0 records listed. ---------------- and this is the output for: >LIST UV_SCHEMA 0 records listed. Still we are not aple to crea...

Hello Arnd, Ray we have ran the command and this is the output: LIST UV_SCHEMA ID.SUP WITH EVAL '@RECORD' LIKE ..UnkownString... @RECORD LIST UV_SCHEMA ID.SUP WITH EVAL "@RECORD" LIKE ..UnkownString... 13:50:14 06-24-09 PAGE 1 Read operation failure. Internal file corruption detected. File...

Hi;

Check the permissions for the "user name for scheduled jobs", who is assigned in:

administrator client --> project properties -- > schedule tab

Hello Ray, This is the output from running fixtool: $ fixtool -file /ascential/Ascential/DataStage/DSEngine/sql/catalog/UV_SCHEMA Filename: /ascential/Ascential/DataStage/DSEngine/sql/catalog/UV_SCHEMA Start Diagnostics. 0 Errors found in physical structure. 1 Errors found in file header. 3 Errors f...

Thank you Ray,

My colleague run a command suggested by you in one post:

SELECT NAME FROM UV_USERS WHERE DBAUTH = 'YES';

how can I check that UV_SCHEMA is corrupted or not? can you please advice.
[/quote]

Thanx Graig, and yes i did but all posts talking about Admin authintications or replace from backup;

for us we are loging by admin and we do not have any backup.


thank you again Graig

Hello guys; we have a problem started long time ago (2+ years), which is: We are unable to create any new project, and we are getting this error: "Error creating a schema Some users will not have access to this schema.", even though the user is DBA user. we do not have any backup for UV_SC...

thank you,

i will do that.

Note : our weekend is Thursday & Friday

Thank you very much ArndW, Ray for your help to resolve our problem, we have done the fix and we are able to COUNT DS_JOBOBJECTS and also able to export jobs (we can't before the fix). Only now we start taking full export for our project, after making sure every thing is fine i will update you and m...

thank you very much for your quick reply, we can close all Datastage sessions, but we have running jobs now, and they will take sometime, is OK to do the fix while we have running jobs?

we followed your valuable advise, and we got the following: >ED VOC /ascential/Ascential/DataStage/Projects/Project1/AW New record. ----: i 0001= F 0002= D_DS_JOBOBJECTS 0003= AW 0004= Bottom at line 3. ----: FILE "/ascential/Ascential/DataStage/Projects/Project1/AW" filed in file "VO...

Thank you again ArndW;

The fact that we still able to run jobs, so, we have some jobs running right now, because of this i asked about the exclusive access.
So, can i still proceed with your advice?

Thank you ArndW for your quick replay, do i have to have exclusive access to do this ? from the time you replied, aim waiting to get exclusive access, also, can you explain little bit those steps. " then 3 lines "F", "DSPLAY", "D_DS_JOBOBJECTS" then enter return ag...

if we take first option
a) DS job to read the DB and, if "Y", create a dummy file

how I can pass flag Y to anther job to start running or not ?????
what the benefit to crate dummy file ?

Dear All ,

we need to run sequence job depending on reading flag from database ,if flag Y then sequence job will start else job abort without running .How we can implement this work flow in DS. and every 15 minute check again this flag .