DSXchange

Here is the issue: DataStage allows you to run the DB2 LOAD command with full knowledge that tables can go into a check pending state because of the command. Yet, apparently DataStage does not provide a solution to this common issue. There should be a simple method of running a set integrity command...

Hi, I am getting some peculiar error when i try to access db2 table after loading using odbc stage. The error like this "operation not allowed for reason code "1" on table" This happens not for all jobs, only for few jobs. after checking set integrity on table, i can access the ...

The Resolution:
1) Export the data out of the version control project.
2) Create a new project
3) Initialize it as a version control project
4) Import the data from the export in step 1)
5) Restore all APM_*.* files from a backup copy of the filesystem

Hello,

I have been desiginated to ask the following question:

Does the Datastage Message Handler in Director work on Server Job logs?

Sorry if the answer is simple, but I am not a DS programmer, but apparently have to ask the questions.

So far nothing has worked. I've followed all their instructions for two different resolutions. A am waiting for a third option...

I had initially tried that by entering a project that didn't exist. It had no effect. So I tried to select an existing project that wasn't a VC project. I got caught in a loop where I couldn't change the project back to VERSION. I have IBM telling me that there is a problem with either what he is ca...

A good try, but it didn't work. But I did turn my personal project into a VC (VietCong?) project. If I go into DataStage Manager I can see all of the jobs and such in the VERSION version control database. I can run processes against them in the Admin tool. There is a disconnect between the gui and t...

I went on vacation and when I came back I found that the Projects Manager discovered a new and unique way to promote jobs into production that included him renaming jobs on the fly and ending up with jobs in the production project with the version number attached (^1-7) which is illegal. I ended up ...

go to the admin tool and execute DS.CHECKER against the specific project.

ray.wurlod wrote:That is essentially what I suggested. :D ...

Cool! Thank you! :D

You DO want write permission on group. You DO want different groups for different projects, and you want to make sure that the two developers are only in the right group. In dsenv and the users' p ... Ratz, I only have standard access to the form so your message was cut off. Each developer has his ...

From Datastage Administrator you can set up the roles like "Developer", "Operator" etc. Log into the administartor and click on the project you have to change permissions, then Properties->Permissions. Yes, I it setup that way. The problem is the developers fall into one securit...

Greetings! I have a couple of ETL Developers that are apparently stepping on each others projects. Developer A wants to make sure Developer B can look at his jobs, but not modify them unless it is exported from Developer A's project into Developer B's project. The directory level security on the ind...

The IBM official response:
Once a job finishes, the files in the /tmp are not required. You should have no problem purging them after 3 days.

Yes, it is specific to the setting of TMPDIR. Sorry for any confusion. In my environment, the variable TMPDIR is set to /worktmp. /worktmp is used buy processes other than datastage. I am not worried about any files that get staged there because someone chose the directory set for their temporary/wo...