Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
uegodawa
Participant
Posts: 71 Joined: Thu Apr 27, 2006 12:46 pm
Post
by uegodawa » Wed Mar 04, 2009 3:01 pm
I would like to know answers for following questions.
1. Is your Tgt_StagingArea is a Flat File ?
2. If 'Yes' have you enabled 'output column names' to True ?
If 'Yes' this explains why you got addition record in your output rather than input.
Thanks,
Upul
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Wed Mar 04, 2009 3:15 pm
Here is the answers
1. Is your Tgt_StagingArea is a Flat File ? Yes
2. If 'Yes' have you enabled 'output column names' to True ? No
Also I checked this Flat File on Unix, there is one record (NOT COLUMN NAME)
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Thu Mar 05, 2009 2:09 pm
No one has a clue
priyadarshikunal
Premium Member
Posts: 1735 Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI
Post
by priyadarshikunal » Fri Mar 06, 2009 7:52 am
Few Questions
1. How you are generating the report?
2. posted logs are complete?
3. What is the value of environment variable APT_NO_JOB_MON?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Fri Mar 13, 2009 10:33 am
priyadarshikunal wrote: Few Questions
1. How you are generating the report? From notification activity (Include job status in email)
2. posted logs are complete? Yes
3. What is the value of environment variable APT_NO_JOB_MON? False (Set at Administrator level)
priyadarshikunal
Premium Member
Posts: 1735 Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI
Post
by priyadarshikunal » Fri Mar 13, 2009 11:44 am
Seems to me like its generating report for wrong instance or datastage is facing some problem in reading it.
The job started at 02:05:40 in report its 02:05:38.
first check whether its happening for other instances too.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.