DSXchange

Hi, Best Practice question? If the Oracle database connected to Datstage is recycled, should you always recycle Datastage after the database comes back up? I know it works not to restart Datastage after Oracle is recycled but does that create stale oracle/odbc handles that cause obscure problems lat...

Hi, I read the good postings on SQLExecDirect, they gave me some good things to try, but I'm still not fixing our problem. High level bits - our ODBC against Oracle 10g is working, I can import metadata. When we try execute an Oracle command with SQLExecDirect in a "Before" routine, it fai...

Hi, I believe I have something important to add to this discussion of netstat processes blocking Datastage from coming up. There are cases where phantom processes can keep Datastage from releasing the dsrpc port/socket. In this case the netstat process below hung for 11+ hours. $ netstat -a|grep dsr...

Hi, If cff stage is adding an extra row with null values I found a way below to remove it. This is what I found worked. Remember that nulls for a fixed column input file are different than for delimited data. The field has width, even it if is filled with binary zeroes. The trick that keeps that las...

Ross, I tried to reply to your posting earlier but the site failed. Thank you for the groups suggestion, it was a command I didn't know existed. With a telnet login, groups said I was in the needed datastage group. I think the problem here is the Windows Datastage gui is using some c++ routine to au...

Craig, I decided I wanted this bad enough that I wrote a parm testing job. This is straight unix, no autosys. Your ideas abouts quotes and backslash ran the jobs but did not substitue the parameters. This is close to all possible permutations for this problem: myserv:/ps1/psoftts8/Ascential/DataStag...

a person reading this might ask "Why do you want to do this". My answer would be that 95% of the time you want to use the environment variable value, but 5% of the time you want to override that value at run time.

Flash

Ray/Craig, We are using autosys here. When we try to say -param $myparam=2007-04-15 autosys subsitutes '' for $myparam because he can't find $myparam in his env. Maybe there are some ways around this but they got too painful. We found an answer to this that I want to share. We found that if in the s...

Ray/Craig, We are using autosys here. When we try to say -param $myparam=2007-04-15 autosys subsitutes '' for $myparam because he can't find $myparam in his env. Maybe there are some ways around this but they got too painful. We found an answer to this that I want to share. We found that if in the s...

Craig, I'm having problems. At first I was doing a date parameter and there were dashes in it and I thought that was my problem. So I switched it to a straight character parameter and I am still having the problems. Error -3 getting information for parameter 'EPMONEOPERATORID' Status code = -3 DSJE_...

Hi, Are you allowed to override a "Add Environment Variable" parameter with a dsjob -param xx=...? I was reading all the DSJE_BADPARAM discussion and it seemed like the answer might be "NO". Almost all our parameters are $PROJDEF but we would like to override this one at runtime....

Ok Ray, I was just hoping you'd give me some hints. I have a great deal of faith in your knowledge of all things Datastage and Unix. It's just perplexing. On any other box, if I add the userid to the dsadm group, they can use datastage and save jobs, even if they don't have a primary or secondary gr...

Hi, Our large organization is using a new Unix password authentication called VAS. With VAS you have no entry you can see in /etc/passwd. VAS uses windows authentication to find the password - single uid/pw. This VAS id allows me to logon to putty on the machine. I got my userid added to the equival...

Hi, Yesterday I found out about dssh through search on dsxchange. This is very useful to us because we have a "locked" dsadm id (you can only su) and we need to do as much as possible in tty mode. I use dssh through putty connected to a sun box. Certain help commands in dssh seem to expect...

Nimusage, I'm curious. Your Datastage server failed completely but you still had the Unix versions of your project. That's what happened to us but I can't figure out why. You reinstall and have your old project. Is that what happened to you. I want to encourage you to get a Premium membership. I got...