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(CURREN T PATH) FROM USERS
shows : "SYSIBM","SYSFU N","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
8  9481 
In article <11************ **********@v46g 2000cwv.googleg roups.com>, he****@appscom. co.za says... 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.
Just a first guess but maybe running DB2UPDV7 against the database might
fix some troubles.
Did you check the db2diag.log for error messages?
I have checked db2diag....no errors
I havent got the file db2updv7 ... cant find it anywhere on the
system...
In article <11************ **********@i40g 2000cwc.googleg roups.com>, he****@appscom. co.za says... I have checked db2diag....no errors
I havent got the file db2updv7 ... cant find it anywhere on the
system...
If I do remember right it should be on the server in the misc directory.
If you don't have it on your system you are running with the oldest V7
level. You need to install later fixpacks to be a bit less outdated (FP3
to get you to 7.2, FP14 after that to get you to the latest one).
Sorry, I can't help you with the upper/lower problem.
SUCCESS !!!!!
When I replaced the power supply, the BOIS reset the date
to the year 2000, and I never picked it up.
I rebooted, set the BIOS time to now() and Bob is now my uncle...
Herman
In article <11************ **********@j33g 2000cwa.googleg roups.com>, he****@appscom. co.za says... SUCCESS !!!!!
When I replaced the power supply, the BOIS reset the date
to the year 2000, and I never picked it up.
I rebooted, set the BIOS time to now() and Bob is now my uncle...
Herman
Good news. Still I would recommend an update if you are really on V7.1
without any fixpacks.
:) hehe....
this box is very old, and is going to be retired in about 3 months.
Its been running as is for 4 years without a single problem,
so Id rather not tamper with it now ..
In article <11************ **********@j33g 2000cwa.googleg roups.com>, he****@appscom. co.za says... :) hehe....
this box is very old, and is going to be retired in about 3 months.
Its been running as is for 4 years without a single problem,
so Id rather not tamper with it now ..
Yep, then it's the best choice :)
Gert van der Kooij wrote: In article <11************ **********@j33g 2000cwa.googleg roups.com>,
he****@appscom. co.za says... :) hehe....
this box is very old, and is going to be retired in about 3 months.
Its been running as is for 4 years without a single problem,
so Id rather not tamper with it now ..
Yep, then it's the best choice :)
Just to provide some color:
Function resolution ignores functions created in the future.
For functions defined in SYSFUN (such as old versions of UPPER and
LOWER) this means the system time needs to be higher than the time the
database was created.
Apparently LOWER and UPPER were the only SYSFUN functions you used,
otherwise the problem would have been more generalized.
I recall a PMR years ago where a customer had a DPF (then EEE) system
with a major clock skew between the catalog node and other nodes.
As a result any UDF they defined could not be accessed for some minutes
after the CREATE. Magically after a few retries they appeared. :-)
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Hallvard B Furuseth |
last post by:
Has someone got a Python routine or module which converts Unicode
strings to lowercase (or uppercase)?
What I actually need to do is to compare a number of strings in a
case-insensitive manner, so I assume it's simplest to convert to
lower/upper first.
Possibly all strings will be from the latin-1 character set, so I could
convert to 8-bit latin-1, map to lowercase, and convert back, but that
seems rather cumbersome.
|
by: John F Dutcher |
last post by:
There must be a 'fundamental' reason why 'string' functions are
reported as 'not found' even though the 'import string' statement
is present. If the script has user-defined functions at its beginning
and I remove them...doing all code inline, the 'not found' error goes away.
Is there some 'placement of user functions' issue that explains why
the 'import string' doesn't make the various string functions visible
when I use various 'def...
|
by: Maximus |
last post by:
Hi,
I was just wondering, is it good to use return without arguments in a void
function as following:
void SetMapLayer()
{
if( !Map ) return;
layer = LAYER_MAP;
}
|
by: DJ |
last post by:
Can someone tell me the library call that converts strings to lower case or
retrns a new string that is lower case of the original, thanks
im using <string>
David
|
by: Marek Lewczuk |
last post by:
I'm looking at "TODO list for PostgreSQL" and "Fix upper()/lower() to
work for multibyte encodings" has no dash (-) -- so it won't be made in
7.5 ?
Another question is about WIN32 native release - currently, all win
users cannot set locales, becouse Cygwin does not support it -- I hope
that it will be solved in native release, so UTF-8 should work as well ??
Just wanted to know how to plan my further work. Thanks.
| | |
by: Janice |
last post by:
char* line = "abcd";
How to convert the line to upper case and print?
Any option for printf to do this?
Thanx
|
by: Tim Conner |
last post by:
Hi,
Thanks to Peter, Chris and Steven who answered my previous answer about
regex to split a string. Actually, it was as easy as create a regex with the
pattern "/*-+()," and most of my string was splitted.
I am fascinated to the powerfull use of this RegEx class, so I wonder if it
could go a step further.
As a question, can regex be used to valid a set of different functions ?
Example : Suppose I have to verify the correctness of an...
|
by: pginfo |
last post by:
Hi ,
I tesetd the lower/upper support and cyrillic and it looks broken.
My system:
pg 7.4.3
freebsd 5.2.1.
I created my database with 'UNICODE'.
|
by: Thekid |
last post by:
I had made a post about making a loop using letters instead of numbers and dshimer gave me this solution:
for i in range(65,70):
for j in range(65,70):
for k in range(65,70):
print chr(i),chr(j),chr(k)
which used an example I had posted using numbers. That code works (thanks dshimer) but after toying with it I see that I am going about it in a method that takes a long time to run through and I also need uppers in...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
