DSXchange

ray.wurlod wrote:What are the permissions on /tmp ? ...

Here are the permissions on /tmp
drwxrwxrwt 8 root root 4096 Apr 10 15:13 tmp

Hi Guys, I am trying to configure a MYSQL ODBC connection using a mysql library ( libmyodbc3-3.51.23.so) that comes in the unix installation. After configuring the connection, I was able to connect to the database as dsadm. When I try to connect as some other user in dstage group. I get the followin...

The number doesn't matter, it was a bug from simply having it on that Arnd is worried about. Make sure it is off/disabled for this particular job and see if that helps. ... I did verify and there is no job level settings. The new project schedule seems to be running fine for almost 10 runs now. I h...

Do you have auto-purge set for this job in the director? If yes, that might be part of the problem. ... No, I dont have an auto-purge setting at job level. I have it set at the project level to purge logs older than 2 days. In effect I will be storing logs for 48 executions for every job. Do you th...

I have a server job(multiple instance) that runs every hour. It loads data for the first 2 runs and after that just starts and completes immediately without any errors (it does not even initiate the stages). Log has the start message, Env settings and then finish message. (just 3 lines in director) ...

Reboot of the server fixed the issue. Silly of me not to try it before posting here.

Is there a way to change the domain name in IBM Information server(IIS) installation? Here is the story... We installed IIS in a linux server and the name of the server was changed after the installation ( as it moved from LAN to a server location). I tried to change the new hostname in all the conf...

BITXOR() worked for me. Thanks Arnd.

Thanks for the response Arnd and Ray. I tired both the solutions and the values that I get are either 0 or 1. For example I tried encrypting and decrypting in DataStage itself 500 is the input value 55555 is the key used for encryption.. StgEncoded=(500 Or 55555) And (Not(500 And 55555)) (turns out ...

I have a requirement to decrypt a cipher text which was encrypted using an XOR function. I have to decrypt that string and load that value into an oracle table. I could not find a relevant function call or BASIC statement using which I can write a routine. Any help is much appreciated. I searched fo...

DB2 API stage does not support any reject links. If using DB2 Enterprise stage is an option for you, then you can use the upsert option with a reject link to catch the rejected records. Otherwise you have to parse the log for 'rejected' entries and abort the job. Then data verification should be don...

We are planning to migrate DataStage EE installation from IBM P655 servers to IBM P595 servers. Are you aware of any known issues with this p595 servers w.r.t DataStage EE? We are also planning to use the virtualization capabilities in these servers. If anyone had been involved in any such activity ...

We tried a POC with USS recently. You need to have a DataStage EE installed in an UNIX m/c in addition to the USS installation, for doing your development. The objective of the USS software is to enable parallel processing w.r.t to data available in the Mainframe servers. You will be getting very go...

Hello Ramesh, if you look at your column definitions for you file you will see a column titled "data contains terminators" - that will solve your problem; "terminators" are synonymous with what you call "ENTER" (which may be <CR><LF> or just <LF> depending on your syst...

Hi, you can handle this with two lookups to the target. 1st lookup: To ignore the duplicate records. have the first 3 columns of the target in the hash file. the constraint for the outgoing link shud be "Lookup is False" 1st lookup hash: 1110 1111 22222 1111 2222 33333 2nd lookup: To findo...