Search found 28 matches

by ersunnys
Sat Jun 26, 2010 9:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Default OMD.XML.DIR
Replies: 10
Views: 6188

Hi Sunny, I've got news from my AIX Admin that you can indeed change this location but the folder should be in the same server. Now, If we make a new folder in the same server then the space issue will still be there. So my suggestion is to increase the space in your server and keep the default val...
by ersunnys
Sat Jun 26, 2010 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Default OMD.XML.DIR
Replies: 10
Views: 6188

chulett wrote:Not everything is configurable and I've never seen anything documenting how to change that. However, doesn't mean it isn't, hopefully someone knows something regarding this.
thanks craig for hope... :)
by ersunnys
Sat Jun 26, 2010 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file modification
Replies: 10
Views: 3353

kduke wrote:
Sainath.Srinivasan wrote:Datasets store their 'build configuration file' with them.
In what version? Because we have had issues with this in v7.5.2 ...
I hope in all parallel versions!! otherwise concept of Datasets in Datastage is waste...
by ersunnys
Sat Jun 26, 2010 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Default OMD.XML.DIR
Replies: 10
Views: 6188

Thanks Guys for replies.. Also curious why you feel any need to move it elsewhere. Space? I have a typical scenario, and yes the reason of moving the files from DS installation folder to some other folder is Space and I want to keep these files in some other UNIX File Set... from my understanding, t...
by ersunnys
Sat Jun 26, 2010 12:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Default OMD.XML.DIR
Replies: 10
Views: 6188

Change Default OMD.XML.DIR

Hi, By Default, OMD.XML.DIR is set to "/opt/IBM/InformationServer/ASBNode/conf/etc/XmlFiles". Is there any way to change the value of this variable, so that we can generate OMD Xml files into some other folder then "/opt/IBM/InformationServer/ASBNode/conf/etc/XmlFiles" ?? I reall...
by ersunnys
Sun Feb 28, 2010 6:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Config file issue with orchadmin
Replies: 5
Views: 3488

Hey, Dataset in Datastage keeps the cofig file information which is used when we write the Dataset. You do not use external APT_CONFIG file while reading a Dataset, Datastage use the config file information which got stored in it while writing, so at time of reading it creates a temporary config fil...
by ersunnys
Thu Jul 17, 2008 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Again Join Stage (Data Error)
Replies: 8
Views: 1845

Looks like a partition problem to me. What partition have you used? Use hash partition on key fields on both links to the join. Hi, NIce to get a reply from you.. Thanks.. ya its partition problem only, i have tried using Hash partition then iam getting 2records out of the 3matching records... Any ...
by ersunnys
Sun Jun 29, 2008 4:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in Reading DECIMAL fields
Replies: 5
Views: 2701

Re: Problem in Reading DECIMAL fields

If data in input field is 1234 ------->> view data o/p 1234 data in input field is 34 --------->> data getting rejected .Because i am getting 2 spaces in the input data . Mate, It seems like the source file you are getting is having wrong format of data. In fixed width, if you have a decimal field ...
by ersunnys
Thu Sep 14, 2006 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executing Two dos commands in Execute Command Activity
Replies: 12
Views: 4706

sqlplus -s userid/passwd@domain && select * from tab; I don't think you can even execute this complete statement from the command line too. What exactly are you trying to do from the execute command stage? Do you want to run a script or run some sql commands? I am able to run print "se...
by ersunnys
Thu Sep 14, 2006 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executing Two dos commands in Execute Command Activity
Replies: 12
Views: 4706

Try this In the Command box sqlplus -s and in the Parameters box #userid#/#passwd#@#domain# && select * from tab; This is not working, output is Executed: sqlplus -s userid/passwd@domain && select * from tab; Reply=0 Output from command ====> SQL*Plus: Release 8.1.7.0.0 - Production...
by ersunnys
Thu Sep 14, 2006 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executing Two dos commands in Execute Command Activity
Replies: 12
Views: 4706

move #Old_Pdath#\#Old_Filename# #New_Path#\#New_Filename##Date_parameter# ... I am trying to give my JOBS parameters to connect to sqlplus, but it is not connecting... can anyone help me in this... i am using... print "select * from tab;" | sqlplus -s #userid#/#passwd#@#domain# please cor...
by ersunnys
Wed Sep 13, 2006 1:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fetch job Stats
Replies: 8
Views: 3374

Most of what I have in EtlStats is using dsjob -report XML. I can also retrieve old job runs by reading the job log directly. There is no other way to get an old run. The API only deals with the last run. There is a last run for every job instance though. If you autopurge your logs then that option...