To:   LISTSERV AT vm.marist DOT edu @ DEUBAINT
cc:   tsm-tech-list AT db DOT com
Subject:  SQL select on *SM 3.1.2.50

All,
     We gather statistics on all our servers, the majority of which are mainly
3.1.2.42.  We have recently upgraded one server
 to 3.1.2.50 and one of our SQL select statements has ceased to function. (see
contents of PMR rasied below)

Quote
02/08/00  00:04:05     ANR2017I Administrator QUERY issued
command: select message from actlog where
cast((current_timestamp-date_time)days as decimal) <=1.
                          and msgno =4967

Having recently upgraded a server to 3.1.2.50 we have
encountered premature exits on the above SQL statement
which is currently being used to generate average client
throughput on a per server basis, as part of a statistical
analysis suite.

The above select statement function normally on all
versions of server code (including TSM 3.7) except
3.1.2.50, where it returns
ANR2034E slect: No match found using this criteria. It is
reproducable.

If date processing is removed and just msgno processed
then the query returns all 4967 messages..

I have checked the fixtest site at storsys, but found no
PTF's pertaining to SQL at fix level 3.1.2.54.
Unquote

Has anyone else seen this???


Tel:       +44(0) 207 547 4917
Mobile    +44(0) 468 361-885
email:    bruce.mitchell AT db DOT com