Search found 53125 matches

by ray.wurlod
Fri Jan 20, 2012 4:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filepattern - reading list of files
Replies: 18
Views: 6029

I have given with 'cat' in file pattern .. but i'm getting the follow error : Sequential_File_0,0: Couldn't find any files on host SEW06728 with pattern CAT//\ \ H:/DEV_VIF0_EE/TEMP/TEST./*. Do i need to enable /check any option That's what you get for hopping onto the end of someone else's thread....
by ray.wurlod
Fri Jan 20, 2012 4:55 am
Forum: General
Topic: Find the datastage version
Replies: 8
Views: 3940

You've been around DSXchange long enough to know that the uv command is issued from the DSEngine directory with DSEngine's bin subdirectory in your command search list (PATH environment variable) or the uv command executed as bin/uv. It's also necessary, as you should also know, to have run the dsen...
by ray.wurlod
Fri Jan 20, 2012 4:49 am
Forum: General
Topic: Number of Projects/Jobs
Replies: 17
Views: 6676

There is no limit on the number of projects that you can create. However, you must have enough room for all of them on your disk system. Actually there is a limit, when the size of tables such as UV.ACCOUNT and UV_SCHEMA reach their 2GB limit, but that will give you at least a million projects even ...
by ray.wurlod
Fri Jan 20, 2012 4:46 am
Forum: General
Topic: Job Execution steps
Replies: 4
Views: 1038

Not a small topic. A chapter or two in a book. Rather too much to do here.
by ray.wurlod
Fri Jan 20, 2012 4:45 am
Forum: General
Topic: Find the datastage version
Replies: 8
Views: 3940

Have you tried uv -admin -info ( maybe even uv -admin -version)?
by ray.wurlod
Fri Jan 20, 2012 4:44 am
Forum: General
Topic: output of netstat
Replies: 5
Views: 1530

We still don't know what it is you don't understand. A good trick to get headings is

Code: Select all

netstat -an | head -2 ; netstat -an | grep 3153[1,3]
Meanwhile spend some time reading the man pages for netstat.
by ray.wurlod
Fri Jan 20, 2012 4:42 am
Forum: General
Topic: Datastage History
Replies: 6
Views: 1973

Probably, but I'd have to do the same research, so why don't you do it? I'd search for something like "announcement" in conjunction with the product and version, probably looking for press releases.
by ray.wurlod
Fri Jan 20, 2012 12:05 am
Forum: General
Topic: output of netstat
Replies: 5
Views: 1530

What in particular don't you understand?
Your command is displaying netstat for all (-a) processes, then using grep to restrict the output for port numbers 31531 and 31533, so presumably you're investigating whether the ASB agent and logging agent processes are active.
by ray.wurlod
Fri Jan 20, 2012 12:03 am
Forum: General
Topic: Datastage History
Replies: 6
Views: 1973

Version 1.0 came out in 1997 so you don't have to go back farther than that.

The first version of UniVerse, on which earlier versions of DataStage was built, came out in 1984. It was based on Prime INFORMATION, which first saw the light of day in the mid 1970s.
by ray.wurlod
Thu Jan 19, 2012 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diff results in each run
Replies: 5
Views: 2199

In spite of its impressive length the generated OSH is singularly unhelpful in answering this question. More useful would be the score. In the meantime you could advise us how the data are partitioned, particularly on the inputs to the Lookup stage, and whether anything (such as the contents - not t...
by ray.wurlod
Thu Jan 19, 2012 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trouble with StringToDate
Replies: 10
Views: 4281

I guess the "=" should have been "<>".

Does Len(string) return 0 when string IS NULL, like it does in server jobs?
by ray.wurlod
Thu Jan 19, 2012 5:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading & Writing using different configuration file
Replies: 11
Views: 2803

Was the Data Set that feeds it written with an 8-node configuration file?
by ray.wurlod
Thu Jan 19, 2012 5:54 pm
Forum: General
Topic: Where are DataStage jobs stored?
Replies: 5
Views: 4778

Tables, in the "UniVerse" sense. They are implemented as DataStage hashed files.

You can not import from a DSX or XML export if the DS_* objects are not present.

Restoring exactly what was there before (only the objects that were deleted) will not cause a problem for XMETA.
by ray.wurlod
Thu Jan 19, 2012 3:05 pm
Forum: General
Topic: Where are DataStage jobs stored?
Replies: 5
Views: 4778

The job design information is stored in the local project repository, which is located in the project directory, in tables such as DS_JOBS and DS_JOBOBJECTS. Time to restore from backups.
by ray.wurlod
Thu Jan 19, 2012 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: scd stage initvalue
Replies: 2
Views: 1288

You have a separate job, in which the SCD stage has an input link only.