DSXchange

Then your duplicate ID values are in your source data or you are sending them multiple times:

INSERT/UPDATE INVALID; INDEX 1 RESTRICTS COLUMNS WITH SAME VALUES. DB2INST1.PERSON_ID_INFO

You are trying to insert duplicate data into your target table.

10 matches with an exact search for "project is currently locked", including yours.

You must source the dsenv file first to setup the environment this command needs:
Then execute your command.

ds_search2008 wrote:Len to be honest its very much hard to understand the code under job properties dialog box. Could you please suggest me a simple option to trace the problem.

He didn't ask you to understand it, he ask you to post it so *he* can see what was generated.

The Sequencer mode is set to "Any" only. I have check it. However I'm receiving SeqActJobs..JobControl (@Coordinator): Note: Sequencer 'Sequencer' was entered, but never exited log message. As noted, the only time you should get a message like that is for an "All" Sequencer wher...

For a nice discussion from the ever knowledgeable Ernie Ostic on the caveats of buffering, read here.

There's no "correct combination" and I've never seen a formula that worked worked. Page size? Pages per extent? Where does it say every DWH table has "64 pages per extent"? All that seems very specific to a particular environment / setup and not something that would work in a gen...

You suppose? Earlier when I asked you said "I didn't set any buffer alloaction". Check and be sure. If it is (and I'd really have to question why) run your tests again with it off as suggested.

What have you tried?

Or that.

Is there an easy way to get this list out into a file?

One way would be using COMO, found a small discussion on its use here:

viewtopic.php?t=100948

Ah... but can you switch back and forth at will?

Craig - Thanks for that suggestion. I don't see any project-level variables that appear to address that issue, but I'll check with IBM to see if there might be one that can be set in the User Defined section that would take care of it. I'll post any results that I find here. Found this, let us know...

OK, your call. Please mark the post as Resolved using the button at the top of the screen then. Thanks!