Search found 125 matches

by kommven
Tue Aug 22, 2006 8:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing to Oracle Table is slow
Replies: 8
Views: 3171

Try DB Tuning by placing some indexes with Keys columns in place...

Thats the only solution available....

One another Option is to capture your logic in ETL and use insert strategy....
by kommven
Tue Aug 22, 2006 7:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Truncation Warning
Replies: 7
Views: 3734

Try

Code: Select all

Oconv(description,"MCP")[0,200]
and increase the value till you get error and fix it...
by kommven
Tue Aug 22, 2006 7:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Parameters Vs Environment variables
Replies: 8
Views: 8558

Think about changing parameter based on Environment.
Yes, I agree its purely a Scope.
But again, its depends on your creativity...
by kommven
Mon Jul 03, 2006 6:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic email body & send with Notification Activity
Replies: 9
Views: 10265

If I were you, I will write what I need to a file (using a shell script maybe) and cat it in subject in "Notification Activity"

`cat mystatusFile.txt`

Try it it works for me...

Kommven-
by kommven
Mon Apr 24, 2006 8:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file error
Replies: 7
Views: 3490

This is the orchadmin utility at Unix prompt

Code: Select all

orchadmin check
by kommven
Mon Apr 24, 2006 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file error
Replies: 7
Views: 3490

Any Help to debug

Code: Select all

Caught ORCHESTRATE exception in parallel process: APT_Archive::BadClass: From: Loading memory archive: Could not find "APT_RealFileExportOperator". 
[/b]
by kommven
Mon Apr 17, 2006 4:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open executable job file RT_CONFIG623
Replies: 12
Views: 5277

Can you re-create the same error?

Try developing a similar job and try to get similar error.
This is the way to get solution....
made a mistake, do it again here get the cause and never do it again...
by kommven
Sun Apr 09, 2006 1:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file error
Replies: 7
Views: 3490

Keygen was completed successfully. Ina shell, We could ssh from one box to itself and to other boxes without passwords. and same on every box. I am trying to check my config on just primary and then go with load balancing. I am unable to understand why there is Lib's/Memory load error Do I need to e...
by kommven
Sat Apr 08, 2006 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file error
Replies: 7
Views: 3490

We have changed our authenication from rsh to ssh and it happening from then on.

We have to change the scripts in bin and etc to enable HA (high availabilty)

APT_ORCHHOME and APT_CONFIG_FILE are set properly.

I believe orchadmin is looking for some missing libs.
by kommven
Fri Apr 07, 2006 8:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file error
Replies: 7
Views: 3490

Configuration file error

When trying to check configuration using "orchadmin check" getting the following output. Need to know why this happens. configuration file { node "node1" { fastname "XXXX" pools "" resource disk "/s01/DataStage/Projects/" {pools ""} resourc...
by kommven
Fri Mar 03, 2006 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation problem - unable to see the full palette
Replies: 16
Views: 7961

Do you have same server and client versions?
by kommven
Thu Mar 02, 2006 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: packed decimal value, how to supress zeros
Replies: 5
Views: 3927

USE Abs OR DIVIDE THE VALUE BY 1 IN TRANSFORMER
by kommven
Thu Mar 02, 2006 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null date in transformer
Replies: 14
Views: 8642

Is NLS enabled on this Job?
If "YES" IsNull will not work for UStrings.
Make sure that Date field is not Ustring.
by kommven
Thu Mar 02, 2006 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clustering and High Availability
Replies: 3
Views: 1474

How about Veritas Cluster Software.

My Question :

If a Job is initiated and running on Server 1 and Server 1 eventually over-loaded, is there a scope for the load to shift AUTOMATICALLY to Server 2?
by kommven
Thu Mar 02, 2006 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation problem - unable to see the full palette
Replies: 16
Views: 7961

I believe there is a utility that shipped with your client called Multi-Client Manager. You need to install and all clients with respect to server Version You need to select the correct version using Multi-Client Manager to see complete pallete. You need to to reset to factory defaults for the palle...