DB2掉到了第一档？ [英] DB2 dropped into first gear?

问题描述

在AIX 4.3.3上运行的Java Batch作业与另一个运行相比

运行DB2 6.1的RS6000上周耗时15分钟。本周

它需要6个多小时！这份工作使用了4张表，每张表超过5,000,000行

。

我被告知在批处理作业中没有任何改变，而其他

比约每晚10K新记录插入表中的几张表中，DB中没有任何变化。 （我被告知）


问题是;查询，插入和更新工作

可以在一天内从15分钟到6小时吗？我不这么认为......


已经重新排列了所有表格，在数据库上运行DB2DART

没有运气。


任何想法在哪里看？所有smit diags在操作系统上显示ok和

硬件。

网络似乎很好。


谢谢 -


TS

A Java Batch job running on AIX 4.3.3 talking to another
RS6000 running DB2 6.1 was taking 15 min last week. This week
it is taking over 6 hours! The job uses 4 tables that have
over 5,000,000 rows each.
I am told nothing has changed in the batch job and other
than about 10K new records inserted each night into a few of
the tables, nothing has changed in the DB. (I am told)

The questions is; Can a query, insert and update job
go from 15mins to 6hrs in one day? I don''t think so...

Have reorged all the tables, ran DB2DART on the DB with
no luck.

Any ideas where to look? All smit diags show ok on OS and
hardware.
network seems fine.

Thanks --

TS

推荐答案

您是否考虑过网络？是否进行了网络更改？

如何将两台机器分开？由于某些原因，本周流量模式是否可能不同？


Al Murry写道：

Have you considered the network? Have any network changes been made? How
many segments separate the two machines? Could the traffic patterns be
different this week for some reason?

Al Murry wrote:

Java在AIX 4.3.3上运行的批处理作业与另一个运行相比运行DB2 6.1的RS6000上周需要15分钟。本周
它需要6个多小时！这项工作使用了4个表，每个表有超过5,000,000行。
我被告知批处理工作和其他任何事情都没有变化，而不是每天晚上插入的约10K新记录。这些表，DB中没有任何变化。 （我被告知）

问题是;查询，插入和更新工作可以在一天内从15分钟到6小时吗？我不这么认为......

已经重新排列了所有表格，在数据库上运行DB2DART并没有运气。

任何想法在哪里看？所有smit diags在OS和
硬件上都显示正常。
网络似乎很好。

谢谢 -

TS

A Java Batch job running on AIX 4.3.3 talking to another
RS6000 running DB2 6.1 was taking 15 min last week. This week
it is taking over 6 hours! The job uses 4 tables that have
over 5,000,000 rows each.
I am told nothing has changed in the batch job and other
than about 10K new records inserted each night into a few of
the tables, nothing has changed in the DB. (I am told)

The questions is; Can a query, insert and update job
go from 15mins to 6hrs in one day? I don''t think so...

Have reorged all the tables, ran DB2DART on the DB with
no luck.

Any ideas where to look? All smit diags show ok on OS and
hardware.
network seems fine.

Thanks --

TS

同时竞争资源的其他工作？ （调度程序，实用程序，

......）

Tempspace / sort parms ...排序现在转到磁盘？

聚类比率改变了吗？也许某人有错误的方式......

汇总表涉及？ ast，...

锁定升级

忘记删除痕迹？

我们在说jdbc还是sqlj？

等....


PM


Al Murry <是**** @ northtech.net>一个écritdansle message de

新闻：pa *************************** @ northtech.net .. 。

Other jobs competing for resources at the same time? (scheduler, utilities,
....)
Tempspace/sort parms... Sort is now going to disk?
Clustering ratios changed? Maybe someone reorged the wrong way...
Summary tables involved? ast, ...
lock escalation
forgot to remove traces?
Are we talking jdbc or sqlj?
etc....

PM

"Al Murry" <am****@northtech.net> a écrit dans le message de
news:pa***************************@northtech.net.. .

