Quick way to fix the UNK table 
Use this IdeaSpace to post ideas about the Notes Client.

: 43
: 43
: 0
: Notes Client / Other
: Notes, Domino, UNK
: Ken Haggman579 06 Apr 2008
: / Email
As you know, the UNK table is an internal table in a Notes database that lists all the fields (in forms, subforms and shared fields) plus all items that exist in documents. This table tends to get very big for larger databases that are being touched by designers over the years. A spelling mistake for a field name will mean the field name is stored in the UNK table - for ever.
There are ways to get rid of those un-used table items by using compact in combination with full-text index handling.
But really, this should be a server task that runs automatically on the server.
An alternative to the server doing the update of the UNK table would be to have a button in the database properties dialog, similar to the 'compact' button.
And, as yet another alternative, this should be possible to do programmatically.
Even using the C API, this is extremely tricky as all you can do with the C API is to read the table - not actually modify the table.

1) Harkpabst Meliantrop3799 (14 Apr 2008)
I would definitely prefer the button over a server task. Too much overhead for a function, that's used only occasionally.
2) Christopher Boote10606 (17 Aug 2009)
It's not just a case of compacting it though
The various forms keep the old field names, and at the moment the only way to shed them is to create a new form, and copy & paste the old form's contents into it
If it has various pieces of event code, that is a real pain

We need an option to clean up the UNK table AT THE FORM LEVEL every time a form is saved - or maybe add it as part of the 'Tools - recompile' code?


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo