Did you ever get this working? I'm up against the same issue. However, the Microsoft version of DB2 driver won't work because I'm on standard.

Thanks,

Dave

Great, thanks for your help.

OK, I think I got it. There reason for the fragmentation is because there is now primary key.

I hope these are the correct definitions.

USE [itiserver]

GO

/****** Object: Table [hsi].[keygroupdata104] Script Date: 09/17/2009 10:44:00 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [hsi].[keygroupdata104](

[itemnum] [int] NULL,

[kg115]...

I'll take a look at it. Maybe I can run it in the morning. If the results are bad, I'll check the fragmantation.

Thanks, Matt. I've already taken the update stat out of the maintenance plan. However, I want to research the cause of it.

Thanks again.

Dave

The tables should be because the update stats runs each night.

Some of the tables are fairly big I'm assuming if it a 25 gb database. I am assuming it is doing a full scan. It doesn't state what type of...

I rather not try in that it my affect our production environment.

There are no more than 200 tables. I believe what is causing the update stat to take unusually long time to run stems from the "auto update stats" and "create...

Yes, both are selected to "yes" in the options for that database.

It had me scratching my head too. They are being performed throught the maintenance plan. I have it set to update user databases "all existing stats". I'll check if update...

I'll stick with converting it to a varchar first then a date field.

Thank for your guys help.

Dave

Thanks, Lynn. That's the answer I was looking for--just wanted to be sure.:-)

Yes, that worked and is slightly better. But is there anyway to convert from int to datetime?

Thanks,

Dave:-)