Search found 2886 matches

by qt_ky
Fri Apr 27, 2012 8:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with SQL STATE 40003
Replies: 7
Views: 3621

by qt_ky
Fri Apr 27, 2012 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Balance I/O load
Replies: 1
Views: 928

I'm not sure what your question is without a specific example of a problem you are facing. What is the job design, the number of records, and the time it takes? One thing you can start with is adding the APT_RECORD_COUNTS environment variable to your job (set it to True), compile, run, and examine t...
by qt_ky
Fri Apr 27, 2012 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fasttrack istool import error
Replies: 4
Views: 2240

Please try the variations I suggested above as well as leaving out the = sign according to the syntax given rather than the example from the doc. I'm curious what you will find out. When I got it to work it was by using '' only at the end, as in the 2nd example from the docs. I had also added the -v...
by qt_ky
Fri Apr 27, 2012 8:04 am
Forum: General
Topic: oconv(data(), "DW") = 4 .. reads as Thursday?!
Replies: 6
Views: 1743

You're welcome. Ah, our good friend NLS strikes once again...
by qt_ky
Fri Apr 27, 2012 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Please help of the job design
Replies: 6
Views: 2346

Good catch, Craig. Venkat, don't change the data. First understand the data and take appropriate action. :wink:
by qt_ky
Fri Apr 27, 2012 7:11 am
Forum:
Topic: Where to stick Business Glossary logo file?
Replies: 7
Views: 3446

This tech note also gives the warning about putting the logo image under WAS and how it will be lost when applying patches: IBM InfoSphere Business Glossary custom logo file displays as a blank white box with the words client logo Arvind, I noticed on my server that the "build" subdirector...
by qt_ky
Fri Apr 27, 2012 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Facing performance issue for DB2 database connectivity
Replies: 9
Views: 2769

I don't have DB2 DPF or EEE (whatever they call it these days...) but I connected to it on a few former projects and had one client that wanted to use it with DB2 on AIX and DataStage on Linux, and they told me this after migrating off of DataStage on AIX! I also used to help folks locate the hard-t...
by qt_ky
Thu Apr 26, 2012 9:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increase in number of instances of the job increases time.
Replies: 7
Views: 2394

The topic link below highlights many options. If you go the unix command route, then I suggest you work locally with your unix admin for help on those...

viewtopic.php?t=144892
by qt_ky
Thu Apr 26, 2012 9:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Slow running job
Replies: 15
Views: 13548

Craig, thanks for pointing that out. I went back and checked and did not see any requirement for commit count of 1. I think I was getting mixed up and it's just the array size needing to be 1. Connectivity Guides say things like "Setting the array size to 1 might affect performance." Let's...
by qt_ky
Thu Apr 26, 2012 8:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fasttrack istool import error
Replies: 4
Views: 2240

I ran into that same error before also. In my case I was trying to use istool on the server and found out that for fasttrack, you have to run istool from the client tier (it's in the Admin Guide; it just didn't jump out at me). You might also try adding :9080 (or your port number) on the domain opti...
by qt_ky
Thu Apr 26, 2012 7:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
Replies: 22
Views: 22733

Again, I'm coming from a Unix background here. The SQL Server Native Wire Protocol driver is there in the DataDirect 6.1 file that's bundled with 8.7 whereas it does not exist in the DD 6.0 file bundled with 8.5 (not sure why). I checked the DD web site and it's like you said listed as a new feature...
by qt_ky
Thu Apr 26, 2012 7:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Slow running job
Replies: 15
Views: 13548

Hopefully I didn't just make that up... Let me do some searching.
by qt_ky
Thu Apr 26, 2012 6:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Facing performance issue for DB2 database connectivity
Replies: 9
Views: 2769

I was referring to the old method having DB2 DPF nodes part of the setup. You can certainly still do parallel DB2 operations without that extent of setup.
by qt_ky
Thu Apr 26, 2012 5:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: type conversion problem in transformer
Replies: 3
Views: 1266

Make sure the abc data type is also timestamp.
by qt_ky
Thu Apr 26, 2012 5:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: calling function for every input record into oci stage
Replies: 2
Views: 719

Try adding the closing paren. ) and removing ; semicolons.