DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 83 matches
Author Message
 Topic: Job Abort
tagnihotri

Replies: 2
Views: 1288

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Aug 31, 2009 10:52 pm   Subject: Job Abort
One of the other common mistake is handling the warnings in seq. Many a time we have some "acceptable" or agreed warnings, but then while building the seq we need to be sure to code the seq in a way t ...
 Topic: Identifying Long Running Jobs
tagnihotri

Replies: 8
Views: 2902

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Aug 31, 2009 10:44 pm   Subject: Identifying Long Running Jobs
The way I have achieved this is, by writing the start time of each job at the start of job and then keep on checking the elapsed time from this log file and if a job is running more than expected*, an ...
 Topic: Hash File Error
tagnihotri

Replies: 3
Views: 1336

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Nov 14, 2006 7:30 am   Subject: Re: Hash File Error
Also check for the correct VOC entries (which should be in synch with the presence of the mentioned files).
 Topic: Performance Tuning
tagnihotri

Replies: 9
Views: 2716

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Nov 14, 2006 7:25 am   Subject: Performance Tuning
Can you please detail the job design, how you have identified the "slow running statements" from jobs!
I do agree the scenario can occur in any DW but recommendations depends on Design and Functiona ...
 Topic: Checkpoint run in Sequencer
tagnihotri

Replies: 6
Views: 1492

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Nov 14, 2006 7:20 am   Subject: Re: Checkpoint run in Sequencer
Can you elaborate the point "But this requirement is only for job 4 and not for any other job" !
Resolved
 Topic: Join stage
tagnihotri

Replies: 13
Views: 4616

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 14, 2006 7:18 am   Subject: Re: Join stage
Have you sorted both the links in same order ?
Resolved
 Topic: Job Sequencing
tagnihotri

Replies: 4
Views: 1314

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 13, 2006 2:54 am   Subject: Re: Job Sequencing
Also let us know the functional requirement!
 Topic: Performance Tuning
tagnihotri

Replies: 11
Views: 3122

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Nov 10, 2006 2:26 am   Subject: Re: Performance Tuning
Tunning querries depends on n number of things i.e. whether db is paritioned ? whether you are using indexing efficiently ? Whether you are extracting only required collumns? ....

As far as handlin ...
 Topic: Lookup Stage
tagnihotri

Replies: 7
Views: 1972

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 10, 2006 12:20 am   Subject: Lookup Stage
APT_STRING_PADCHAR, trim sometimes don't actually trim the collumns which are padded with funny characters (depending on the default value of the env variable). So better check the collumn data, which ...
Resolved
 Topic: DS Info - Problem with URL
tagnihotri

Replies: 8
Views: 4522

PostForum: General   Posted: Fri Nov 10, 2006 12:16 am   Subject: DS Info - Problem with URL
I read you don't have acess to DS which makes things tougher! But the best way I think would be to base any DS version say 7.5 first, try and explore the pdf's its features and fundamentals. For any q ...
 Topic: Loading from db into a squential file without deilimeter.
tagnihotri

Replies: 6
Views: 1439

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 10, 2006 12:05 am   Subject: Loading from db into a squential file without deilimeter.
"and the sqltype as char" While doing this check for the paded character (i.e. default env variable) because you may end up padding your char fields with funny characters which may not be even printab ...
 Topic: Error retrieving results from server
tagnihotri

Replies: 8
Views: 3493

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Nov 10, 2006 12:02 am   Subject: Error retrieving results from server
The syntax of the string representation of a datetime value is incorrect. Quick solution may not be the best one is to read and write your date collumn changing their data type to char. This should su ...
Resolved
 Topic: functionality question
tagnihotri

Replies: 4
Views: 1601

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 09, 2006 11:56 pm   Subject: functionality question
Please mark the post as resolved
 Topic: Reference lookup generated, Only the last row was used
tagnihotri

Replies: 11
Views: 7447

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Nov 09, 2006 11:54 pm   Subject: Reference lookup generated, Only the last row was used
As highlighted "insert a single active record in the target table", we should have only one active record which if changed should be updated or if a new record not present in db comes, should be inser ...
 Topic: dataset read problem
tagnihotri

Replies: 13
Views: 4243

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 09, 2006 11:45 pm   Subject: dataset read problem
Ray, I will take a note of this from there on! thanks


Adasgupta,
Can You please detail your job design
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours