Migrating from 7.2 to 8.1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ross Mallett - 04 Jun 2007 06:40 GMT

I have a job that inserts thousands of LOBs into a table.

Under a UDB 7.2 client, it runs in four minutes.

The same job, running against the same UDB 8.2 server, takes over 30
minutes on the 8.2 client.

Does anybody have any ideas about what is going wrong?

Reply to this Message

Philip Nelson - 04 Jun 2007 13:28 GMT

> I have a job that inserts thousands of LOBs into a table.
>
[quoted text clipped - 4 lines]
>
> Does anybody have any ideas about what is going wrong?

Did you run all the binds from the V8.2 client ?

It could be you are spending a lot of time needlessly autobinding catalog
packages.

Have you gathered a statement level event monitor to see if it gives you any
clue to whether there could be a problem. If it thinks that the
statement is taking very little time to process then it probably is
something "external" to the inserts themselves, such as the autobinds I
mentioned earlier.

Phil

Reply to this Message

Ross Mallett - 05 Jun 2007 07:26 GMT

>>I have a job that inserts thousands of LOBs into a table.
>>
[quoted text clipped - 17 lines]
>
> Phil

The db2cli.lst and db2ubind.lst have been bound.

The monitor says that the INSERT statements have an average execution
time of 15 milliseconds. So their total time is not excessive.

Anything else that could be "external" to the inserts?

Ross

Reply to this Message

Ross Mallett - 07 Jun 2007 02:39 GMT

> I have a job that inserts thousands of LOBs into a table.
>
[quoted text clipped - 4 lines]
>
> Does anybody have any ideas about what is going wrong?

It seems that the 7.2 client compresses (or truncates) the CLOB, whereas
the 8.2 client is sending all 16 MB per LOB across to the server.

Anyone have any ideas?

Reply to this Message