Hi,
can someone please help me out with the following problem:

I run a simple Korn shell script:
----
db2 connect to $EZERSQLDB user $FCWDBUSER using $FCWDBPASSWORD 1>$-
while [[ 1 = 1 ]];
do
db2 -x "SELECT count(*), current timestamp FROM DB2ADMIN.STANJE_R"
sleep 10
done
----
that returns the number of rows present in the table (10858), but occasionally the number returned is one less than the expected result (10857), or even worse - one more (10859):
...
10858 2005-10-19-13.24.08.769326
10858 2005-10-19-13.24.18.823832
10857 2005-10-19-13.24.28.884950
10858 2005-10-19-13.24.50.091621
10858 2005-10-19-13.25.00.221457
...
10858 2005-10-19-13.43.27.441652
10858 2005-10-19-13.43.37.633690
10857 2005-10-19-13.43.47.686231
10858 2005-10-19-13.43.57.839650
10858 2005-10-19-13.44.07.894608
...
10858 2005-10-19-13.14.24.921809
10859 2005-10-19-13.14.34.973751
10858 2005-10-19-13.14.45.248090
10858 2005-10-19-13.14.55.413005
...
The table itself contains a fairly constant number of rows (currently 10858), with up to several new inserts daily.
No row can ever be (and is not) deleted from the table, but present rows can be (and are, at least once a day) updated frequently.

How is this possible??

OS is AIX 4.3.3, and "db2level" shows:
DB21085I Instance "db2" uses DB2 code release "SQL07025" with level identifier
"03060105" and informational tokens "DB2 v7.1.0.68", "s020616" and "U484480".

Not the newest platform level(s), I agree, but still the results of the query are beyond me :-(


Regards,
Damir Wilder

DB2 & UDB email list listserv db2-l LazyDBA home page