Search found 20 matches

by hiltsmi
Fri Nov 04, 2005 1:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem adding jobs to schedule
Replies: 15
Views: 15557

I tried it in a command window and it gives me the same error message.
by hiltsmi
Fri Nov 04, 2005 12:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem adding jobs to schedule
Replies: 15
Views: 15557

problem adding jobs to schedule

I have a new install of DataStage. I can run jobs manually but when I try to schedule a job I get the following error message. I have been unable to schedule any jobs. Error adding to schedule: at: garbage after time specification (Command was: AT 14:00 /NEXT:5 vmdsr_sched.exe C:\Ascential\DataStage...
by hiltsmi
Fri Nov 04, 2005 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: duplicate rows from oracle when running in parallel
Replies: 5
Views: 1527

Yes it is a 2 node configuration. No the records are not always together, When I do a sort at the windows command line I see 2 of everything.

I can definitely change my oracle 9i oci stage from sequential to parallel.
by hiltsmi
Fri Nov 04, 2005 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: duplicate rows from oracle when running in parallel
Replies: 5
Views: 1527

I have an Oracle stage going into a transformer stage which writes out to a flat file. In the oracle stage I have changed from the default of sequential to parallel partitioning. It does not give me any options to specify entire , round robin etc... In the transformer stage partitioning is set to th...
by hiltsmi
Fri Nov 04, 2005 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: where are the log files for DS
Replies: 12
Views: 4220

where are the log files for DS

I know how to use Director to view job logs. I would like to view/use the job logs outside of the director.

Where does DS store job logs? Are they in a text file that can be edited?
by hiltsmi
Fri Nov 04, 2005 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: duplicate rows from oracle when running in parallel
Replies: 5
Views: 1527

duplicate rows from oracle when running in parallel

My source is a table on Oracle 9i. In the Oracle 9i stage I have set it to work in parallel. When I run the job I am getting duplicate records from Oracle.

How can I set up the stage so that each partition gets a unique set of rows to process?
by hiltsmi
Wed Nov 02, 2005 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove duplicate stage compared to sort stage
Replies: 2
Views: 1387

remove duplicate stage compared to sort stage

I want to remove duplicate records from a data set. I was going to use the remove duplicates stage. The documentation says the data must be sorted before removing duplicates. However the sorter stage also has the capability of removing duplicates. Why would I want to use the removed duplicate record...
by hiltsmi
Tue Sep 20, 2005 8:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds error messages
Replies: 4
Views: 1769

I would just like a list of error messages with explanations.

Can someone tell me if such a list exists and where I can get it?
by hiltsmi
Fri Sep 16, 2005 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds error messages
Replies: 4
Views: 1769

ds error messages

I am getting error messages from the server such as

DBS000027

but I can not find a list of error messages in the documentation that I have.

Can someone tell me where to find a list of error messages and their descriptions?
by hiltsmi
Fri Sep 16, 2005 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsenginge won't start
Replies: 5
Views: 2207

I am running all the DS software (client/server) in one box. I can connect to the box. None of the datastage windows services will run, including the engine and rpc. If I try to start the service manually I get "Error 1053: the service did not respond to the start or control request in a timely...
by hiltsmi
Thu Sep 15, 2005 6:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsenginge won't start
Replies: 5
Views: 2207

I had exported the job from server version 7.5 and imported it into the new 7.5x enterprise version both running on windows. We have been running version 7.5x for about a month but only with new jobs created on that server. I recompiled the job and then tried running the job. Could the problem be fr...
by hiltsmi
Thu Sep 15, 2005 12:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsenginge won't start
Replies: 5
Views: 2207

dsenginge won't start

I am running on windows with 7.5x enterprise edition. My jobs are all server. I ran a job with an empty source file. After the job was running for several minutes I tried to stop the job from the director. I then got a popup window complaining about an internal error. I clicked okay and the popup di...
by hiltsmi
Tue Sep 06, 2005 5:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: fixed width columns and the default null string
Replies: 4
Views: 1750

In this case an empty string and NULL are not the same thing. An empty string indicates no data was entered into the field but null indicates the data is unknown.
by hiltsmi
Fri Sep 02, 2005 9:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: fixed width columns and the default null string
Replies: 4
Views: 1750

fixed width columns and the default null string

I am receiving fixed width files. I would like to determine when a column value is null. On the sequential file stage - outputs - format screen there is a field called "default null string". Can someone explain how this is supposed to be used? My assumption was that if I put a value there ...
by hiltsmi
Sat Aug 13, 2005 5:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: check for a particular row existing in the incoming file
Replies: 2
Views: 1013

check for a particular row existing in the incoming file

The first 3 characters of each incoming record indicates the record type. Record type = '999' indicates that the record is the trailer record. At the end of each incoming file there should be a trailer record, which contains a count of the number of records in the file. I have a transformer stage in...