Sure you dont have an Order By on the second query ?

If you need to try something, you could add -c to both bcp commands, to make ascii data files. My suspects are Unicode or Collation differences.

In further desperation you...

I agree with previous replies, it sounds like more trouble than its worth. Especially considering the point that you probably have to drop referential constraints as well.

Nevertheless, lets not...

99.1% Cache Hit Ratio sounds good, in itself. The data being requested is found already in memory 99.1% of the time.

Given the high cache hit ratio, perhaps high disk...

You can disable the constraint checking on a table before deleting from it, then re-enable afterwards:

ALTER TABLE tablename NOCHECK CONSTRAINT constraintname

--or-- ALTER TABLE tablename NOCHECK CONSTRAINT ALL

-- "CHECK" to enable.

Bind variable generally will not be 'peeked into' in deriving the query plan, and generally you cannot do much about it. If they are parameters of a stored procedure...

Hex00 is BCP's way of storing a blank string. It does this because it uses an empty field for Null.

(It could be argued that it would have...

I'm not sure, you might need

RAISERROR .. WITH LOG

Although this needs admin privs. (If attempted by a nonadmin, you get an error for that, which is logged anyway, but...

Select t1a.id1, t1a.date1 as fromdate, 
    t1b.date1 as uptodate, t2.date2 as innerdate
  from Table1 T1A
    inner join Table1 T1B
    ...

or just

Object_ID('TempDb..#Temp') is not NULL

(which I found in a previous posting but I cannot find now to attribute it, sorry)

I have seen something like the "parameter sniffing" in my own experimentation. When you run in QA its probably something like

exec procedurename 'paramval1', 'paramval2'

In other words the literally-supplied values...

You might need to specify the server as well.

osql -S servername -E

isqlW.exe (QueryAnalyser) is a good option too -- you can create a Configuration file from within a normal interactive...

It is good to be reminded just what RELATIONAL means.

XML is an example. Your piece of XML will itself have columns and rows, so it is logically a table...

Just a general idea, in such mysterious situations, I would trace Everything, because you really dont have a prime suspect. Try to do it when the database is quiet,...

Maybe your biggest mistake was your title, it should be something like "First Impression of DB2 as a Newbie".

If the question is "Worthy Competitor?", if you evaluate DB2 on Windows,...