Search found 520 matches
- Thu Nov 03, 2011 5:20 pm
- Forum: General
- Topic: Two Information Servers at once
- Replies: 6
- Views: 3837
We were going to do this while at USAA and ultimately decided to stand up new hardware. The installation documentation actually discusses how to do this and I believe the installer also asks for an instance name so it was designed to do just what you want. I know of a few customers who have gone thi...
- Tue Nov 01, 2011 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while using orchadmin utility
- Replies: 9
- Views: 9448
Hi , I set the value of APT_CONFIG_FILE variable to apt file for the project. I also sourced the dsenv file.I followed the same process while working in Datastage 8.1 environment and that worked perfectly there.I am facing the problem in the 8.5 environment only which is newly set up.Is there any p...
- Fri Jul 01, 2011 6:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion of Time from EST to GMT.
- Replies: 12
- Views: 9453
I am going to go out on a limb here and suggest that you do not write a BASIC routine to do this. You will have essentially tied yourself to either a UV stage in a sequencer or implementing a BASIC transform in a parallel job which is generally (won't say never, but want to) a good idea. If you writ...
- Fri Jul 01, 2011 6:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborted 'glibc detected' error
- Replies: 11
- Views: 11175
When er execute the command rpm -qa | grep glibc following is the output. compat-glibc-2.3.4-2.26 glibc-common-2.5-49.el5_5.7 compat-glibc-headers-2.3.4-2.26 compat-glibc-2.3.4-2.26 glibc-devel-2.5-49.el5_5.7 glibc-2.5-49.el5_5.7 glibc-devel-2.5-49.el5_5.7 glibc-headers-2.5-49.el5_5.7 glibc-2.5-49....
- Thu Jun 30, 2011 4:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion of Time from EST to GMT.
- Replies: 12
- Views: 9453
I would start with looking at the Unix TZ environment variable and its usage. Then to avoid having all of your times GMT (exported say in your dsenv) I would write a simple C routine that you could call from your job to return a gmt timestamp when you need it. I have included an example that may/may...
- Thu Jun 30, 2011 2:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset is occupying more space than file
- Replies: 4
- Views: 4537
Well, your datasets are large likely because the PX framework treats bounded fields as fixed width for performance reasons. No amount of trimming etc... will do away with that. This also holds true for how data are moved between operators - fixed width, again, for performance reasons. There is an en...
- Thu Jun 30, 2011 2:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborted 'glibc detected' error
- Replies: 11
- Views: 11175
On a related note - I would definitely make sure that all of your columns have defined lengths. I know that there is talk that the framework is more efficient if you do not define lengths, but that is only true if the length is greater than 100. Anything less than 100 should be defined especially da...
- Thu Jun 30, 2011 1:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborted 'glibc detected' error
- Replies: 11
- Views: 11175
- Wed Jun 29, 2011 8:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing special characters,spaces,nulls in multiple columns
- Replies: 23
- Views: 34175
- Wed Jun 29, 2011 7:38 am
- Forum: General
- Topic: DS8.5 Post Installation Steps
- Replies: 5
- Views: 4046
What is the URL you entered that causing you received the HTTP 404 not found? Good point - should be - protocol//host:port/ibm/iis/console where protocol is either HTTP or HTTPS, port is either 9080 or 9443 (ssl) Both 9080 and 9443 are default values so if you happened to have changed them then use...
- Tue Jun 28, 2011 8:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Operator Generation Failed
- Replies: 2
- Views: 2620
- Tue Jun 28, 2011 8:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing special characters,spaces,nulls in multiple columns
- Replies: 23
- Views: 34175
- Tue Jun 28, 2011 2:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ranking
- Replies: 6
- Views: 5523
Craig has pretty much set you on a course to handle the logic problem. Now, in my opinion, it is up to you to determine how to best handle it in DS. Think of it in terms of any programming language where you will have variables to hold results as you loop through a set of data. This is what you will...
- Tue Jun 28, 2011 2:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing special characters,spaces,nulls in multiple columns
- Replies: 23
- Views: 34175
Maybe something like -
or the tr command will work, awk as well, but you will likely have to call a sub process
Again, there are a lot of ways to do this - this is just one of many.
Code: Select all
sed "s/[^a-z|0-9]//g;" file1 > file2
Again, there are a lot of ways to do this - this is just one of many.
- Tue Jun 28, 2011 2:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Auto or Custom partitioning.
- Replies: 2
- Views: 2236
Yes, Auto should work just fine - the framework will put in sorts and repartitioners according to what you have defined as the key. It will almost always do this as a hash even for a single key that is entirely numeric (where modulus might have been a better choice). Auto will also honor what you ha...