DSXchange

<Individual> <Name> <Name Location="First">Bob</Name> <Name Location="Middle">Alan</Name> <Name Location="Last">Smith</Name> </Name> </Individual> Using this example, how would you code the XML output column definitions so that I can get First, Middle, and Last into sep...

Wanted to let everyone here know that I think we've found the issue causing our frequent "unable to open" file errors. IBM Support did a hardware analysis and found that we have Information Server installed on a SAN configured with OCFS2 file system. We have a shared SAN between two cluste...

So frustrating. I think our changes may have helped reduce the number of error occurrances, but over the weekend proves it's not 100% resolved Job Issue #1 DW_ctrlDWLoadResetStagingData..JobControl (fatal error from DSRunJob): Job control fatal error (-99) (DSRunJob) Failed to open RT_STATUS573 file...

Received useful help from IBM Support this morning. There's a utility that will suggest the recommended memory values dsadm@dsserv01:/> $DSHOME/bin/shmtest -f $DSHOME/uvconfig Recommended attach values Dmemoff = 0x7ff30b664000 Pmemoff = 0x7ff30d4c8000 Cmemoff = 0x7ff30d4cc000 Nmemoff = 0x7ff30d6cd00...

I think we may have fixed the "not runnable job" error, but will need to give it several days to be 100% sure. The initial results are postive! The issue seemed to be with ulimit. Our jobs are running as "dsadm" and when adding a before job subroutine "ulimit -a" to one...

Yes, the uvconfig parameters on the right side are how they exist right now The MFILES parameter was 250 a couple days ago when the "process id failed" error I posted above occurred. I then bumped that up to 500. Then last night got the "not a runnable job" error which has occurr...

Sometimes when resetting the control job, it provides more "from previous run" messages. For example, <controljobname> ..JobControl (fatal error from DSAttachJob): Job control fatal error (-12) (DSOpenJob) Cannot open job <jobname> . - not a runnable job Attempting to Cleanup after ABORT r...

Hello, Getting continuous errors in our nightly batch DataStage 8.5 server job processing. The errors come from job control server trying to call other server jobs. In job logs I've seen "Process Id Failed", "Cannot open file RT_STATUS###", "Cannot open job <jobname> . - not...

Thanks, the istool export works and will use that going forward. Unfortunately, the istools export format isn't readable like the *.dsx format. I like using the *.dsx project export like a code repository to "find things". Guess I need to learn other ways to do this in 8.5, does the metada...

Just completed a migration from 7.5 Windows to 8.5 Linux. In the 7.5 Windows environment, we had both Server and Client installed and were able to schedule the dscmdexport command to run nightly. I now realize this was a Client command function and I don't see a Client installation available for Lin...

This issue just occurred to me today. Restarting the client machine didn't help and had to resort to reinstalling the IIS client and now it's resolved. Also, this error was only happening if I was logged into Windows. I could log into the Windows client machine as somebody else, log into DataStage a...

IBM support saved the day! We went through a few different registry key entries, and this set worked for Windows 2008. Once these are added, I set FixedFontName=Courier and FixedFontSize=10 and it's easy to read. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\InformationServer\DataStage Client\Client T...

Hi Ernie, this is Greg Brown from Helzberg Diamonds. Thank you for taking time to respond! Your response leads to another thought I was having. So based on what you're saying it's possible to read the giant XML file once and have several post-transform outputs where the XML is seperated into relatio...

We're faced with a first time challenge to process an XML that is rather complex. Curious what's the best way to handle processing this type of XML file? For example, if the XML looked like this... <Transaction Type="SALE"> <TranNo>1001</TranNo> <Cashier>12345</Cashier> <Date>2011-04-23</D...

@rameshrr3 - I tried changing that registry entry and it changed the font of just about EVERY windows text in DataStage, except in text/coding windows :( ....but I think you're on to something, just need to find the correct registry entry, possibly? Support also suggested adding these registy keys, ...