Firebird-5-Release-Notes | Application Programming Interfaces | Extensions To Various Getinfo() Methods

Changes in the Firebird EngineReserved Words and Changes

Extensions to various getInfo() Methods

`Statement::getInfo()`

The following actions were added:

`isc_info_sql_exec_path_blr_bytes`	Execution path as BLR (binary format)
`isc_info_sql_exec_path_blr_text`	Execution path as BLR (textual format)

Services API Extensions

Support for parallel operations

Added support for parallel operations.

The following options were added:

`isc_spb_bkp_parallel_workers`	number of parallel workers for backup
`isc_spb_res_parallel_workers`	number of parallel workers for restore
`isc_spb_rpr_par_workers`	number of parallel workers for sweep

Examples of use of new parameters in fbsvcmgr utility (login and password were left out for brevity):

fbsvcmgr -action_backup -bkp_parallel_workers 4 <dbname> <backupname>
fbsvcmgr -action_restore -res_parallel_workers 4 <backupname> <dbname>
fbsvcmgr -action_repair -rpr_sweep_db -rpr_par_workers 4 <dbname>

Support for gfix -upgrade

Added support for minor ODS upgrade.

The following option was added:

isc_spb_rpr_upgrade_db

upgrade database

Example of use of new parameter in fbsvcmgr utility (login and password were left out for brevity):

fbsvcmgr -action_repair -rpr_upgrade_db <dbname>