Search found 202 matches

by pavankvk
Thu Oct 01, 2015 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Drop Unmatched Fields - ODBC
Replies: 3
Views: 3240

tbat doesnt help. I can change to warning but the records dont get inserted
by pavankvk
Thu Oct 01, 2015 12:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Drop Unmatched Fields - ODBC
Replies: 3
Views: 3240

Drop Unmatched Fields - ODBC

Hi, I ran into this issue with the ODBC stage. We use a single job to read different schema files and using RCP load it to different target tables( truncate and insert). Some of the schema files may have additional columns that are not needed in the target table. On 8.1(our earlier version), the ODB...
by pavankvk
Thu Sep 10, 2015 10:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

Every place I have seen has either started on Linux or UNIX and stayed there, or they started on Windows then moved to Linux or UNIX. In any case, have you tried toggling the APT_LUTCREATE_NO_MMAP setting? I agree. just tried this setting. didn't help. Lookup_0,0: Could not alloc memory for table f...
by pavankvk
Thu Sep 10, 2015 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

IS_11.3.1_WIN_64_ML is the download we used
by pavankvk
Thu Sep 10, 2015 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

We have the 64 bit version of the Infopshere suite. the download itself has 64 in the name as i indicated earlier. Not sure if osh/parallel engine is still 32 bit. Not sure how IBM markets it as 64 BIT.
by pavankvk
Wed Sep 09, 2015 8:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

You mean, going to windows from unix is a bad choice in first place?
by pavankvk
Wed Sep 09, 2015 6:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

on linux, this is our ulimit setting.Does windows even have an option to change similar settings? i see SFU has been discontunued. ours is a windows 2012 server, i dont see services for unix in the registryu ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling prio...
by pavankvk
Wed Sep 09, 2015 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

PaulVL wrote:also, what is the size of the mount for your TMPDIR defined at your project level?
its about 500gb, pointed to same location as other datasets.
by pavankvk
Wed Sep 09, 2015 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

DataStage comes in 32bit and 64bit flavors depending on platform, so it's not "Windows v. Linux" but rather "32bit v. 64bit" as you noted. And I'm kind of surprised there isn't a 64bit Windows version ... That is what i thought, it should come in 32 and 64 bit. infact the downlo...
by pavankvk
Wed Sep 09, 2015 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup stage Windows vs Linux
Replies: 15
Views: 8124

Lookup stage Windows vs Linux

Hi, We have many jobs that use lookup stages and we are currently porting them from Linux(ds 8.1) to Windows(11.3.1). We ran into the classic lookup problem Could not map table file, not enough space. While these jobs are running fine with much larger volumes in Production environment(8.1, Linux), t...
by pavankvk
Wed Sep 02, 2015 5:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage behavior/bug in 11.3?
Replies: 5
Views: 2702

the update is now we are not sure if its a bug in 11.3 or 8.1.. the particular field on right input of join is not nullable(the value is hard coded), on output link its nullable, 8.1 behavior is it sets it to NULL for unmatched records. this i think should be the idal behavior because the column is ...
by pavankvk
Wed Sep 02, 2015 12:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage behavior/bug in 11.3?
Replies: 5
Views: 2702

Forgot to mention that fields are defined as Nullable, so values should be set to NULL
by pavankvk
Wed Sep 02, 2015 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage behavior/bug in 11.3?
Replies: 5
Views: 2702

Join stage behavior/bug in 11.3?

Hi We are migrating to 11.3, and noticed a bug/strange behavior for the join stage. Scenario is a left outer join, unmatched records from the right stream should have NULL values after the join. in 8.X the behavior is as expected, its set to NULL and we can trap those records with a IsNull. In 11.3,...
by pavankvk
Mon Aug 24, 2015 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel routines - Bestway to convert strings to char*
Replies: 2
Views: 1585

Parallel routines - Bestway to convert strings to char*

Hi We have some parallel routines that are porting from linux to windows. some of the routines, planning to rewrite in c++ and use string objects. Howerver datastage native is char* what is the best way to convert string to char* and vice versa? if a malloc is done to copy string to char* and return...
by pavankvk
Thu Aug 20, 2015 8:04 pm
Forum: General
Topic: DS 11.3 Windows AD Authentication
Replies: 3
Views: 2749

It's in the Planning, Installation and Configuration Guide. Basically you have to configure the global security settings in WebSphere Application Server, providing details about the primary Ac ... Thanks ray, i did that. How do we set up windows AD users of our choice in Infosphere and authenticate...