Text index error! - DB2 Database

Lan W via DBMonster.com

Hi,

I have db2 UDB 8.2 installed on AIX 5.3 server. initially, my database seems
working fine with logretain on and userexit off. Then I installed db2 net
search extender 8.2 on top of it. In order to create text index, do I need to
set both logretain and userexit be off during the index creating? Because I
got some error while I execute some load and db2text command. if the answer
is no, then how can I specifying the 'copy yes' option in the load operation
with archieve log is on?

Thanks!
Lan

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200511/1

Nov 17 '05 #1

Subscribe Post Reply

1375

Stefan Momma

Lan W via DBMonster.com wrote:

Hi,

I have db2 UDB 8.2 installed on AIX 5.3 server. initially, my database seems
working fine with logretain on and userexit off. Then I installed db2 net
search extender 8.2 on top of it. In order to create text index, do I need to
set both logretain and userexit be off during the index creating? Because I
got some error while I execute some load and db2text command. if the answer
is no, then how can I specifying the 'copy yes' option in the load operation
with archieve log is on?

Thanks!
Lan

Could you be a bit more specific about the load and db2text commands you
execute, and the error message you get?

Cheers,

-- stefan

Nov 23 '05 #2

Similar topics

text extenders error can't find indexes

by: wayne mcfadden | last post by:

Hi, I'm stumped. Our text extenders stopped working on one database. I think that i'm missing something simple here. The column is enabled... but when you do an index status it doesn't know...

DB2 Database

Unable to set focus on a text box

by: PeterW | last post by:

This is a re-post of a problem I have been struggling with for some time now. I'm sure I'm doing something silly! I have a data entry form with text boxes bound to a query. The user can enter...

Microsoft Access / VBA

Can someone help with this response.text?

by: TN Bella | last post by:

Hello, I don't know why I keep getting this error. I have 15 of each txtacctnum (txtacctnum - txtacctnum14), txtcostcntr, txtrefnum, and txtacctamt. Some of the inputs are null, so I don't want to...

ASP.NET

Split Delimited Text Twice into Array

by: Ben | last post by:

Hi I am creating a dynamic function to return a two dimensional array from a delimeted string. The delimited string is like: field1...field2...field3... field1...field2...field3......

Visual Basic .NET

partial index on a text field

by: Chris | last post by:

Hi all, I have a text field which I'll be doing LIKE searches against so I wanted to set up an index on it. The data itself is too long to create a full index, so I can't just: chris=>...

PostgreSQL Database

Exporting jet table metadata as text?

by: Kevin Chambers | last post by:

Hi all-- In an attempt to commit an Access MDB to a versioning system (subversion), I'm trying to figure out how to convert a jet table's metadata to text, a la SaveAsText. The end goal is to...

Microsoft Access / VBA

Error (8626) while inserting record into table with text field and which is the base for indexed view

by: ing42 | last post by:

I have a problem with inserting records into table when an indexed view is based on it. Table has text field (without it there is no problem, but I need it). Here is a sample code: USE test GO...

Microsoft SQL Server

how to split a string using ,fixed character length, variable text delimmiter

by: garyusenet | last post by:

I'm working on a data file and can't find any common delimmiters in the file to indicate the end of one row of data and the start of the next. Rows are not on individual lines but run accross...

C# / C Sharp

syntax error when creating text index

by: Xh | last post by:

Hi all, I have successfully installed DB2 Net Search Extender. DB2Ext is up and running, I've run successfully this command: db2text ENABLE DATABASE FOR TEXT CONNECT TO TEST1; but when I...

DB2 Database

Oracle Text: Indexing UTF8 or UTF16

by: Server Applications | last post by:

Hello I am trying to build a system where I can full-text index documents with UTF8 or UTF16 data using Oracle Text. I am doing the filtering in a third-party component outside the database, so...

Oracle Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing