472,958 Members | 2,278 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

Runstats / OLTP environment

Environment: DB2 v8 LUW FP 15 Linux.

I have an OLTP system and several applications run frequent and
concurrent insert/delete/select statements.

Table sizes can grow a lot, and eventually I need to collect new
statistics.

While trying to use 'allow write access', this following warning is
returned:

SQL2314W Some statistics are in an inconsistent state. The newly
collected "TABLE" statistics are inconsistent with the existing
"INDEX" statistics.

Using allow read acces is not an option, unfortunately. Ive tried
table and index sampling, but that also did not help much.

My question is: how bad can this 'inconsistency' be ? Can I safely
ignore it ? Or can this lead my system to poor query planning and
statement reponse times be slower than if statistics where taken using
'allow read access ?

Thanks, Michel.
Aug 24 '08 #1
1 2881
On Aug 23, 10:07*pm, Michel Esber <mic...@us.automatos.comwrote:
Environment: DB2 v8 LUW FP 15 Linux.

I have an OLTP system and several applications run frequent and
concurrent insert/delete/select statements.

Table sizes can grow a lot, and eventually I need to collect new
statistics.

While trying to use 'allow write access', this following warning is
returned:

SQL2314W *Some statistics are in an inconsistent state. *The newly
collected *"TABLE" statistics are inconsistent with the existing
"INDEX" *statistics.

Using allow read acces is not an option, unfortunately. Ive tried
table and index sampling, but that also did not help much.

My question is: how bad can this 'inconsistency' be ? Can I safely
ignore it ? Or can this lead my system to poor query planning and
statement reponse times be slower than if statistics where taken using
'allow read access ?

Thanks, Michel.
All it means is that the number of rows in index (when examined by
runstats) is different than the number of rows in the table (when
runstats looked at the table immediately prior to that). This happens
becasue their are deletes and inserts happening while the runstats is
running. The differences are not likely to be significant, so just
ignore the warning.

Aug 24 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: LineVoltageHalogen | last post by:
Greetings All, I was wondering if any of you would share some of your experiences regarding the task of loading a data store from an Oltp source. We are using Analysis Services in a BI product...
1
by: Evan Smith | last post by:
Years ago I worked on a system which I believe was one of the first instances of EEE being used in an OLTP environment. It was fraught with lots of gotchas, but overall was made to work. This was...
3
by: Michael Sherf | last post by:
I'm looking for "real life" experiences of companies running DB2 in an 24x7 OLTP environment. Seems like most folks are using DB2 for DSS applications, rather than OLTP. If your DB2 production...
7
by: Todd McNeill | last post by:
Hi- Something was just pointed out to me this morning. According to the V8 Command Reference, the RUNSTATS command no longer uses the SHRLEVEL CHANGE/REFERENCE clauses, and it looks to be...
4
by: kenfar | last post by:
I've got a large table on db2 8.2.1 that I rarely perform runstats on. It has about 600 million rows organized in a single MDC time dimension on a non-dpf warehouse. Anyhow, we recently ran...
0
by: dsslim | last post by:
Hi, In my OLTP environment, packages are being executed while tables are being inserted but less deletes. And runstats not run at all. Will this affect the performance ? Since the packages...
0
by: RG | last post by:
I have a stored procedure which is called by db2 "call ....." statement from ksh script. When running from AIX DB2 v. 9.1.3 environment, after a while the stored procedure starts to hang and...
4
by: db2udb | last post by:
Hi, I have just taken over as the DBA for a database that has not had any reorgs/runstats run against it for the last three years. As a first step, I have just run reorg/runstats against the system...
3
by: Norm | last post by:
If RUNSTATS is called directly, we can specify UTIL_IMPACT_PRIORITY to limit CPU consumption. For automatic runstats, there is no place to specify this paramater. Will it use the DBM value of...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.