Hi ... We are running v7.1 on Linux Redhat 7.2
All things were fine, until the power supply of the box fried
after 4 years of un-interrupted service (2 reboots only)
Replaced the power supply, and all (well almost) is working 100%

Problem is that all of a sudden the LOWER() and UPPER() functions
in my queries stopped working, with the following error.

ERROR INFO
------------------------------------------------------------------------------------------------------
DB2 Error Code = -440
[IBM][CLI Driver][DB2/LINUX] SQL0440N No function by the name "LOWER"
having compatible arguments was found in the function path.
SQLSTATE=42884
------------------------------------------------------------------------------------------------------

QUERY
-----------------------------------------------------------------------------------
SELECT Username FROM db2inst1.USERS
WHERE SiteID = 0 AND LOWER(UserName) = 'herman'
-----------------------------------------------------------------------------------

TABLE INFO
db2 => describe table users

Column                         Type      Type
name                           schema    name               Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- -----
SITEID                         SYSIBM    INTEGER                   4
0 No
USERNAME                       SYSIBM    VARCHAR                  30
0 No
PASSWORD                       SYSIBM    VARCHAR                  30
0 No
ACCESSRIGHTS                   SYSIBM    VARCHAR                  50
0 No
REFERNAME                      SYSIBM    VARCHAR                  50
0 Yes
REFERSITE                      SYSIBM    INTEGER                   4
0 No
SITERIGHTS                     SYSIBM    VARCHAR                  50
0 Yes
JUMPURL                        SYSIBM    VARCHAR                 100
0 Yes

db2 => SELECT DISTINCT(CURRENT PATH) FROM USERS
shows : "SYSIBM","SYSFUN","DB2INST1"

Most functions are working, but so far LOWER() and UPPER() just stopped
working for no reason.

I have been fighting this all day, and this is a live production
server,
so we have absolute pandamonium here....

If ANYONE can help, im very desperate...

Thanks