DSXchange

Can someone post a sample apt config file that uses multiple pools? I heard it was smart to design your parallel job with a parameter as to which config file to use at runtime. So I made a couple of copies of the default config (1-node version, 2 node version, 3 node version, etc..) but on the stage...

IBM Support finally got back after a couple of exchanges of emails and job designs. Here's the final email from them that has the solution to the problem as well as an additional link to a tech article that others may be interested in: http://www-01.ibm.com/support/docview.wss?uid=swg21683476 IBM Up...

ShaneMuir - I tried your suggestion to move the clob to be the last column in the table and still no luck. As an experiment I tried casting the clob to varchar knowing that the data would be truncated and i get this error when I do: PL_class_info..ODBC_Connector_1: Exception thrown from CC_AccessorF...

Upon resetting the job, this is the only additional info that is given: From previous run DataStage Job 1482 Phantom 30504 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc Abnormal termination of DataStage. Fault type is 6. Layer type is BASIC run machine. Fault...

I'm trying to move a CLOB from MS SQL 2000 connecting through ODBC and if I place a NULL in the transformer everything works. When I map the clob, then i get "Abnormal termination of stage my_job..Transformer_1 detected" and that's it. Nothing else to go on that I can see to google on. The...

This is what I have discovered. Unless there is a SECOND component to the string data the AM/PM is ignored. Also in ordered to get it to work, I had to convert from a 12 hr time to a 24 hour time. So final steps to resolution, concat 00 seconds to my string, and then convert to 24hrs. Very annoying ...

With the new Oracle Connectors, I can't see the Insert/Update generated statement like I could with the old OCI stage. How do I know how to get a timestamp string from a CSV file to match the format mask? Here's the format of the timestamp string YYYY-MM-DD hh:mi AM The column is an Oracle DATE but ...

Is there a way at run-time (inside a user variable activity, etc..), to get the Value File Name value from a parameter set? I build my parameter set values with a DEV/TEST/PROD version of each parameter. This makes it simple when I run to select which values to use. I would like to get this "ta...

I had a similar but not exactly similar issue, maybe it'll help. I had to grab data from various FoxPro files using the ODBC connection. This client was really weird and instead of storing all their data from one facility in one file, they made a file for each department. So their file structure loo...

I wanted to just post what seems to have resolved the issue. In the C:\IBM\InformationServer11.3\ASBNode\eclipse\plugins\com.ibm.iis.client\iis.client.site.properties file, adding this line to the bottom so far has resolved this this issue: # To increase client timeout to 180 minutes com.ibm.iis.htt...

I'm using IS Server Manager to build a package for later sending to a prod environment. After defining a package, randomly when I build I get a timeout exception. Also I don't know if this is related to my timeouts, sometimes when a package is sent to my prod environment (using the istools.sh utilit...

I'm wrong you're right. I had to restructure some of the steps that I was doing because the END has to connect directly to the START loop. I had some other steps in between the end and the start, so even though logically it would have looped fine, DS wants a direct link between these stages.

Has anyone used two looping activities (one nested within another) on one sequence? I'm thinking I'm running into a limitation that a sequence that it only knows how to handle one loop on the canvas and if I need a second nested loop to create a second sequence.

What the biggest piece of CRAP! You have to be a Suite Component Admin in order to integrate source control! IBM has some serious work to do with their role management. It's not too far fetched of an idea to want to specify someone as Suite Component User and have them be able to periodically commit...

I'm having a hard time trying to understand what you are asking? Can you parameterized a file name? - Yes. In the sequential stage properties you can reference a job parameter so when the job runs DS will dynamically look for the value of the parameter as the name of the file to load. Can you insert...