Search found 12 matches

by Hongqing Tang
Thu Jul 01, 2010 3:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage initiated unix processes
Replies: 3
Views: 1763

It depends on which user is used to start DataStage. We start DataStage services using user: dsadm. Does that mean a)the processes spin out by the PXEngine will be under dsadm? b) the unix scripts processes that are called by a sequence or a job's before or after routine are also owned/under by dsa...
by Hongqing Tang
Thu Jul 01, 2010 1:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage initiated unix processes
Replies: 3
Views: 1763

DataStage initiated unix processes

I think that by default, when datastage start or initiate the unix porcesses, they are under dsadm no matter who runs the job. How about the unix scripts that are invoked by a datastge job or sequence? Do they also belong to dsadm? How do we change this default so that those processes and the unix s...
by Hongqing Tang
Mon Jun 21, 2010 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concurrent running job use 95% CPU but less than 30% memory
Replies: 1
Views: 1162

Concurrent running job use 95% CPU but less than 30% memory

I am running jobs concurrently. At one point of time, there are 36 jobs running concurrently. We saw the CPU shot up to 95% utilization but memory only used less than 30%. Those are just read and then write out jobs, should not consume a lot of CPUs. Is there a set of environment parameters that we ...
by Hongqing Tang
Tue Jun 15, 2010 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job does not see the change in Shared container
Replies: 8
Views: 2873

Yes, I am sure I am the only user at this time.
by Hongqing Tang
Tue Jun 15, 2010 9:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job does not see the change in Shared container
Replies: 8
Views: 2873

That issue started last week. Today, I went back and tried it again, I am having the same issue.
by Hongqing Tang
Tue Jun 15, 2010 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job does not see the change in Shared container
Replies: 8
Views: 2873

Job does not see the change in Shared container

I have a job that uses the shared container. It passed the compile, then I found an error in the shared container while test run it. So, I fixed the error in the shared container and recompile the job. But when I click "Run", it gives a warning msg says that the shared container was modifi...
by Hongqing Tang
Sun Jun 06, 2010 6:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass UNIX environment variable to DataStage jobs
Replies: 13
Views: 14420

Second log message of any job will have a complete dump of all environment variables in effect when the job ran.

I checked the log earlier, and SCHEMA_NAME is not one of the environment variables listed there.
by Hongqing Tang
Sun Jun 06, 2010 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass UNIX environment variable to DataStage jobs
Replies: 13
Views: 14420

I added the environment variable SCHEMA_NAME in my home dir's .profile file. But value USA is still not passed to the DS job. Am I missing anything else?
by Hongqing Tang
Sun Jun 06, 2010 2:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass UNIX environment variable to DataStage jobs
Replies: 13
Views: 14420

I used set in my home and root directory and it displayed all of the environment variables. I do not see the environment variable SCHEMA_NAME which I thought was there with value USA.
by Hongqing Tang
Sun Jun 06, 2010 1:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass UNIX environment variable to DataStage jobs
Replies: 13
Views: 14420

I am not sure. How do you check that? How do you set it up in the shell if they are not there? Thanks so much in advance.
by Hongqing Tang
Sun Jun 06, 2010 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass UNIX environment variable to DataStage jobs
Replies: 13
Views: 14420

I followed what you said here, added SCHEMA_NAME environment variable in Administrator and set its value as $ENV. Then in the DS job, I added the variable by picking it up from the "Add Environment Variable...". Then I changed its default $ENV to $PROJDEF. Compile and run the job. I wrote ...
by Hongqing Tang
Sat Jun 05, 2010 10:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass UNIX environment variable to DataStage jobs
Replies: 13
Views: 14420

Pass UNIX environment variable to DataStage jobs

I want to pass UNIX environment variables to datastage job. IN the job property, I entered the UNIX envrionment variable's name $SCHEMA_NAME, this is a unix environment variable with a value USA. In the parameter's default value, I entered $ENV. When I run the job, I expect that the parameter will g...