DSXchange

Hi, What is the easiest way of building an input file with 1 record and retrieve many records from database(ODBC). example: want to extract many transactions records within given period of an input intermediary-number Thanks Jessica Nguyen IMPORTANT NOTICE This communication including any file attac...

Hi, all, We plan to leap from DStage v4.1 clear up to v6.0.1 (Win2000 environment). Clearly, the leap consists of 2 parts ... tweaking and regression testing our jobs under the new version, and then leveraging all sorts of new and wonderful 6.x features as we see fit. Part B is in our court to asses...

Something I have found using sorts on DS6.0 on Win2K is that sometimes, and as yet I cant fathom what the criteria is, I have to output the data from the sort to a passive stage, sequential file, prior to using it in an active stage, transform. I did get a hanging of sort jobs but once I landed the ...

We have five DataStage client software installed, I test each of them, and this problem happened with all of them. xiong -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Tuesday, 06 May, 2003 11:04 To: datastage-users@oliver.com Subject: Re: failed to export by category.....

Make sure that your temp space (the file system referred to in the UVTEMP configuration parameter) isnt becoming full. This can disrupt sorting. You might also investigate - in conjunction with your support provider - increasing the configuration parameters SPINTRIES and SPINSLEEP, as these affect t...

I have seen this failure to export jobs by category before, DS 5.2.1. It was resolved when the client software was re-installed as part of addressing a different problem, so I cant tell you what the actual cause was! ----- Original Message ----- From: Xiong Li Date: Tue, 06 May 2003 10:52:28 +1200 T...

Hi, Kenneth I investigated this issue again, and found some abnormal things may help us figure out this issue. While I export from the dev project, if I chose "By individual component" or just simply export whole project, there is not any problem. However, if I chose "By category" option, then while...

This is a topic for an orphaned message.

Looks like you are missing a value for PROJ_INTEGRITY. -craig Gisela Marques wrote on 05/05/2003 08:39:04 AM: > /usr/Ardent/DataStage/DSEngine/bin/dsjob -run -jobstatus -param > DSN_SINC=migprod -param USER_SIDQM=idqm -param PASS_SIDQM=iiddqq - > param USER_SIDQ=idq -param PASS_SIDQ=idq -param > USE...

As far as Im aware, nothing has changed. The system admins claim that no user rights or anything like that has changed. However, I now tried to run the same job in a completely new project and that works. Could I have damaged the project settings somehow? Everything else seems to work fine. -----Oor...

Dahlfors M. (Martin) wrote: > Hi All > > Environment: Datastage 6.0 on AIX > > Im having a problem with the Sort stage. Jobs using Sort just stopped > working all of a sudden and seem to be hanging without giving an > error message. > > This is the error message I get when I press the stop-button wh...

Hi All Environment: Datastage 6.0 on AIX Im having a problem with the Sort stage. Jobs using Sort just stopped working all of a sudden and seem to be hanging without giving an error message. This is the error message I get when I press the stop-button when a job is hanging: MySortTesting..Transforme...

Can you expand your command, to see that all environment variables are correctly resolved into a valid dsjob command? For example: echo $DSJ -server $SERVER -user $USER -password $PASSWORD -run -jobstatus $PARAM $PROJ $JOB > $LOGOUT 2> $LOGERR Also, make sure that the arguments are in the correct or...

What version of DataStage on which platform? Failure to compile imported jobs usually is a permissions issue if youre on Unix. Since you state its a clean install, I would guess that you havent put the "umask" entry into the services startup script ds.rc. Putting umask 007 eliminates almost all perm...

Hi, there We have just installed a new DataStage engine, tried to import whole project from another DataStage engine but failed. Also, we cannot compiled DataStage job in the new server. it issued a error message: "Error writing to RT_CONFIGxxx". Does anybody know what casuse this problem? Thanks in...