DSXchange

I tried the following that seems to work: rm file.ds; rm file2.ds I think the secret is that you need semi colon terminated lines, but each command needs to be on a new line. I tried a similar command file with same describe command seperated by a ; but it won't work. An alternateive is orchadmin `...

OK, please post the exact error message that orchadmin emits. Here is the output: ##I IIS-DSEE-TFCN-00001 09:48:11(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4665 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TCOA-00055 09:48:11(001) <main...

Why the semi-colon ? It is because the usage error text indicated to seperate commands by semi-colon. I tried with no semi-colon and ended up with the same invalid command and displayed command is an empty text. I tried orchadmin abc intentionally and the error message indicated abc is the invalid ...

I code a script to have orchadmin do things on data sets like list out schema using ls or describe -s command. I then changed the script to have orchadmin read in a command file using the orchadmin -f file-name and the command file has the exact describe -s /path/file.ds followed by a ;. I tested ru...

Hello novice,

The Administrator you are refering to is a person/role, Admin Client or http://server:9080/index.jsp and log in as 'dsadm'??\

I browsed thru' those panels and cannot any where I can adjust time zone.

Please note that our DSadm is novice also.

Thanks.

Tzu

Hello,

The date and time adopted by the DataStage is usually the Unix server system date time the DS server is sitting on.

I found the time is now 4 to 5 hours ahead of the Unix server system date time when I logged on this morning. What is the cause and how to fix it?

Regards,

Tzu

Aha! There's a patch from IBM for this very issue.

We're testing the DS upgrade to 8.0. Everything worked great in 7.5x. When attempting to run Teradata px stage in 8.0, I get the error Fatal Error: Fatal: Name is longer than 30 characters. This is a Teradata error indicating the table name is longer than 30 chars. What we believe is happening is th...

Sorry about the lack of information. I didn't mention the database stage because I didn't think it was relevant. I was focusing on the node count in the default.apt stage.

I'll be more detailed next time!

Cheers,
Cathy

We just figured it out. I changed the mode on my Teradata stage from 'parallel' to 'sequential'. Works like a charm now!

TY,
Cathy

I'm reading an sql table and writing the results to a flat file via a sequential stage. The sql query has 'group by' and an 'order by' statements to ensure unique values in the file. I'm finding that for every unique row I get back from the sql statement, DataStage is writing one for every node we h...

kumar_s --> THANK YOU!!! It worked beautifully!!!!

So where does one go about finding out about all these commands to use in Administrator??

Again, many thanks!

My issue is that I can't see ANY jobs at all (compiled or not/running or not) in Designer or Director.

I have a set of jobs that have been running in QA for over three weeks. I had an issue this weekend, which I resolved, but now I cannot see ANY categories for jobs in Director for any project. The weird thing is I know the jobs are running. I just can't see the logs in Director I checked permissions...

I'm getting an error indicating DataStage thinks the job is still abended when it really isn't. I thought if someone had a set of sqls I could run them in Administrator Command, then I could do a thorough cleanout.