Search found 15603 matches

by ArndW
Fri Jul 31, 2009 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 8.1 IBM InformationServer first time login error
Replies: 20
Views: 9353

I've not used LDAP so cannot help you there. If you don't click on the "share User registry" and enter the UNIX userid and password (correctly), then add a user and also assign the roles to that user then you should be able to login (if other things are wrong the error message will reflect...
by ArndW
Fri Jul 31, 2009 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commit interval in oracle enterprise stage
Replies: 25
Views: 7105

The main effect is that your database rollback space will need to be large enough to contain the whole transaction. If it isn't the job will abort.
by ArndW
Fri Jul 31, 2009 9:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSX output and Generated OSH
Replies: 9
Views: 3304

I have seen "artefacts" before as well but can't recall the cause. I think at the time a "force compile" from the designer somehow worked for us.
by ArndW
Fri Jul 31, 2009 8:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 8.1 IBM InformationServer first time login error
Replies: 20
Views: 9353

Did you do Administration -> Domain Management -> DataStage Credentials, select and open that up and enter the default DataStage and Qualitystage credentials?
by ArndW
Fri Jul 31, 2009 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rcp doesn't work correctly
Replies: 11
Views: 2914

Just as in the first post, this has nothing to do with rcp. You will need to define a transformation (either in a transform or modify stage) where you tell the job how to convert your timestamp to a date.
by ArndW
Fri Jul 31, 2009 8:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi-Instance "Missing Parameters"
Replies: 13
Views: 8421

That looks like the 8.1 version where the data is in the XMETA and not in hashed files. I think that it won't work at any version prior to 8.1
by ArndW
Fri Jul 31, 2009 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi-Instance "Missing Parameters"
Replies: 13
Views: 8421

I submitted an eCase for this problem about a year ago but don't have the case number available at the moment. I seem to recall this having come up here at DSXchange a couple of weeks ago and I have a vague feeling that someone mentioned that it might be fixed at 8.1 but "vague" and "...
by ArndW
Fri Jul 31, 2009 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: identify
Replies: 6
Views: 1167

The question sounds very much like an interview question. Perhaps it was the way it the question was formulated. Also, once you actually implement a sequential file stage in a test job the answer becomes evident.
Would it be possible to ask the question in a different way?
by ArndW
Fri Jul 31, 2009 6:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: limit
Replies: 2
Views: 902

If by "pipelines" you mean "nodes" then there is no hard limit but the ones imposed by the capacity of the system you are working on. If you have a 2 CPU system with little physical memory then a configuration file with 128 nodes is going to cause the job to abort due to lack of ...
by ArndW
Fri Jul 31, 2009 5:56 am
Forum: General
Topic: understanding Rountine
Replies: 10
Views: 2141

Karthik, could you explain for us at a high level what you want to do; perhaps there is a better approach to use. I, for one, don't understand your wishes and therefore gave up on adding to the thread. You have a routine that processes one file and returns one value. Then you asked about multiple fi...
by ArndW
Fri Jul 31, 2009 4:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Character  converted to A
Replies: 7
Views: 3010

That parameter doesn't have to do with NLS; if your uvconfig has no NLS entries then any character conversion is not being done by DataStage. Read your Oracle and write to a text file, then look at the value in the text file (not with View Data in DataStage) to see if has been altered. What is your ...
by ArndW
Fri Jul 31, 2009 4:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job cannot get right parameter when scheduled
Replies: 9
Views: 2225

It is the userid that is being used that caused the error, and in your case the real error occurred before the ODBC error; perhaps the user didn't have enough access to those files required for an ODBC connection (odbc.ini for example).
by ArndW
Fri Jul 31, 2009 4:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue in counting the rows
Replies: 14
Views: 4614

What about "head -c 1 MyTextFile" to get just the first character of the file? You can use

Code: Select all

sed '$d' < MyFile > TempFile ; mv TempFile MyFile
to remove the last line from a file.
by ArndW
Fri Jul 31, 2009 4:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi-Instance "Missing Parameters"
Replies: 13
Views: 8421

I have seen issues with concurrently running multi-instantiated jobs that occur sporadically. The cause was that there were auto-purge settings enabled for the jobs in question. If you do have auto-purge enabled then try turning it off to see if that might be causing your problems.