Migrating from 7.2 to 8.1

[Ross Mallett]

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?

[Philip Nelson]

Ross Mallett wrote:

>
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?

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

[Ross Mallett]

Philip Nelson wrote:

Ross Mallett wrote:

>>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?

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

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

[Ross Mallett]

Ross Mallett wrote:

>
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?

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?