Admin Q: How to find info on FTI's on a server?

HCL Domino Domino Forum
1

I’m not an administrator, so not familiar with the many features of the admin client.

Can I look at full text index files in the same way as databases? I’m interested to see what FT indexes exist and how big they are.

I thought the “Show me: All Files” view might do it all I see are things like databases, templates & mail boxes.

I looked in Admin Help but did not find anything.

TIA.

2

Subject: They are stored in a directory

Of the same name as the database. Don’t have server here handy so IIRC it should have .ft extension on the directory name.

But you can make an FTI and check.

3

Subject: Thanks, Simon. I should have mentioned i-series/AS400 server (not Windows)

I am not our company’s admin and do not have access to the server, so I can’t look at files through the OS. However, I do have a Domino Admin client and can do my research using it.

In an effort to reduce space usage, or at least identify what is using the most space on the server, I’m trying to get a list of databases and other files, sorted by space. Once we have that list we’ll analyze it come up with a plan for reducing space usage. I know we have some large mail files and custom databases. I’m wondering if there are some full text indexes that are also using lots of space.

I’m probably mistaken, but I thought I saw in the past a place in the admin client that showed which databases had full text indexes, but I haven’t been able to find it.

How do you see what databases have FTI? And do you have a way to see how much space they are using?

Thanks for the help and any suggestions.

4

Subject: Asked an AS400 person

Here is the response. ----

Unless you’d specified the dir, it would be in the notes data folder something like

Notes/DATA/Filename.ft/ftgi/

To check database FTI size from within the client you can select the application properties. The FTI tab (one with magnifying glass) will show you the size.

5

Subject: Found list of FTI’s! Custom view in catalog using DbFullTextIndexed field

I knew I had seen an FTI indicator somewhere, but it wasn’t in the DB Admin client. It was the catalog database.

I created a custom view and used DbFullTextIndexed = “1” as part of the view selection criteria.

Now that I know which databases have FTI, it will be much easier to find out how much space they are using. I may have to look at the database properties one at a time, but that’s a big improvement over looking at every database just to see IF it has an FTI.

Thanks for helping me work through this.