DSXchange

@PaulVL,

In Windows,instead used Control Panel >System >Advanced system settings >Environment Variables .I created new entries by copying variables from existing server .So Finally its working :D

After doing some research found that required components are missing For #1 &#2 ,Installed Visual Studio /C++ components For #3 ,Installed Oracle client on the same datastage server and placed tnsnames.ora file on the network location. With above changes the issues resolved .Thank you for all re...

Thanks PaulVL for the response ..I have created PMRs for these issues and waiting on the support responses.

Hi, Recently ,we have added a new datastage iis server to existing WAS server .While testing the jobs on this server I am getting following errors. 1.Compile job window ..When error occurred while compiling the job,I clicked on More button ..I am not getting any response after this point..Is there a...

Hi, I have been observing issue since couple of months while loading the dsxchange web page ..It spins the wheel for ever :D and finally gives me following error. phpBB:Critical error - could not connect to the database I had to be patient and try couple of times to load the page .If I am lucky enou...

Hi Kumar, I am using hash partition in sort stages right after reading from DB stages .Then I am maintaining the "same"partition through out the down stream flow. One more update regarding CPU ,upon closely monitoring the Operations console,While this job running it is reaching more than 8...

Hi, Currently I am deleting individual data sets using batch(bat) file using below code.It works well .. @ECHO OFF C:\IBM\InformationServer\Server\PXEngine\bin\orchadmin rm datasetfolder\dataset1.ds C:\IBM\InformationServer\Server\PXEngine\bin\orchadmin rm datasetfolder\dataset2.ds Similarly ,I woul...

For this I need to look into basics for coding routine for this requirement from scratch .

@chulett,UCDI ..Thank you for the input This time different script having issue like above.I am using these vb scripts for basic file operations, renaming and deletion of data sets and text files . One example here ,the script is replacing strings from filename. 'rename filename which are ending wit...

@ray I can't see the premium content at this moment .I renewed couple of days ago but still not activated yet :o I did little testing with running same job with different nodes..so having more number of nodes always improve the performance means job run efficiently? main_program: Startup time, 5:16;...

For the first question , I am using environment variable $APT_SORT_INSERTION_CHECK_ONLY = False to verify the sorted data .Does this serve the purpose to eliminate tsort operator ? Second one, It was a suggestion by DS admin couple years ago to use only single node since then I haven't revised the ...

Hi, I am using parameter set "Ps_count" to populate text file "param.txt" with count . I did compile the job before running. Please suggest me the steps to troubleshoot the issue with parameter set. ***Ps_count Parameters tab** count (parameter name) Value tab param.txt | "w...

Hi, In our project the logs become huge and have more than 100 jobs needs to be cleared logs on them through director ..Is there any efficient way do at project level instead of job by job ?Going forward I set less interval for auto-purge at project level. select job >clear Log >Immediate purge Than...

Hi Members, I need your suggestions/inputs related to IBM products assessment that we are currently doing in our project. We are looking for products that would be helpful for the business needs in terms of technical / functional / IT Governance and Data Management. What are the items to consider? P...

Hi Everyone, I have a "IBM Info Sphere Information Server salesforce Pack" extract job While testing in higher environments ,I got below fatal messages.The same extract job ran fine in dev and required configuration is already in place for all the environments .(upon checking with DS admin...