DSXchange

ray.wurlod wrote:How many nodes in your DataStage parallel execution configuration file? ...

Dear ray,

2 nodes specified in the configuration file.

1 node on datastage server
and the other on db2 server.

This configuration is same between production and development servers.

Thanks and regards,
Mike--

On the input link to your DB2/UDB stage, Hash partition the data on all key fields. Dear Mahadev, I've explored that option, but sadly the problem is still there. =( The job seems to be on a standstill... Does anyone know about the multiple threads per session id invoked by the DB2/UDB stage? Could...

The stage itself will not cause any deadlocks; it is your design that will. Check that the partitioning is key-based so that the same key can not occur on multiple partitions. ... Dear Ray, Sorry, I don't quite understand that. What does it mean by same key across multiple partition? Do I check fro...

Dear all, How is everyone? =) I was hoping to be able to obtain some clarification here. I am currently facing a predicament not encountered previously. I have a simple job that does this: Dataset-> Surrogatekey generator-> Db2/UDB stage. In my Db2/UDB stage I am selecting 'Write: Append' as the ins...

Search would be a good idea. There are very few reasons why an operating system file (in this case RT_CONFIG20857) can not be created. In summary they are (a) permissions, (b) disk full, (c) disk quota exceeded or (d) limit on number of subdirectories in a directory exceeded. Do you really have mor...

Just found out that the project server doesn't have px installed -_-||

ArndW, thanks for the reply

hi all, im having this warning message while trying to run a px job. hope u guys can help give me some idea on how to solve it, thanks node_tes001: Warning: the following libraries failed to load: "V1S0_Pd01_trns_DataCleaning": Could not load "V1S0_Pd01_trns_DataCleaning": Could ...

Hello, We are facing log in problem when connecting to DS V8.1 server from client tools (Designer/Director..). Error log is copied below. Any suggestion is appreciated. Thanks, javax.security.auth.login.LoginException: Could not connect to server [<server name>] on port [9080]. at com.ascential.acs....

Previously I had a job that keeps aborting with the error message: href_StgExtIdSiMap,0: Could not map table file "/home/dsadm/Ascential/DataStage/Datasets/lookuptable.20080109.ymetadc (size 1133689184 bytes)": Not enough space Error finalizing / saving table /entis/IMS/hash/lkpfsPStgExtId...

Hi everyone, I'm encountered a problem when i opening the job from designer. The error is as below: Record J\17375\V0S262 in file DS_JOBOBJECTS does not exist I did not do any import or export job and this job had been completed on yesterday and it is work fined but when i opened the job again today...

It seems pretty unlikely. Because I've only run this simple job: Source file -> transformer -> Target file. Total records processed: 1 And still I am getting said error. I've made sure no other jobs were running in the system and also monitored the disk space while the job's at it. Still the error's...

I don't think it's space issue. As you can see the specs below: Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/hd4 0.25 0.22 12% 2371 5% / /dev/hd2 5.00 2.97 41% 44385 6% /usr /dev/hd9var 0.50 0.42 16% 557 1% /var /dev/hd3 5.00 4.47 11% 748 1% /tmp /dev/hd1 0.50 0.23 54% 187 1% /home /...

I developed a simple job few days ago. the job is run successfully without any abortion and warning in few days ago but when i run it today. I feel shock because my job is aborted. :?: My job design is looked like in this below : DB2--> Transformer -> Lookup File set Below is abortion error that i g...

Hi all, Thanks again for feedback. I should only use the fields that are necessary. In any case, I know following is my server specs: ETL Development Server ( 10.0.110.8 ) Spec. Operating System : AIX 5.3 CPU : 2 CPU Memory : 6 GB Disk Space : 100 GB For etldev1 user Set File Size = unlimit Any tips...

Hi everyone, Thanks very much for the feedback. =) Apologize for absence I was away. There's some development in the front of testing between lookup and join performance. I noticed that yes, lookup does consume a lot of memory if the number of records is excessive, which results in abortion. I notic...