DSXchange

Hi, I am trying to use the FTP Enterprise Stage to read a file from the Remote Windows Server (Cloud) and save a local copy to the InfoSphere Server before we can process the file Job Design is FTP Stage --> Sequential File Stage In FTP Stage, I am using URI - ftpes ://xyz.cloudapp.net:2501/<foldern...

Hi All,

Is there a way to programatically find the following details for each job
(in each Env we have , DEV, QA and PROD)

Last Run Date
Compile Date
and any other info that might help us compare jobs between Env

We want to do House keeping before upgrading to a new Datastage Version

Thanks,
NV

Thanks Eric.

Hi All, We have the Work Load Management option available now where we can set the job priority. By default it is Medium. I see I can change this when I run a job from the Designer Client We plan to eventually use a script using dsjob to run the jobs. How can we incorporate work load management via ...

Thanks Chulett.
I am following that in context of TWT and I have no issues with the access/security related side of things..just that using the Netezza Sequence from within Datastage seems to be a problem.

Concurrency, No - I can create a separate State File for each dimension so only the associated job would access the corresponding Surrogate key and no other process would access that sequence at the same time But again is this a good practice from Datastage perspective, to have say 10 State Files, o...

It is a Datastage question as this needs to happen from the Netezza Connector stage Is using the Surrogate Key Generator a recommended approach to avoid this scenario of using a Netezza Sequence? My concern is since it File based (State File) and we could run the risk of file corruption and am also ...

Hi All, Netezza as Target Database Trying to design a job where I want to insert records to a target table from a staging table using the Netezza Connector Stage. As part of this I need to get the Next Value for a Sequence for every record and then load to the table. I found this article but how can...

Hi All, We migrated from 7.5.1. to 9.1 (All Server Jobs Only and a lot of Basic Routines) and No Job Design changes were made . The New Infosphere has better resources (more Memory, CPUs) than the old server on which we had the 7.5.1 Along with that we also upgraded SQL Server to 2012 from SQL Serve...

Thanks Paul.

I am going to test it in Dev but wanted to see if someone has already tested/used this scenario and if so it helps to get some insight on that

Hi, We create a Balanced Optimized job called job_BA from job called job_Original and then 1. If we change the job_Original, will Datastage ask me compile the job_BO (understanding the original job has changed) or I would need to run through the Optimize process again and save it as job_BO over writ...

Hi, We currently are starting a New Project and have all Tiers on the same server. 1. Can we have the Resource Disk and Resource ScratchDisk on a separate disk (on the same server) other than the Install Drive by altering the entries in the config file. The install drive is C: where as we want to us...

It does not work if use Domain None but the solution to this is to NOT PASS the Domain, User and Password to the dsjob command and it will use the credentials of the logged in user irrespective of type of Authentication, Credential mappings or LDAP

Using Authentication File is an option that I will end up using if nothing else works here. So In this case will I have do Credential Mapping for the Service Id in the Information Server even though we have AD? Also does this mean when we use dsjob we cannot leverage the Active Directory Integration?

Not using both the user and password also does not work and it prompts for both to be entered at execution from command line The -Domain NONE did not work either, may be due to Active Directory Integration. Get this Error ERROR: Failed to open project Last recorded error message = java.rmi.RemoteExc...