Search found 56 matches

by raviyn
Tue Jan 17, 2006 6:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Error Reason code 2035
Replies: 2
Views: 4420

MQ Error Reason code 2035

Hi, When we are trying to put a message on the quue we are getting the following error . WebSphere_MQ_2,0: Fatal Error: Fatal: Failed to open queue. Reason code 2035. The UNIX user used to run the Datastage jobs is also part of the MQ series group who has permissions to write messages on to the Loca...
by raviyn
Wed Nov 30, 2005 4:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Series Trigger
Replies: 4
Views: 3033

Thank Ray.

I thought MQ series was all abt real-time and all so thought we have some Event based triggering in Datastage based upon the message being there or not in the queue something like an Event based trigger for a file in a particular folder :?
by raviyn
Mon Nov 28, 2005 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Series Trigger
Replies: 4
Views: 3033

Re: MQ Series Trigger

Any :idea: :?: :?:

Thanks in advance
by raviyn
Wed Nov 23, 2005 5:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Series Trigger
Replies: 4
Views: 3033

MQ Series Trigger

Hi, After going through the Documentation i have understood that for DS to work with MQ we need to have on DS Server an MQ Series Server which can later connect to any other remote MQ Series server . What I wanted to know was : 1) How can we trigger a DataStage job as soon as a we have a particular ...
by raviyn
Thu Aug 11, 2005 1:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Long DataType - Oracle datatype not presently supported
Replies: 14
Views: 12085

I found a way out while pulling this data from the source i have given the datatype at the source as VarBinary 100000 and extracting the data and Loading the data as Longvarchar Field . The job ran without any warnings and the data looks good. I tried using the CAST operator on the Long Data Type bu...
by raviyn
Thu Aug 11, 2005 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Long DataType - Oracle datatype not presently supported
Replies: 14
Views: 12085

I tried using the CAST operator on the Long Data Type but it is giving inconsistent data type error . So should I be first converting the LONG to a CLOB object and then use the CAST command in Oracle to acheive the results ? Example: SELECT CAST(CLOB_column AS VARCHAR2(4000)) FROM Table; Declare the...
by raviyn
Wed Aug 10, 2005 12:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Long DataType - Oracle datatype not presently supported
Replies: 14
Views: 12085

Re: Update

Does Ascential now support the LONG,CLOB,BLOB Character fields ??

If no then is there any work around available for this ...

Thanks
Ravi

1stpoint wrote:Ascential support has entered an enhancement request for the ORAOCI9 plugin to support long datatypes.
by raviyn
Tue May 10, 2005 8:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX unable to find an Oracle Instance
Replies: 10
Views: 7742

Try Putting this variable in User-Defined Environment Variables in Datastage Administrator to true APT_ORACLE_NO_OPS Default Value - True.. See if it works... HTH when i am using ORACI9 stage in server job then i am able to read the source system, but when i am using PX then i am getting error. Plea...
by raviyn
Fri Apr 15, 2005 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buffer Problem
Replies: 1
Views: 1942

Buffer Problem

Hi, We are getting the Following error when we are running our job : buffer(5),3: APT_BufferOperator: Add block to queue failed. This means that your buffer filesystems all ran out of file space, or that some other system error occurred. Please ensure that you have sufficient scratchdisks in either ...
by raviyn
Wed Apr 06, 2005 5:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What does this error message mean?
Replies: 6
Views: 3566

Hi, Hi we are also getting the same error ... We monitored the Df- k we are not hitting 100% ..Also This is the output of ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 1048576 stack(kbytes) 392192 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 Ple...
by raviyn
Fri Feb 04, 2005 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Number From Oracle
Replies: 5
Views: 3424

I tried the Options stated below You can start by making the 'Execution Mode' for the lookup stage as 'Sequential' in your design. This will force PX not to run it in parallel and work similar to Server job. Also you need to declare the 'Lookup Type = Sparse' in case of Oracle. but it is giving me a...
by raviyn
Thu Feb 03, 2005 7:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Number From Oracle
Replies: 5
Views: 3424

Sequence Number From Oracle

Hi all, I want to get the next sequence for x records coming from the I/P source . I need to get X new Sequence values from oracle. But for a given record I have to Put in two tables,same set of records with the same sequence number. this is easily possible in Server by using oracle as refernce link...
by raviyn
Thu Dec 16, 2004 6:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController,1: Operator terminated abnorm
Replies: 4
Views: 4005

Hi, Do you have any transformer stages in your job? If yes are you calling user defined functions in it? Yes I have it and I have 2 Columns which are string and need to convert into the numeric format so using the STRINGTODECIMAL function.... The two cols are declared as VARCHAR2(10) in the source ...
by raviyn
Thu Dec 16, 2004 10:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController,1: Operator terminated abnorm
Replies: 4
Views: 4005

APT_CombinedOperatorController,1: Operator terminated abnorm

I am getting the following error APT_CombinedOperatorController,1: Operator terminated abnormally: received signal SIGSEGV When I am trying to load the Oracle table , the source is also an oracle table. I am performing 2 Lookups in b/w using the Oracle stage. The data also is very small only around ...
by raviyn
Fri Sep 17, 2004 5:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in DataStage RT_CONFIG_622
Replies: 2
Views: 1462

Error in DataStage RT_CONFIG_622

Hi,

While tring to save the Job I am getting an error
Unable to write Record <Job Name> to file RT_CONFIG622.

Any Suggestions, while trying to rClear the status also I get an error.