The view db2ext.dbdefaults displays all the default values for the database.
The defaults on the database level cannot be changed and are available as attribute-value pairs in this view:
db2ext.dbdefaults db2 select DEFAULTNAME, DEFAULTVALUE from DB2EXT.DBDEFAULTS
Attribute | Default Value | Notes |
---|---|---|
CCSID | CCSID of database | Default CCSID for documents. This is applied if no CCSID is specified in the CREATE INDEX command. |
FORMAT | TEXT | Document default format. This is applied if no format is specified in the CREATE INDEX command. |
INDEXDIRECTORY | See the path name under Notes | Directory for full-text index files. This is applied if no index directory is specified in the CREATE INDEX command. The path name is: $DB2EXT_INSTOWNERHOMEDIR/sqllib/ db2ext/indexes |
LANGUAGE | EN_US | The document language. |
MODELCCSID | CCSID of database | CCSID of document model files. |
UPDATECOMMITCOUNT | 0 | The number of changes processed in one transaction during an update. |
CLEARCOMMITCOUNT | 0 | The number of changes processed in one transaction during an CLEAR INDEX command. |
UPDATEFREQUENCY | NONE | When to check for updates in new indexes. |
UPDATEMINIMUM | 1 | The minimum number of changes before update is executed. |
WORKDIRECTORY | See the path name under Notes | Directory for index temporary files. The path name is: <os_dependent>/sqllib/db2ext/ indexes |
CACHEDIRECTORY | See the path name under Notes | Default directory for PERSISTENT CACHE option of the CREATE INDEX command. The path name is: <os_dependent>/sqllib/ db2ext/memory |
PCTFREE | 50 | The percentage of the cache left free for future inserts. |
USERPERSISTENTCACHE | 1 | Use the persistent cache. |
AUTOMATICREORG | 1 | The REORGANIZE option in the CREATE INDEX command. This means automatic reorganization. |
TREATNUMBERSASWORDS | 0 | Do not interpret sequences as separate words, even if they are adjacent characters. For example, the 0 default means that tea42at5 is considered as one word. |
INDEXSTOPWORDS | 1 | Ignore stopwords during indexing. |
VERSION | NSE V8.1.4 Current version number of Net Search Extender. | |
UPDATEDELAY | 0 | Only log entries are used for incremental updates with a timestamp. If the log entry is older than the current timestamp, this is an updatedelay. This should only be used for long running transactions on the user table during an update command to avoid lost updates. Note that with log entries and incremental updates, no capture table is used. |