file_getlist

You display the list of the database files of the current database instance. You have the option of defining the scope of the file list that is output.

Note, however, that the system only displays those DBM commands which it can access at the time of execution. The list may therefore vary with the state of the database instance.

Prerequisites

You have the server authorization DBFileRead.

Structure

file_getlist <list_level>

Options
Option	Description
`<list_level>`	Scope of the file list to be displayed Possible values are: `0 \| 1` `0`: the most important files (default value) `1`: all files

Result

OK

key_name,mode,size,date,time,comment,file_name

<file_ID> <mode> <file_length> <date> <time> <comment> <file_name>

...

Values for the Reply Fields
Value	Description
`<file_ID>`	File ID of the database file
`<mode>`	Indicates whether the file is plain text or binary Possible values are: `ASCII\|BINARY` `ASCII`: plain text file (also UNICODE) `BINARY`: binary file
`<file_length>`	Size of database file
`<date>`	Date of last change
`<time>`	Time of last change
`<comment>`	Additional Information
`<file_name>`	File name

Example

Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display the list of the most important database files:

>dbmcli -u OLEG,MONDAY -d DEMODB file_getlist 1

keyname,mode,size,date,time,comment,filename

KNLDIAG ASCII 50608 20050421 133815 Database Messages knldiag.classic

KNLDIAGERR ASCII 1447 20050421 133815 Database Errors knldiag.err.classic

KNLDIAGOLD ASCII 56767 20050421 133816 Database Messages (OLD) knldiag.old.classic

KNLTRC BINARY 5595136 20050418 141944 Database Trace knltrace

UTLPRT ASCII 102400 20050418 141927 Utility Statements dbm.utl

BACKHIST ASCII 1424 20050418 131056 Backup History dbm.knl

...

More Information

Glossary, Database File