Search found 71 matches

by asaf_arbely
Mon Jul 21, 2008 12:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic substring
Replies: 2
Views: 1239

Dynamic substring

I am getting a parameter for my job that includes one or more value for substring the main data. For example the value of the parameter is P_SUB=d[1,5]. On the stage variable in the job I am doing Ereplace(P_SUB,'d',LT_data.data). So the result of the command in a flat file is 'assdfdd [1,5]' and no...
by asaf_arbely
Sun Jul 20, 2008 9:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic substring
Replies: 1
Views: 1379

Dynamic substring

I am getting a parameter for my job that includes one or more value for substring the main data. For example the value of the parameter is P_SUB=d[1,5]. On the stage variable in the job I am doing Ereplace(P_SUB,'d',LT_data.data). So the result of the command in a flat file is 'assdfdd [1,5]' and no...
by asaf_arbely
Mon Sep 03, 2007 2:43 pm
Forum: General
Topic: Handling Business Rules Metadata in Datastage
Replies: 2
Views: 4455

After carefully reading your post, I understand that what you call a business rule is actually a source to target mapping rule. Am I right? I invested a lot of thinking on this issue in the past. The mapping is done by the transformer and to my best knowledge can not be dynamic. However, think about...
by asaf_arbely
Mon Sep 03, 2007 2:14 pm
Forum: General
Topic: How does Java Client and Java Transformer stage works?
Replies: 3
Views: 6606

Hi, Hope I can answer your first question regarding the Java PACK. I used to work with the Java PACK on v 7.5.2, but I believe it did not change alot. I general, a Java stage is a simple class that inherits the Stage class provided by IBM. You should implement 2 methods: initialize() and process(). ...
by asaf_arbely
Wed Aug 08, 2007 5:13 pm
Forum: General
Topic: dsr.admin error creating DR elements -1
Replies: 6
Views: 4106

One more case where you may encounter this error message - when the Oracle instance is out of space... The size figures given by IBM are too small - the DB got out of space after ~10 dataStage projects.
by asaf_arbely
Wed Aug 08, 2007 7:02 am
Forum: General
Topic: dsr.admin error creating DR elements -1
Replies: 6
Views: 4106

ok... I'm glad to announce that problem resolved - some required Oracle components (JVM and Enterprise Manager Repository) were not installed. Please note (for future reference) that one may get this error message when trying to create a project with a name that was already used during a prior faile...
by asaf_arbely
Tue Aug 07, 2007 2:59 am
Forum: General
Topic: dsr.admin error creating DR elements -1
Replies: 6
Views: 4106

We are working with Oracle 10.2.0.1
by asaf_arbely
Mon Aug 06, 2007 10:50 am
Forum: General
Topic: dsr.admin error creating DR elements -1
Replies: 6
Views: 4106

dsr.admin error creating DR elements -1

Hi, We are installing the IIS suite on a WIN2003 server, while using an Oracle instance as the MetaData repository. After installation, the project that should have been created does not exist. When we try to create a new project (via administrator) we get an error : " dsr.admin error creating ...
by asaf_arbely
Tue Jul 31, 2007 2:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deploy DataStage over Microsoft Cluster
Replies: 4
Views: 1540

Hi Ray, My customer wishes to have a failover capabilities for its night operators, so in case of a hardware failure, a secondary DS server becomes online. Obviously, the single job that was active during the failure must have cleanup capabilities (other than reset) so it can be lounched again. The ...
by asaf_arbely
Mon Jul 30, 2007 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deploy DataStage over Microsoft Cluster
Replies: 4
Views: 1540

Deploy DataStage over Microsoft Cluster

Hi there,

A customer of mine wishes to deploy DS in production environment over MS Cluster.

Does anybody know if it is possible? Did anyone try it? And maybe most interesting, does anybody know if it is NOT allowed?

Thanks in advance,
Asaf
by asaf_arbely
Mon Jul 30, 2007 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Microsoft Access MDB OLEDB
Replies: 3
Views: 1727

I encountered the same problem with DS 8.0.1 and resolved it with a patch received from IBM support.

It is a bug in the OLE DB stage.

Patch ID is e119125.

Asaf.