Setup: SuSE Linux 8.2 running IBM DB2 v8.1 with Net Search Extender.
We had to hard reset our server, and did a successfull crash recovery.
We now have a problem with operations involving text indexes. For
example, when We try to update an index, we get the error message
"CTE0190 Executable program "cteadmsv" could not be started."
We have tried the following:
- db2text stop/start
- dbadmin stop/start
- db2text drop index... => just produces the above error message
The free text indexes are not working at all, ie. all operations
involving free text searches are now failing with various error
messages.
Any ideas on how to get the system back into a working condition
short of backup/reinstall/restore would be appreciated.
--
Lars Haugseth
3  4609 
* Lars Haugseth <la***********@ tn.no> wrote:
|
| Setup: SuSE Linux 8.2 running IBM DB2 v8.1 with Net Search Extender.
|
| We had to hard reset our server, and did a successfull crash recovery.
| We now have a problem with operations involving text indexes. For
| example, when We try to update an index, we get the error message
| "CTE0190 Executable program "cteadmsv" could not be started."
|
| We have tried the following:
|
| - db2text stop/start
| - dbadmin stop/start
| - db2text drop index... => just produces the above error message
|
| The free text indexes are not working at all, ie. all operations
| involving free text searches are now failing with various error
| messages.
|
| Any ideas on how to get the system back into a working condition
| short of backup/reinstall/restore would be appreciated.
Additional info that may or may not be of use: any select statement
involving freetext indexes produces the following error message:
SQL0443N Routine "*RCH_1K16" (specific name "") has returned an error
SQLSTATE with diagnostic text "CTE0101 A search engine operation failed.
Reason code: "16"". SQLSTATE=38701
--
Lars Haugseth
* Lars Haugseth <la***********@ tn.no> wrote:
|
| * Lars Haugseth <la***********@ tn.no> wrote:
| |
| | Setup: SuSE Linux 8.2 running IBM DB2 v8.1 with Net Search Extender.
| |
| | We had to hard reset our server, and did a successfull crash recovery.
| | We now have a problem with operations involving text indexes. For
| | example, when We try to update an index, we get the error message
| | "CTE0190 Executable program "cteadmsv" could not be started."
| |
| | We have tried the following:
| |
| | - db2text stop/start
| | - dbadmin stop/start
| | - db2text drop index... => just produces the above error message
| |
| | The free text indexes are not working at all, ie. all operations
| | involving free text searches are now failing with various error
| | messages.
| |
| | Any ideas on how to get the system back into a working condition
| | short of backup/reinstall/restore would be appreciated.
|
| Additional info that may or may not be of use: any select statement
| involving freetext indexes produces the following error message:
|
| SQL0443N Routine "*RCH_1K16" (specific name "") has returned an error
| SQLSTATE with diagnostic text "CTE0101 A search engine operation failed.
| Reason code: "16"". SQLSTATE=38701
For now, we managed to "fix" this by doing the following:
db2inst1:~> chmod 666 ~/sqllib/db2ext/indexes/NODE0000/IX*.ini
By using 'strace', we could see that when running text search queries,
DB2 complained about being unable to open these files. It was obviously
trying to open these files in 'write' mode, which failed since they
had permission 440.
We're still interested in any clues about how this happened and
how to fix it properly.
--
Lars Haugseth
I got this error couple of times.
Once when i restored a backup from DB2FP5 to DB2 FP2.
Installing the appropriate fixpak fixed the issue.
Second time i received this error when i restored a backup from Windows
2000 to Win 2003. This time DB2 level was same.
I noticed the text index was not there when i restored. Recreating &
Updating the Text index helped.
And the *.ini file you specified was read only too.
Lars Haugseth wrote: * Lars Haugseth <la***********@ tn.no> wrote:
|
| * Lars Haugseth <la***********@ tn.no> wrote:
| |
| | Setup: SuSE Linux 8.2 running IBM DB2 v8.1 with Net Search
Extender. | |
| | We had to hard reset our server, and did a successfull crash
recovery. | | We now have a problem with operations involving text indexes. For
| | example, when We try to update an index, we get the error message
| | "CTE0190 Executable program "cteadmsv" could not be started."
| |
| | We have tried the following:
| |
| | - db2text stop/start
| | - dbadmin stop/start
| | - db2text drop index... => just produces the above error message
| |
| | The free text indexes are not working at all, ie. all operations
| | involving free text searches are now failing with various error
| | messages.
| |
| | Any ideas on how to get the system back into a working condition
| | short of backup/reinstall/restore would be appreciated.
|
| Additional info that may or may not be of use: any select statement
| involving freetext indexes produces the following error message:
|
| SQL0443N Routine "*RCH_1K16" (specific name "") has returned an
error | SQLSTATE with diagnostic text "CTE0101 A search engine operation
failed. | Reason code: "16"". SQLSTATE=38701
For now, we managed to "fix" this by doing the following:
db2inst1:~> chmod 666 ~/sqllib/db2ext/indexes/NODE0000/IX*.ini
By using 'strace', we could see that when running text search
queries, DB2 complained about being unable to open these files. It was
obviously trying to open these files in 'write' mode, which failed since they
had permission 440.
We're still interested in any clues about how this happened and
how to fix it properly.
--
Lars Haugseth This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Torsten Mohr |
last post by:
Hi,
i'd like to build an executable file that is linked with
a python library and executes a script via PyRun_SimpleString
or similar functions.
Is there a static library of python available, so the users
don't need to install python?
|
by: Joris De Groote |
last post by:
Hi
I am busy trying to create a VB.NET program. I want to give the program an
argument in the shortcut I created for that program (for example:
program.exe argument).
Now I just can't find how I can read that argument in my VB.NET program.
Can anyone help me?
Thanks
|
by: Ollie |
last post by:
Hi
I am trying to start up a labview file from within my C program.
Whats the easiest way to start an external program up ?
I looked at _execl but could not make any sense of the arguments and parameters and am not sure if this is the best way to proceed.
Regards
|
by: fobus |
last post by:
I want to import some sound files to executable file. And also I want
to know that imports adress and size. How can I import a data to
executable file?
Thanks
Kervan ASLAN
|
by: Benjamin Hell |
last post by:
Hi!
I wonder whether there might be a way to find out how a Python
program was started (in my case in Windows): By double clicking the
file or by calling it on the "DOS" command line prompt.
Background: I would like to have the program run in an "interactive
mode" if double clicked, and silently in a "batch mode" when started
otherwise.
| | |
by: zcabeli |
last post by:
Hello,
i've installed some modules in my unix machine which i'm using in my scripts. however, i'd like to make those scripts executable from any machine, with minimal requirements of perl installed. is it possible ?
thanks,
|
by: W. eWatson |
last post by:
How do I get my py code into some executable form so that Win users who
don't have python can execute it?
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
Web Page: <www.speckledwithstars.net/>
|
by: jmDesktop |
last post by:
I want to create my C# program to run in the background and detect
when a program starts. In an interactive program, I know I can
iterate through an array of Processes to find my process if I click a
button, for example. But, I cannot find the best way to run my C#
program in the background waiting for a program to start
The program just needs to stay in the background and when someone say
opens notepad, I can show a messagebox saying...
|
by: abuasab |
last post by:
how can run executable application from oracle trigger or procedure.
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
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
| |
