Search found 5168 matches

by kumar_s
Thu Mar 02, 2006 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of Row in Dataset.
Replies: 5
Views: 1088

:oops: This is quite embarrassing...but i have found the answer. I have been relying on the performance statics in the Designer. What happens is that once the join stage takes over from the two Datasets the datasets stop counting rows (the last refresh). I was looking at this premature count and th...
by kumar_s
Wed Mar 01, 2006 7:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: passing parameter values
Replies: 7
Views: 1873

No, there isnt any inbuilt parameter file for dsjob. Instead you need to create of your own logic and need to prepare code(Shell script) to read the parameter file and pass the values to the dsjob commands.
by kumar_s
Wed Mar 01, 2006 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unconditional Trigger in the sequence jobs
Replies: 3
Views: 2446

An unconditional trigger fires the target activity once the source activity completes, regardless of what other triggers are fired from the same activity.
by kumar_s
Wed Mar 01, 2006 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Message handler
Replies: 7
Views: 2563

It is not really required to include indivudially in each job while the option exist in project wide. Gather all the message to be handled in to a single file (Message Handler) and enable the same in DS Adminstrator under the Parallel tab for each project.
by kumar_s
Wed Mar 01, 2006 6:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass yesterday's date as parameter
Replies: 9
Views: 2487

Create a parameter for table name.
In Job Sequence Value expression where parameters value is passed, use TAB:Oconv(Date()-1,"DMDY[2,2,4]")
Where TAB is the parameter for the table name.
by kumar_s
Wed Mar 01, 2006 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL errors while running batch schedule
Replies: 13
Views: 8679

It seems you have already altered the APT_PM_CONDUCTOR_TIMEOUT in administrator to avoid time outs. Still you get error mention in point 4. It also seems conductor process cannot reach section leader process on each processing node. Its Clearly ment your server is overloaded. Try to avoid calling th...
by kumar_s
Wed Mar 01, 2006 5:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Union for few Materialized Views.
Replies: 2
Views: 936

Hi, DB question in DS forum. It shuldn't be a matter whether it a table or Materialized view for the union funciton. But it depends on the frequency rate of your refresh to the view. And depends on the location the base table resides. Something similar to this, if you want to union two materialized ...
by kumar_s
Wed Mar 01, 2006 5:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TRANSLATE - Equivalent DS Function
Replies: 1
Views: 2872

Convert (list, new.list, string)
by kumar_s
Wed Mar 01, 2006 5:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Project Locking
Replies: 4
Views: 1489

Project Currently Locked. The project is currently locked by the administrator. Try again later or see your Administrator.

It seems this is not for this job alone...
Check with other job...
If so restart the server.
by kumar_s
Mon Feb 27, 2006 6:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unzip a .gz file through DataStage Server edition.
Replies: 10
Views: 2669

Re: Unzip a .gz file through DataStage Server edition.

Shailendra wrote:...Can it be done purely in DataStage without any command line code. Any suggestions are welcome.

Didnt noticed this.
Well... Server edition dosent have any dedicated Stage, but Exteded Edition have a stage called 'Expand'. Purposfully built for this.
by kumar_s
Mon Feb 27, 2006 5:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of Row in Dataset.
Replies: 5
Views: 1088

This is quiet Odd :evil:
Is there any configuration file?
Are you sure that you are refering to the number of rows and not the number of rows/sec.
How about the output. Is it as expected or still unconsistent.
by kumar_s
Mon Feb 27, 2006 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: timestamp format
Replies: 8
Views: 1503

keshav0307 wrote:i do not find the "Extended" column property

Right click on the Field properties grid. You can find the list of check option. Extended option might be unchecked.
by kumar_s
Mon Feb 27, 2006 5:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unzip a .gz file through DataStage Server edition.
Replies: 10
Views: 2669

Try with the filter option in Sequential stage. Give your unzip command in that.