Search found 233 matches

by just4u_sharath
Mon Mar 03, 2008 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: when i try to load data into idoc
Replies: 2
Views: 1093

when i try to load data into idoc

IDOCMAPPING_INSPECTION_CHARACTERISTICS_tra: Failed to load the library "V0S2_WAREHOUSE_MASTER_ldr_IDOCMAPPING_INSPECTION_CHARACTERISTICS_tra.o"; either the directory containing the library file is not on the library search path, or the library was compiled on a system that is incompatible ...
by just4u_sharath
Sun Mar 02, 2008 11:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Size errror in Transformer
Replies: 13
Views: 4291

Ray made the right guess (judgment)!! Set the Combinable mode to false in the Transformer's properteis. You ll get the error in the right stages! In my job there is a lookup stage looking up datasets and a transformer outputted to datasets and funnel stage. No sorting. No aggregator. But the still ...
by just4u_sharath
Fri Feb 29, 2008 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Size errror in Transformer
Replies: 13
Views: 4291

The error is actually thrown by APT_CombinedOperatorController - you have no idea which stage is to blame. That's why we rarely attempt to diagnose errors from this operator. It may even be that the heap problems come from an inserted tsort operator. I am a novice at this kinds of errors. So please...
by just4u_sharath
Fri Feb 29, 2008 12:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Size errror in Transformer
Replies: 13
Views: 4291

Heap Size errror in Transformer

I have run my job to extract 9Million records and my job aborted indicating the below error. In this i cannot understand what is heap size. What is heap size in transformer and how can i overcome this fatal error. APT_CombinedOperatorController,0: The current soft limit on the data segment (heap) si...
by just4u_sharath
Fri Feb 29, 2008 12:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while Loading a table using ORACLE
Replies: 8
Views: 3534

CHECK THIS LOG ora.8736.483000.0.log IT WILL SHOW U EXACTLY WHAT THE ERROR IS,AND IT MAY BE NULLS COMING FROM SOURCE DATA WHICH WAS NOT HANDLED IN TRANSFORMATION,OR MAY BE ORACLE LOADER ERROR,CHECK THE LOG AND COPY AND PAST IT IN WORD DOC U CAN HAVE CLEAR PICTURE.
by just4u_sharath
Fri Feb 29, 2008 11:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job is unlocked but still not opening in designer
Replies: 8
Views: 3345

easy way to unlock job is,make dsx from manager to desktop and make read only 1 to read only 0,do this option by find and replace.
and import that job again from manager and c,it works
by just4u_sharath
Thu Feb 28, 2008 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how can use ISNULL function in datastage
Replies: 2
Views: 9751

If IsNull($1) Then '' Else Trim($1,' ')
by just4u_sharath
Tue Feb 26, 2008 7:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abnormal termination of datastage job
Replies: 3
Views: 2684

kill phantoms and try again
by just4u_sharath
Mon Feb 25, 2008 6:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle read error
Replies: 1
Views: 1242

Oracle read error

In my extraction job there are two oracle stages ouput of which is funneled and passed to other stages. I know from one oracle stage, no data will be outputted. when i run the job, the job aborted and below is the error message. Can you help me with this issue. From the below oracle stage no data is...
by just4u_sharath
Mon Feb 25, 2008 12:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequel error in ds
Replies: 1
Views: 508

sequel error in ds

JPM_SQL_OPTION5=where to_char(PAY_END_DT,'YYYY') in ('2006','2007') when i try to pass to restrict all rows to some,the job gets aborted showing error like the year was not declared properly,and displaying year with out quotes where to_char(PAY_END_DT,YYYY) in (2006,2007),in log the single quotes no...
by just4u_sharath
Fri Feb 22, 2008 1:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Log retrieve
Replies: 4
Views: 1256

chulett wrote:Perhaps 'gone' just means 'outside of the current Filter limits'. Do you have a limit on the number of log records you can display? Does the Director show (Filtered) in the status line?
No i mean log is purged. So if purged i can get the log back only through System Backups. Am i right
by just4u_sharath
Wed Feb 20, 2008 1:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning
Replies: 2
Views: 1313

warning

i want to know about this warning
test1_dummy_txt,0: Missing record delimiter "\n", saw EOF instead
by just4u_sharath
Wed Feb 20, 2008 1:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Lookup issue, an interesting one!
Replies: 6
Views: 2716

check with the warnings also,as more warnings coming than limit this error occurs,change limit size to bigger no and c
by just4u_sharath
Wed Feb 20, 2008 12:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Lookup issue, an interesting one!
Replies: 6
Views: 2716

Re: DS Lookup issue, an interesting one!

Hi all, For those DS experts out there, I am facing an interesting issue which you may have come across. although i am assuming you may think this is a typical SIGSEGV problem (which i am not too sure about). Job Background: Input: a dataset (sequential execution mode) reference dataset (sequential...
by just4u_sharath
Tue Feb 19, 2008 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: kill pid
Replies: 10
Views: 4577

kill pid

how to kill pid of other users,if any one locked the job with there ids.
i need unix command to kill process ids of other users