Search found 2886 matches

by qt_ky
Wed Apr 04, 2012 8:51 pm
Forum: General
Topic: SOX requirements for InfoSphere 8.1 Application
Replies: 11
Views: 3363

At some point in the future that "no support" statement may have to be rescinded. They are definitely looking at password policies for the internal registry. "In the next major release" [after 8.7] according to the IBM tech note below. I have to assume this means in the internal...
by qt_ky
Wed Apr 04, 2012 8:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Meaning of elements used in DSN for SQL Server 2008 R2
Replies: 17
Views: 12566

Jayanto wrote:how do I determine my ODBC Driver's version?
See this coincidentally titled IBM tech note:

How can I find the DataDirect ODBC driver version used by DataStage jobs?

http://www-01.ibm.com/support/docview.w ... wg21574486
by qt_ky
Wed Apr 04, 2012 6:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Key change column
Replies: 4
Views: 2347

Try it out and let us know what you find.
by qt_ky
Wed Apr 04, 2012 5:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem of data trunction
Replies: 11
Views: 3674

Re: Problem of data trunction

absatyam wrote:need your urgent help

Please help!
Where's the quote about the cost of providing urgent help?? I thought you guys had that thing automated... :shock:
by qt_ky
Wed Apr 04, 2012 5:15 pm
Forum: General
Topic: Capture Rejected records info(from log)
Replies: 2
Views: 983

The dsjob command can perform similar functions to the API functions Ray outlined.
by qt_ky
Wed Apr 04, 2012 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Size limit on sequential file stage
Replies: 3
Views: 1719

2 MB is rather small. Are you sure the limit should not be 2 GB instead? If you're having trouble adding a timestamp on the reject link, you could insert a Transformer stage before the Lookup stage, and derive the timestamp there. If the row is rejected, then it already has the timestamp. If it's no...
by qt_ky
Wed Apr 04, 2012 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage func Converting From UTC to Estern Standard Time
Replies: 2
Views: 4570

Automatic time zone changes are not built-in to any parallel job functions. If you know the time zone offset, then you can use either of these built-in parallel jobs functions:

TimeOffsetByComponents()

TimestampOffsetByComponents()
by qt_ky
Wed Apr 04, 2012 1:55 pm
Forum: General
Topic: Fact vs Dimension
Replies: 10
Views: 3300

Search on Data Warehouse. If you're not doing DW work, then it will not apply so much...
by qt_ky
Wed Apr 04, 2012 1:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Want to copy only 700M out of 2.6Billion records
Replies: 9
Views: 2731

Try using the Head stage or the Sample stage. They operate in parallel, so any record count you give is per node.
by qt_ky
Tue Apr 03, 2012 6:59 pm
Forum: General
Topic: import error from 8 version to 7.5
Replies: 10
Views: 3164

I'm not going to say it's impossible, but it's still not going to be supported (same answer as before).
by qt_ky
Tue Apr 03, 2012 6:57 pm
Forum: General
Topic: Period or dot in Invocation ID
Replies: 3
Views: 1424

I think extra dots will confuse it, as the dot is a delimiter. If you're set on using a dot, check with IBM. You may be able to request it as an enhancement for a future release. If other people are not requesting the same thing though, then I don't think it's too likely to be added.
by qt_ky
Tue Apr 03, 2012 6:46 pm
Forum: General
Topic: Command utility in datastage administrator grayed out
Replies: 5
Views: 1763

Go into the web console as an admin and grant the DataStage Admin role to the developer ID. Then it will no longer be a developer-only ID. You should be able to use the Command button after that.
by qt_ky
Tue Apr 03, 2012 2:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage-Where Clause
Replies: 7
Views: 2582

See if this IBM tech note is at all related. It mentions a similar problem with the Oracle Connector stage. JR40765: ORACLE CONNECTOR: THE ROWID ROUND ROBIN PARTITIONING INSERTS THE RIGHT PARENTHESIS AT THE WRONG PLACE. http://www-01.ibm.com/support/docview.wss?uid=swg1JR40765&myns=swgimgmt&...
by qt_ky
Tue Apr 03, 2012 2:22 pm
Forum: General
Topic: Command utility in datastage administrator grayed out
Replies: 5
Views: 1763

Do you mean to say it works for an admin ID like dsadm or isadmin but not a regular developer ID?
by qt_ky
Tue Apr 03, 2012 12:35 pm
Forum: General
Topic: Segmentation Fault on installing Information Server
Replies: 4
Views: 1274

New IBM tech note regarding the Redhat memcpy() fix:

http://www-01.ibm.com/support/docview.w ... JPZ&mync=E