DSXchange

Hello, This week we have observed a strange query consuming a lot of CPU on our database (50% on 8-CPU database server) SELECT TABLE_NAME FROM ALL_TABLES WHERE ( TABLE_NAME = UPPER('DBA_EXTENTS' ) AND OWNER = UPPER('SYS') ) OR EXISTS (SELECT view_name FROM ALL_VIEWS WHERE ( VIEW_NAME = UPPER('DBA_EX...

If I were you I would get the original programmers bqck to fix it. Sounds like they are a bunch of cowboys :? We don't need cowboys because we don't have cows :roll: I'm glad to announce that we found the problem : APT_AUTO_TRANSPORT_BLOCK_SIZE was set to true. When we put it to it's default value ...

Thanks PaulVL and sarjushah,

I'll try to have a look on your tips on monday !

chulett wrote:Have you involved your official support provider yet?

Not yet,
We are in a phase that prevents us from reinstalling the DataStage project or the server, as they will probably ask us (or I may be a bit dishonest towards the offical support and its capability to analyse the problem)

Just once contact to your ADMIN team, as I can see the error as "DS_001,0: /bin/echo: write error: Broken pipe", I have faced same issue, and on contacting the DS-ADMIN (Server Team) our issue used to get resolved. So juat an suggestion, to contact the ADMIN team, mentioning the error mes...

May I ask for some more comments ?
I'm stuck with this problem and can't see any solutions ...

Show us the content of your APT file. I'd be interested to see if your datasegments path is a valid path on the server you are executing on. Also, do you have proper read/write authority to that path. Here is the content of the APT_CONFIG_FILE: cat /app/EQOPIGL/ISF/Projects/EQOPIGL1/EQOPIGL1_INIT/a...

check the enviorment in which you are reading it... since it partition it wont work on two different enviorment unless config file is same for both... i mean if you are reading dataset which created on 8-node config server to 4-node it won't work .... for that you should create new dataset on 4-nod...

R using the same dataset created in your Test Environment?? In fact I have a job sequence that runs the first job that creates the dataset using information from the flat file and then the second job that reads the dataset. The dataset is clearly corrupted on one of the server as even the orchadmin...

gssr wrote:The dataset was not properly loaded. Check the job that creates the Dataset

How come that the job works perfectly on another server ?

I already checked it multiple times and it doesn't differ from my other dataset creation

Sreenivasulu wrote:What is the meaning of 'weight 20K'

20 KBytes
It was to prevent the response "The file is too big"

Hello, I'm facing an odd problem and I need your enlightment: I've a job that fails to read a dataset with the following error: Event Id: 5834 Time : Wed Feb 16 18:03:24 2011 Type : FATAL User : ... Message : DS_001,0: Unable to map file /.../dataset/node1/DS_001.ds...0000.0000.0000.7080.cf254e0d.00...

Hello sambarand, I doubt there's much more to say but I can give you some details. The ganymed-ssh2 library (first result with google) is supplied with docs and examples. I used those docs and examples to build my java class. For the ssh command, I simply used the dsjob command with the good paramet...

Thanks both of you for your quick replies !

Finally I will use the job report, it's more usefull for documenting my jobs as I will also have the parameters and some other usefull information ;o)

Hello there, I'm making some documentations for my jobs and I'd like to add some job images to my document. I'd like to know if it's possible to get the images that DataStage shows us when hovering over the job list ? I think it would be more accurate than making screen capture, especially for the l...