DSXchange

I had this - tried to work around it, with little joy. Permissions fine on all the relevant directories etc.

In the end, I had to delete (manually) and recreate the dataset, at which point the error ceased. I think it was a corrupted pointer.

Thanks both for the pointers.

Regards,
S

Hi folks, Is it possible to set up a Linux installation to have specific priorities for individual users. For example, all jobs submitted by dsadm will have higher priority by default than those submitted by fbloggs? I know about nice/renice, but those rely on entering manual commands (and on knowin...

Thanks ArndW. I tried that but its prompting with error 'Status code = -2 DSJE_BADSTATE Error running job" Does the command resets all the jobs called from the sequence jobs along with the main sequence job? below is the script I am using. -------------------------------------------------------...

Hi All, I have a scheduled data stage job run via below script on daily basis. #! /usr/bin/sh dshome=`cat /.dshome`; export dshome PATH=$PATH:$dshome/bin; export PATH . $dshome/dsenv dsjob -run -param source_file=$1 Test_Project Seq_job.$2 Some times the job gets aborted due to avoidable issues like...

Thanks a lot ArndW.
The script worked fine after changing PATH=$PATH:$dshome/lib; to PATH=$PATH:$dshome/bin;

Regards,
Sj.

Thanks a lot ArndW.
The script worked fine after changing PATH=$PATH:$dshome/lib; to PATH=$PATH:$dshome/bin;

Regards,
Sj.

Hi All, I am trying to run a Version 8 parallel job from unix script. Below is the script I am using. --------------------------------------------------------------------- #! /usr/bin/sh dshome=`cat /.dshome`; export dshome PATH=$PATH:$dshome/lib; export PATH . $dshome/dsenv dsjob -run -param source...

Perfect, thanks.

Thanks Craig.

I'm not aware of a deadlock daemon, and so will have a chat with the unix admin to see if we can get anything put in place.

Thanks again for your time, much appreciated.

Thanks Craig. I will definately push those suggestions forward.

I know that it is impossible to make accurate diagnosis without looking at the server yourself, but do you think that the general slowing down of the server could be attributable to these disconnects?

Thanks again.

Thanks for your reply.

They log into directly to the server. They have also complained that at times it is taking 5 mins+ to refresh logs in Director, so the network speed transferring data from client to server might be slow.

Inactivity timeout is set to 'Do not timeout'

Thanks,
S

Hi, The error message is received when attempting to import a table definition from the DB: DSR.MetaGeta(GET.TABLES)(SQLConnect('PREQDB','pesdi')): BCI Error: SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not r...

Hi All, We are running an instance of DataStage 7.5 on a Linux box with 4 CPUs. The box is accessed both locally in the UK, and by a team in India. Since the team in India came on line, the performance of the box seems to have degraded badly. The slow down happens over a couple of days, and can norm...

Same here, with three nodes. Sounds like your tnsnames entry isn't correct... not wrong, just not correct for DataStage it seems. Ask your DBA to 'fix' it for you. I am pasting an extract of the TNS entries created by our DBA, along with his notes: " We can use any one of the following TNS ent...