在AIX 4.3.3上运行的Java Batch作业与另一个运行相同的运行DB2 6.1的RS6000上周耗时15分钟。本周
它需要6个多小时！这项工作使用了4个表，每个表有超过5,000,000行。
我被告知批处理工作和其他任何事情都没有变化，而不是每天晚上插入的约10K新记录。这些表，DB中没有任何变化。 （我被告知）

问题是;查询，插入和更新工作可以在一天内从15分钟到6小时吗？我不这么认为......

已经重新排列了所有表格，在数据库上运行DB2DART并没有运气。

任何想法在哪里看？所有smit diags在OS和
硬件上都显示正常。
网络似乎很好。

谢谢 -

TS

A Java Batch job running on AIX 4.3.3 talking to another
RS6000 running DB2 6.1 was taking 15 min last week. This week
it is taking over 6 hours! The job uses 4 tables that have
over 5,000,000 rows each.
I am told nothing has changed in the batch job and other
than about 10K new records inserted each night into a few of
the tables, nothing has changed in the DB. (I am told)

The questions is; Can a query, insert and update job
go from 15mins to 6hrs in one day? I don''t think so...

Have reorged all the tables, ran DB2DART on the DB with
no luck.

Any ideas where to look? All smit diags show ok on OS and
hardware.
network seems fine.

Thanks --

TS

我关闭了所有其他工作。拍摄不同时间的快照

不显示任何异常。没有锁定升级。

使用jdbc。

没有集群idx'。


TS

2003年10月20日星期一21:38:13 +0000，PM-pm3iinc-nospam写道：

I have shut all other jobs down. Taking a snapshot a different times
Shows nothing adnormal. No lock escalation.
Using jdbc.
No cluster idx''s.

TS

On Mon, 20 Oct 2003 21:38:13 +0000, PM-pm3iinc-nospam wrote:

其他同时竞争资源的工作？ （调度程序，实用程序，
......）临时空间/排序参数...排序现在转到磁盘？
聚类比率发生了变化？也许某人有错误的方式......
汇总表涉及？ ast，...
。
忘了删除痕迹？
我们在说jdbc还是sqlj？
等等......

PM

Al Murry <是**** @ northtech.net> écritdansle message de
新闻：pa *************************** @ northtech.net ..。

Other jobs competing for resources at the same time? (scheduler, utilities,
...)
Tempspace/sort parms... Sort is now going to disk?
Clustering ratios changed? Maybe someone reorged the wrong way...
Summary tables involved? ast, ...
.
forgot to remove traces?
Are we talking jdbc or sqlj?
etc....

PM

"Al Murry" <am****@northtech.net> a écrit dans le message de
news:pa***************************@northtech.net.. .

在AIX 4.3.3上运行的Java Batch作业与另一个运行的DB2运行DB2 6.1的RS6000上周耗时15分钟。本周
它需要6个多小时！这项工作使用了4个表，每个表有超过5,000,000行。
我被告知批处理工作和其他任何事情都没有变化，而不是每天晚上插入的约10K新记录。这些表，DB中没有任何变化。 （我被告知）

问题是;查询，插入和更新工作可以在一天内从15分钟到6小时吗？我不这么认为......

已经重新排列了所有表格，在数据库上运行DB2DART并没有运气。

任何想法在哪里看？所有smit diags在OS和
硬件上都显示正常。
网络似乎很好。

谢谢 -

TS

A Java Batch job running on AIX 4.3.3 talking to another
RS6000 running DB2 6.1 was taking 15 min last week. This week
it is taking over 6 hours! The job uses 4 tables that have
over 5,000,000 rows each.
I am told nothing has changed in the batch job and other
than about 10K new records inserted each night into a few of
the tables, nothing has changed in the DB. (I am told)

The questions is; Can a query, insert and update job
go from 15mins to 6hrs in one day? I don''t think so...

Have reorged all the tables, ran DB2DART on the DB with
no luck.

Any ideas where to look? All smit diags show ok on OS and
hardware.
network seems fine.

Thanks --

TS

这篇关于DB2掉到了第一档？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！