473,386 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Indexes on nicknames not in catalo

Environment: WebSphere Federation Server, 9.1 FP 3 on AIX 5.3
Remote Data Source: Oracle 10

Table in remote database has a function based index on it.

In the DataJoiner days, I had to request this index to be dropped
before I could create a nickname. With WebSphere Federation Server,
that is no longer necessary.

Once I create the nickname, should I see references to these function
based indexes in the WFS catalog view syscat.indexes? I do not. I see
no reference in the Vs 9 manuals that indicates they are excluded.

Under "Create Nickname" the following are the cases when indexes will
not be reflected:
1. Duplicate column names
2. More than 64 columns
3. More than 1024 bytes in the sum of the length of the index key
parts

None of these apply.

Can someone point me to a reference that explains this situation?

My reason for wanting to see them, is to provide input on what indexes
are valuable based on syscat.packagedep. But if the indexes are not in
the catalog, they certainly wouldn't show up as dependents.

Thanks,

Kristi Close
Apr 1 '08 #1
0 1119

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: global | last post by:
Hi, we have UDB 8.1.4 on W2K and defined federated database with nicknames, which cann't be seen in control center. (filter is not activ). Thx
1
by: dbtoo_dbtoo | last post by:
Hello If we have nicknames created in DB1 to, say, three other databases (DB2,DB3, and DB4) in the same instance. How can one find out what table/database is a nickname pointing to? For...
1
by: _link98 | last post by:
On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides the Transaction-manager? i.e. in the same transaction, can an SQL/PL...
14
by: Jeff | last post by:
This is the first time that I remember ever having too many indexes on a table, but it has happened. I have en employees table and store in many places, on tables, the id of the employee that...
10
by: lesperancer | last post by:
you start with a small application in access97, then you have more modules and more... and you reach the point where tables like 'item' and 'employee' reach the limit and you know there's more...
0
MMcCarthy
by: MMcCarthy | last post by:
The more data you include in your tables the more you will need to have indexes to search and sort that data. However, there is a balance between having enough indexes and too many. Too many...
1
by: ebusiness | last post by:
I am trying to create nicknames for tables in a remote database. The federated database and remote database are both DB2 UDB V8.2, both OS are AIX. Could anyone tell me how to create a nickname...
0
by: VikingDK | last post by:
Hi all Please bear with me, I'm still very inexperienced when it comes to DB2, so my questions might seem a little silly. With that covered, now on to the question :) I have a DB2 Enterprise...
1
by: DataFinder | last post by:
Not wanting to re-create the wheel, I have a need for a two-column table that links nicknames and given names if they are a derivative or source of another. Can you help? Using an Access...
0
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,...
0
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$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
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
0
BarryA
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...
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.