DSXchange

We use a standard template in the Description box in our stage properties, but when a job is closed and reopened all of the CR/LF characters appear to have been removed, and the text is collapsed into a single block. However, those characters are still present - if you copy the text, and paste it in...

IIS 9.1. I run the exports using ISM from my laptop. My laptop only has the clients installed.

I've noticed that the isx size reduction only happens when using the DataStage Designer compiler. I had an isx that had steadily grown to 28 MB and did not reduce in size at all after running the multi-job compile abut a dozen times. So I opened the isx using 7-zip and determined which job was the l...

I've noticed that when I export jobs into an isx file I can get radically different file sizes based on how much the jobs have been edited and how many times they've been compiled. One recent example is the isx for a product that consists of about 30 jobs. The isx was originally around 2MB, but afte...

Thank you for taking the time to respond, Roy. If the aforementioned method is overkill then what would be the better way? Our prior dev environment project arrangement consisted of a project for dev work and another project for 'unit testing'. I'd like to expand this to include a separate 'baseline...

I've recently finished building our new DataStage 9.1 environment and have been designing a deployment process that incorporates Subversion source control via ISM. The issue I've encountered is that the functionality relating to source control is disabled for all of the developer accounts. The detai...

The server where this problem was occurring has now been decommissioned so this issue is no longer relevant. I know that under normal circumstances I would mark an answer, but since the issue more or less vanished with the server, what should I do?

Thanks for the tip; that definitely moved me in the right direction. The installation log contained only two "SEVERE" messages; both contain an Eclipse stack trace and indicate that the installer was attempting to connect to the metadata repo using the DataStage server name instead of the ...

When I try to open the Information Server Manager (ISM) the splash screen appears and disappears but the application never opens. An error log file is created each time I try to open ISM. I wasn't sure if it was preferred to paste the contents inline or if it's better to attach the whole file afterw...

According to the documentation, Wave Number is "An internal number used when the job is run." Based on the results of a Google search http://www.google.com/search?q= DataStage+Wave+internal+number this number is used to refer to the log entries of a particular run of the selected job (wave...

Based on the rules you've given, if there's even a single letter present then the name is valid. If that's the case then I'd do what chulett mentioned, but remove non-alphabetic characters, and if the length is still > 0 then it's a valid name. Also, it might be a good idea to run NullToEmpty() and ...

Some of our data was apparently coming from web forms with free-form text fields that weren't being sanitized. A shell script was used to parse the file and locate extraneous newlines beforehand. The same approach could be used in this case to locate errant quote characters.

Our solution was taken from the following URL: http://pic.dhe.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/rtrb_dsaccess4.html Per those instructions we created two dwords on each of our cluster hosts: a separate dword is required for sqljdbc.dll and sql...

I'm having the same error while installing IIS 9.1 in our QA environment. There was no such issue with the installation in the dev environment. Both environments are using Windows Server 2008 Enterprise R2 (x64) as the host OS, and SQL Server 2008 Enterprise r2 (x64) as the metadata repository. The ...