DSXchange

Thanks Felix. I manually ran the sql's as mentioned by you.. did not face any issues. Thanks a lot, your post really helped. Cheers!

Hello Experts, I need to purge DSODB tables sustaining the records for the last 3 months or so. I am following the below technote by IBM http://www-01.ibm.com/support/docview.wss?uid=swg21659783 My question was that has anybody purged their logs before using this method or by any method other than t...

Hey guys,

I just asked my DB2 DBA for a application snap, in that i can see the connections being made from the compute nodes only(that are in Executing state).

Also, on "VIEW Data", connections are made from the head node

Ashsish/electajay, Let me explain further, suppose i am using a DB2 DB in my job. I am connecting to db server using port say 65432. Now when i do a netstat -a|grep 65432 on both head nodes and compute node, i can see connections established. So i was wondering where exactly are the connections made...

Hello Experts, Just had a query. Suppose my jobs runs on a head node and a compute node. Now if i am using a database in the job, will the network sockets for the database be opened from the head node or the compute node? Currently i am seeing sockets opened for both head node and compute node. i.e....

Hello Experts, Head node: prodhn01 Compute node: prodcn01 My job is meant to run on the above head node and the compute node. Sometimes i am getting this error: APT_PMaddrInfoFor(): getaddrinfo(host = prodcn01, port = ) failed with error -3 - Temporary failure in name resolution: node prodcn01 canno...

Hey Paul, I am confused now whats actually causing the issue. Earlier i was thinking that sequencer.sh was causing problems. We were using execute command activity stage to trigger sequencer.sh. But just yesterday another job got hung. but in this case a script was getting called via execute command...

Yes i did.

Its 4.3.3

Paul, This is assured that SSh is enabled for all compute nodes. Also the JOBDIR is shared and the user id has RW permissions. I am waiting for the next time this issue occurs. Had a chat with IBM, they asked to notice the following: 1. check if any hung sockets are present on the head node netstat ...

Paul, sequencer.sh is running non stop and its pid is active. It should ideally run for 4-5 seconds as we see for other jobs. In sequencer.sh, DynamicGrid.sh is sourced. And sleep 5... its parent id is sequencer.sh JAVAPATH is not being mesed around with. And no process related to the job is running...

Yes user remains the same. Now i am able to view data too. I dont know the reason why i wasnt able to earlier, the old cataloging was picked up when i was trying to view data.

Yes project level parameters are getting passed to both... For view data, i even hardcoded the DBNAME, username and pass in the connector stage. Still the same issue.

Thanks Paul for reviewing this. Here are the answers to your questions. The job is hanging here: Starting Job seq_DL_MA_PF_USER Environment variable settings: seq_DL_MA_PF_USER: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH seq_DL_MA_PF_USER..JobControl (@Coordinator): Sta...

Hello Experts, I have DB2 connector stage. Earlier i was running into an issue while running the job. Error: SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001 I checked this error and changed the db2 cataloging, AUTHENTICATION from SER...