DSXchange

Thanks.

Do an exact search for dssearch here. That will dig up many conversations on this topic.

Or just read the annotation.

However, in a way it doesn't matter. The answer is to ensure your data can fit into the target column. Details still might help, though.

Wouldn't you be able to re-negotiate that via a link?

You'd be best served by taking this to your official support provider, I would imagine. There are limits on the size of bmp files but it can depend on a number of factors including the bpp (bits per pixel) setting and the amount of free memory available. Out of curiousity, does the workstation you u...

Your posted link actually answers this question:

"How do I change the default location of the PROJECTS directory?"

Are they in fact one in the same?

VAS issue? For those of us who are not DB2 fluent, can you expand on that a little?

Next time please spell words like that all the way out. We're not people you are texting and it's not a 140 character tweet you are sending so take the extra second and type all of the letters. The people who are trying to help you will be forever grateful.

So... is "-ve" supposed to mean "negative"?

1. Inserts should be at least equal to the updates but could be higher.
2. No, they should be inserted.

Sure, using redirection via the ">" or ">>" operators.

http://en.wikipedia.org/wiki/Redirection_%28Unix%29

Not directly. You might want to check if dsjob -jobinfo includes that, if so you could loop thru all projects/jobs to fetch the list.

May I ask... why?

As Andrew said , can I have any of the algorithms to compact my ADDRESS_ID field size ....... I just need to give it a try and check whether it enhances the performance of the job. It won't. Your issue isn't about the size of the join key. I already have the partition and sort done IDENTICALLY on b...

You need to have a chat with your DBA about Oracle, bulk loads and indexes. That should help you understand what the various options mean and which you should use. If you don't rebuild the indexes, they can be left in an UNUSABLE state. And as I've noted, even if you do attempt a rebuild, a unique i...