Search found 2288 matches

by roy
Sun Jul 17, 2005 3:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Waning in test, abort in prod
Replies: 8
Views: 2548

I'd also recommend trying a manual export import of the job via manager to see if you get a different error code.

I had something similar in EE and a no warning job came up with warning after being promoted via VC.
I exported/imported it and got another warning, So it's worth a check.

IHTH,
by roy
Sun Jul 17, 2005 3:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown Data Type From a Column Load based on Informix Table
Replies: 4
Views: 2018

I ment consult your DBAs as for a syntax for extracting it, or how it is actually stored in order to set a proper type and extract the data. I don't have Informix available to test this right now, so I contacted a freind and he confirmed my thoughts, its a number so just get it a small int or intege...
by roy
Sun Jul 17, 2005 2:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange Connection Error
Replies: 1
Views: 730

Hi,
Have you tried searching for this info?
Contact your support, though people got it no one posted a solution :(
http://www.dsxchange.com/viewtopic.php?t=92027
poped up 2 cases, 1 is above.

p.s.
I used :
'dbx' and 'sed' are installed
In my search criteria.

IHTH,
by roy
Sun Jul 17, 2005 2:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: abt db2 EE
Replies: 10
Views: 2987

Hi,
Can you post your config file?
by roy
Thu Jul 14, 2005 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: User Variable Activities in series
Replies: 3
Views: 1661

Hi,
does a sequencer stage do the trick as well?
by roy
Thu Jul 14, 2005 8:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Waning in test, abort in prod
Replies: 8
Views: 2548

Hmm,
Are both projects same in configuration?
How did you promote the job to production?
make sure the users used have exactly the same profile on both DBs.

did you find anything along those lines?
by roy
Thu Jul 14, 2005 8:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer did not pass the Parameter Value
Replies: 12
Views: 4814

Hi,
Assuming the code is ok.
How is this job invoked?
Is it via a schedualed task? (check it out)
If you changed the job did you unschedual and reschedual it?

Inconcistant behaviour might sugest a corrupted repository. (DS.REINDEX ALL when no one is in the project)

IHTH,
by roy
Thu Jul 14, 2005 8:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown Data Type From a Column Load based on Informix Table
Replies: 4
Views: 2018

Hi, Informix has an interval data type being year to day in range or hours to fractions and any combination inside the 2 distinct ranges. hour to hour means only hours. I don't recall the specifics but you might need to convert that type to a time format if it dosn't work automatically. Consult with...
by roy
Thu Jul 14, 2005 8:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error calling subroutine: DSR_JOB (Action=17)
Replies: 2
Views: 1217

Hi,
searching this forum with the 30107 key word
would have led you to DS.REINDEX ALL

your repository is probably corrupted.

note: no users should be connected while performing this command.

IHTH,
by roy
Thu Jul 14, 2005 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job promoted to test from dev via VC gives NLS warnings
Replies: 2
Views: 817

Update,
When performing specific export/import it now complains on ustring to string conversion, though all related columns have the extends unicode option :?:
still trying to solve it.
Last option would be rebuilding it :(.
by roy
Thu Jul 14, 2005 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job promoted to test from dev via VC gives NLS warnings
Replies: 2
Views: 817

job promoted to test from dev via VC gives NLS warnings

Hi Yall, Im getting: main_program: Invalid character conversion found converting to ISO-8859-1, substituting. Ora_Crm_Peula_Yadanit,0: Invalid character conversion found converting to ISO-8859-1, substituting. Both projects are on the same macihne using the same DB and no config diff seems to exist ...
by roy
Thu Jul 14, 2005 4:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ERROR
Replies: 1
Views: 749

Hi,
searching this forum would have led you to hte env var of:
APT_DISABLE_COMBINATION
setting it to true will preserve the individuall stages from being combined then the log should give moe specific location for the stage causing the problems.

IHTH,
by roy
Thu Jul 14, 2005 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue when trying to check a configuration file
Replies: 7
Views: 2026

Hi, EE on windows is kinda new. It seems that the temp dir is somehow set to a unix temp dir. you should have an env var TMPDIR pointing to your temp dir. you might also want to check some APT_... vars configuring other temp dirs as well. There is the off chance you'll need a fix so Contact your sup...
by roy
Thu Jul 14, 2005 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File type
Replies: 5
Views: 1117

To vague a question for answers :(

can you elaborate?
by roy
Thu Jul 14, 2005 12:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential stage and wildcards in the Filter
Replies: 8
Views: 2215

Hi,
Seems weird, as if the stage ignores the command and forces the value in the file path and not accepting wild cards.
I'm on 7.5 :shock:

Anyone got something different?