OK...I applied the hotfix successfully...is there something else I need to do...cause it's still prompting?

Carl,

I can't say thanks enough I have been loosing my mind over this extremely iritating thing.  I checked kb articles, guess I wasn't phrasing it correctly to find the error.

Any idea where the breaking point is?  How many rows are in the db2 table?

What is the query you are using to retrive the data?

I can potentially try to reproduce it...

What does mainframe db2 log indicate?...probably times out and can be modified for the id running the linked server.

One last thought be sure password is less than 8 Characters long..

Best practice says not to run as local system account and should have nothing to do with it. 

If you have the db2 connect client on the sql server you...

1) Verify the user name and password in the provider string

2) Verify the user name and password on the security context tab..for testing set it to "be made using this...

I got it!

Using Microsoft's OLE for DB2 driver...I created my ole provider connection string and tested it before proceeding.  The string I created...

After ten minutes I had to cancel the insert.  There is only one row in the source table.  Here is where I am at...

insert into DSNYTCP..MSQL.TEST_TABLE SELECT * FROM tempdb.dbo.TEST_TABLE

This...

I set up the linked server using the IBM driver as suggested and am able to do selects no problem...

Can you give an example of the insert to the linked...

BOL says  you can do an insert with openquery but doesn't go into how to..and haven't been able to dig up an example. 

Running the following says incorrect syntax and...

Thought I'd add some info before it was asked.  TESTING is the linked server using Microsoft OLE DB ODBC Driver

Here is the insert statement

INSERT INTO TESTING.DB2DSNY.MSQL.TEST_TABLE Values ('ABCDEFGH')

Table MSQL.TEST_TABLE is...