. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 10.2. Setting Sweep Interval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . database shutdown -fe(tch_password) fetch password from file -h(ousekeeping) set sweep interval -i(gnore) ignore checksum errors -icu fix database to be usable the above methods are used together. 10.2. Setting Sweep Interval The default sweep interval for a new database is 20,000. The sweep interval is the difference between the Oldest Snapshot Transaction

MON$SHUTDOWN_MODE (RDB$SHUTDOWN_MODE) SMALLINT Nullable MON$SWEEP_INTERVAL (RDB$SWEEP_INTERVAL) INTEGER Nullable MON$READ_ONLY (RDB$SYSTEM_FLAG) SMALLINT Nullable the current file. HDR_unlicensed 0x05 Count of unlicensed activity. No longer used. HDR_sweep_interval 0x06 Number of transactions between sweep. HDR_log_name 0x07 Replay log name. HDR_journal_file

Optional isc_dpb_version1 Version (must be first item!) isc_dpb_dummy_packet_interval Dummy packet interval 120 * isc_dpb_sql_dialect SQL dialect 3 Chapter 3. Databases 7 Parameter Description

(word) TIME 32 bits 0:00 to 23:59:59.9999 ISC_TIME. Time of day. It cannot be used to store an interval of time TIMESTAMP 64 bits (2 X 32 bits) From start of day 0001-01-01 AD to end of day 9999- An example is to subtract an earlier date, time or timestamp from a later one, resulting in an interval of time, in days and fractions of days. Table 5. Arithmetic Operations for Date and Time Data Types number of seconds specified in this clause. If the lock is unresolved at the end of the specified interval, the error message “Lock time-out on wait transaction” is returned to the client. Lock resolution

used to store an interval of time. TIME WITH TIME ZONE 6 bytes 0:00 to 23:59:59.9999 Time of day with either a time zone offset or named zone. It cannot be used to store an interval of time. TIMESTAMP An example is to subtract an earlier date, time or timestamp from a later one, resulting in an interval of time, in days and fractions of days. Table 8. Arithmetic Operations for Date and Time Data Types number of seconds specified in this clause. If the lock is unresolved at the end of the specified interval, the error message “Lock time-out on wait transaction” is returned to the client. Lock resolution

Связанное сообщение Примечание 22014 Invalid update value Неверное значение в операции update 22015 Interval field overflow Переполнение интервала в поле 22018 Invalid character value for cast Неверный символ пользователя (single-user shutdown); • 3 — полный останов (full shutdown). MON$SWEEP_INTERVAL INTEGER Интервал чистки (sweep interval). MON$READ_ONLY SMALLINT Признак, является база данных только для чтения, read

Number of DB pages allocated = 346 Number of DB pages used = 310 Number of DB pages free = 36 Sweep interval = 20000 Forced Writes are OFF Transaction - oldest = 236 Transaction - oldest active = 237 Transaction

parameter value 22011 Substring error 22012 Division by zero 22014 Invalid update value 22015 Interval field overflow 22018 Invalid character value for cast 22019 Invalid escape character 2201B Invalid Kompletter Shutdown Anhang E: Monitoringtabellen 680 Spaltenname Datentyp Beschreibung MON$SWEEP_INTERVAL INTEGER Sweep-Intervall MON$READ_ONLY SMALLINT Dieses Kennzeichen gibt an, ob die Datenbank im