Search found 181 matches

by seanc217
Tue Mar 09, 2010 11:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Common Connector Migration Tool login problem
Replies: 5
Views: 6494

Did you get a resolution to this yet?
I have a PMR open too.

I will update if I get any answers.

Thanks.
by seanc217
Wed Aug 12, 2009 8:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Status 99
Replies: 18
Views: 12004

Fyi the patch I applied is: JR30015v3
This does depend on your OS as stated before, but have the support person look this up for your environment.
by seanc217
Thu Aug 06, 2009 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selection of which Database for metadata repository?
Replies: 7
Views: 5395

We are running:
Oracle 10.2.0.4.0 this is with Information Server 8.0.1
by seanc217
Thu Aug 06, 2009 8:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selection of which Database for metadata repository?
Replies: 7
Views: 5395

We have been running on an Oracle metadata repository ever since v8 was in beta. There have been no issues as far as corruption goes.
by seanc217
Mon Mar 23, 2009 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture Real Type
Replies: 2
Views: 2542

Yeah that's the way I was going. Thanks Ray.
by seanc217
Mon Mar 23, 2009 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture Real Type
Replies: 2
Views: 2542

Change Capture Real Type

Hi I am attempting to do change capture on SQL Server source into Oracle Target. The SQL Server has fields with type Real which gets imported into DataStage as type Float. When I run it through the change capture, I am getting differences even though the values are the same. Also it appears DataStag...
by seanc217
Fri Oct 17, 2008 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key stage in MPP system.
Replies: 1
Views: 1908

I have opened a ticket with support I will update this post when I get a resolution.

Thanks!
by seanc217
Fri Oct 17, 2008 8:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key stage in MPP system.
Replies: 1
Views: 1908

Surrogate key stage in MPP system.

Hi All, I am having an issue when running my job on a 2 node system. When I first ran the job it complained that it could not find the state file. I changed my config file to run on one node and it worked OK. I figured it was complaining because it could not see the state file on the other node. So ...
by seanc217
Thu Oct 02, 2008 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OS for DataStage 8
Replies: 8
Views: 3481

We ran on Windows originally when 7.5x came out. It ran OK, but I did run into some issues that were not easily resolved. One issue involved a transformer compiler bug with a parallel transformer that had alot of columns (500 or so). I think this is fixed now and I'm sure the code is more robust the...
by seanc217
Tue Sep 09, 2008 11:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Linux Red Hat v4 64 bit
Replies: 18
Views: 10033

Hi there, We have been running Red Hat AS 4 64 bit for some time with no issues. The one thing you have to change is the compiler and linker flag swithes if you are going to compile a transformer, you must set the -m32 flag. This will ensure that the c object code gets compiled in 32 bit mode instea...
by seanc217
Mon Jun 23, 2008 1:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key error
Replies: 5
Views: 4223

Surrogate key error

I have a job that is doing change capture on some data. New records get inserted and changes get updated and old records get expired. A typical type 2 dimension. There are 2 surrogate key stages in the job referencing the same file. When processing I get the following error in the job log: skey_cust...
by seanc217
Fri Jun 20, 2008 1:35 pm
Forum: IBM QualityStage
Topic: processing large resultsets
Replies: 5
Views: 3222

Good point. I was thinking the same thing.

Thanks!
by seanc217
Fri Jun 20, 2008 1:28 pm
Forum: IBM QualityStage
Topic: processing large resultsets
Replies: 5
Views: 3222

Good point. I was thinking the same thing.

Thanks!
by seanc217
Fri Jun 06, 2008 11:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting the total number or records from a dataset
Replies: 11
Views: 6671

OK Thanks!

I got it the command you have to use is:

orchadmin describe -d -l <your dataset file>

Worked great.

Thanks Again!
by seanc217
Fri Jun 06, 2008 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting the total number or records from a dataset
Replies: 11
Views: 6671

OK here's the output from orchadmin ll count but it seems to report record numbers in Kilobytes?? Kind of weird. Let me know if you would know how to figure out the total number of records. Many Thanks! Name: /loads/work/etl/outbound/datasets/cust_data_set.ds Version: ORCHESTRATE V8.0.1 DM Block For...