DSXchange

sAM, If it makes you feel any better, some people would do the upgrade the way you wound up doing it anyway. I never really liked upgrades so I always installed then imported the projects. Then one contract insisted on an upgrade and DS 5.x went to DS 7.x on Unix and it worked. So now I am OK with U...

Hi, I wanted to finish this thread for others who might be trying to do this. To connect an Oracle instance to SE Datastage you need to define Oracle home and you have to have lib32 first (thank you Ray) in the lib path. The lib path is slightly tricky. I'm pretty sure you have to use LD_LIBRARY_PAT...

Hi, Just to finish this thread and add some PeopleSoft Datastage knowledge to the site if it isn't already there. If you get a good Peoplesoft Datastage install and you want to add new development id's they have to be added to this group in /etc/group: psoftupda::108:psoftprd,psoftup2,psoftupd,jones...

Hi, I tried to search this. I got a hit on HP needing SHLIB definition for Oracle connectivity in dsenv. But does Solaris need an Oracle pointer added to SHLIB_PATH or does all it need is: export ORACLE_HOME=/opt/oracle/product/10.2.0 ? You guys are fantastic. We are working on getting our company t...

Criag,

Thanks. The FAQ link was helpful. Clearly Unix secuity matters a lot. This was very helpful, thanks.

... Flash

Hi, Some of the clarifications that were requested. I am going to throw more fuel in the fire. This is not a vanilla Datastage install. I have been told that the user running the Datastage is something like pssoftds8 not dsadm or root. I am pretty sure it is an SE only install, not a joint EE/SE ins...

ms sql can have data types that odbc doesn't support. Check the declaration of the column that is giving you a problem. If you can change the column declaration in ms sql to a more generic type like char or decimal and it's not destructive to try it, try that. I actually thought all access to ms sql...

Hi, I know this may be a dumb question but I'm working in a large environment where the Datastage unix admin install group feels they're done, the security group wants to be told what do do, and the Dev group (me and others) has little access to the Sun box to see or repair what might not be working...

Hi, you probably know this and I don't know if it's an option in your environment, but if you just want the problem to go away, stop and restart your Datastage server and the lock will go away. I am pretty sure locks happen for the current running Datastage instance

Hi, We have "Create File" checked on a hash file and we are getting that spurious "Unable to create file /ibdd/..." message that is a know Datastage problem. We are running DS 7.5 and HP/UX 11.11. I re-run the job a few minutes later with no code changes and the job runs. We are ...

Carter, Thank you. That was the sort of experience we were looking for. I actually find Autosys messaging about the step that was run a little terse. For any sophisticated type of Datastage error message the Operators would have to look in Director. Or maybe you could write something that would send...

Amos,

Yes, we are using Sequences to define our main flows and are then calling it with Autosys so I think we are doing similiar things. Thanks for the response.

Flash Gordon

Hi, I imagine we have a few people out there using Autosys to run Datastage jobs. We are at an architectural decision point and wanted to see if anyone else had some thoughts. We have some fairly complex flows, some with 100's of Datastage jobs. We have used DS Sequences to chunk some of our flows d...

Hi, We had the ability to take Ascential Datastage Table Definitions and turn them into excel spreadsheets before but we have lost the recipe. Is there some kind of shareware that does this, or a sequence of things you do in Datastage and then on the excel side. The output excel file would have the ...

Hi, I had a chance to work on the Peoplesoft DW conversion of Informatica last February 04 at an Ascential client. The conversion tool got 90% of the job done but it's the other 10% that kills you. Ascential had one of their best Datastage guys in there plus myself and Peoplesoft employees, and it w...