Search found 11 matches

by Curious George
Tue Jan 07, 2014 1:05 pm
Forum: General
Topic: DataStage Upgrade
Replies: 5
Views: 3974

Hi All

Kindly request your help in this regard.
How is an upgrade carried out in a Grid environment from IIS v8.5 to IIS 9.1

Thanks
George
by Curious George
Fri Dec 27, 2013 1:51 pm
Forum: General
Topic: DataStage Upgrade
Replies: 5
Views: 3974

Hi,

Thanks for your response. As of now DataStage v9.1 is not installed. We currently have only v8.5.
by Curious George
Fri Dec 27, 2013 1:09 pm
Forum: General
Topic: DataStage Upgrade
Replies: 5
Views: 3974

DataStage Upgrade

Hi All, We are currently in the process of upgrading from DataStage v8.5 to v9.1 Linux is the Platform that is used currently and will be used for the future version as well. I have never worked in an upgrade project before and would like to understand the steps that should be performed for upgradin...
by Curious George
Tue Dec 17, 2013 9:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar field length
Replies: 4
Views: 4024

Hi All, Thanks for your replies. As I mentioned I prefer defining the length of the varchar field but since its a response from some other system I dont have control over that and further they too told it is dynamic and change. When we dont define the length for a varchar field what is the length th...
by Curious George
Tue Dec 17, 2013 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar field length
Replies: 4
Views: 4024

Varchar field length

Hi All, I'm trying to read a xml message into a varchar field. The length of the xml message could vary and I'm reading it into a single nvarchar field. As of now I have not defined any length for the nvarchar field as the length of the message could vary. I have 2 approaches in mind: 1. Define a ve...
by Curious George
Mon Nov 04, 2013 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Grid compute node
Replies: 7
Views: 6830

Hi

Thanks for the reply. I was under the same assumption reading the IBM manuals but as I mentioned two numbers are passed to this variable .
by Curious George
Mon Nov 04, 2013 2:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Grid compute node
Replies: 7
Views: 6830

Grid compute node

Hi All, Can you please let me know why we would pass 2 values to APT_Grid_computenodes From what I read about the Apt variable I was thinking it should have a single value passed to it. But in the current environment for a new customer I see values passed like the below: Apt_grid_computenodes=2,2 or...
by Curious George
Mon Nov 04, 2013 12:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS to Cassandra
Replies: 2
Views: 2383

DS to Cassandra

Hi All, Please let me know if it is possible to connect to Cassandra server using DataStage Java Client/Java Transformer Stage. There is no driver for Cassandra available in the DataStage server. I would like to know if there is a way to connect to Cassandra directly using pure Java code without any...
by Curious George
Mon Nov 04, 2013 12:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector
Replies: 6
Views: 3462

Hi Ray/MT,

Thanks a lot for your response. I checked as per the input provided by MT. It shows the Execution Mode parameter as 'Sequential'.

Thanks for your valuable inputs.
by Curious George
Fri Nov 01, 2013 3:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector
Replies: 6
Views: 3462

Hi Ray, Thank you for your reply. Hi MT, My job flow is below: Sequential File --> DB2 Connector I saw the partitioning icon in the link which flows from the Sequential file to DB2 Connector and it shows the symbol wherein data is converging into the DB2 Connector. I opened the different tabs in the...
by Curious George
Thu Oct 31, 2013 9:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector
Replies: 6
Views: 3462

DB2 Connector

Hi All, I have a Parallel Job which has an input Sequential Stage which feeds data to a DB2 Connector Stage which updates a table. In the DB2 Connector Stage in the Partitioning tab the Collector Type is specified as 'Auto'. Please let me know if the DB2 Update would run in parallel or in sequential...