Improvements and additions to the Firebird utilities continue.
Improvements and additions to the Firebird utilities continue.
New virtual tables:
RDB$KEYWORDS
:
RDB$KEYWORD_NAME
|
Keyword name |
RDB$KEYWORD_RESERVED
|
Whether keyword is a reserved word |
MON$COMPILED_STATEMENTS
:
MON$COMPILED_STATEMENT_ID
|
Compiled statement ID |
MON$SQL_TEXT
|
Text of the SQL query |
MON$EXPLAINED_PLAN
|
Plan (in the explained form) of the SQL query |
MON$OBJECT_NAME
|
PSQL object name |
MON$OBJECT_TYPE
|
PSQL object type |
MON$PACKAGE_NAME
|
Package name of the PSQL object |
MON$STAT_ID
|
Runtime statistics ID (references |
New columns in the tables:
In MON$ATTACHMENTS
:
MON$SESSION_TIMEZONE
|
Actual timezone of the session |
In MON$STATEMENTS
:
MON$COMPILED_STATEMENT_ID
|
Compiled statement ID (references |
In MON$CALL_STACK
:
MON$COMPILED_STATEMENT_ID
|
Compiled statement ID (references |
In SEC$GLOBAL_AUTH_MAPPING
:
SEC$DESCRIPTION
|
Textual description |
Adriano dos Santos Fernandes
Tracker ticket: #6910
The SET EXEC_PATH_DISPLAY
command is a debug command to show the BLR (compiled form) of the statement.
When a statement is executed, it retrieves the compiled execution path of a DML statement formatted as BLR text.
SET EXEC_PATH_DISPLAY {BLR | OFF};
Warning
|
This feature is intimately tied to engine internals. Its usage is discouraged if you do not understand very well how these internals are subject to change between versions. |
Vlad Khorsun
A new command-line switch has been added to gbak: -PAR[ALLEL] <N>
.
It defines how many parallel workers will be used for the requested task.
Usage examples:
gbak -b -par 4 -user <username> -pass <password> <dbname> <backupname>
gbak -r -par 4 -user <username> -pass <password> <backupname> <dbname>
Vlad Khorsun
A new command-line switch has been added to gfix: -PAR[ALLEL] <N>
.
It defines how many parallel workers will be used for the requested task.
Usage example:
gfix -sweep -par 4 -user <username> -pass <password> <dbname>
gfix -icu -par 4 -user <username> -pass <password> <dbname>
The -parallel
option is only valid in combination with the -sweep
and -icu
tasks.
Dmitry Yemanov
Tracker tickets: #7397
A new command-line switch has been added to gfix: -UP[GRADE]
.
It allows to upgrade ODS of the database to the latest supported minor version (within the supported major version).
Usage example(s):
gfix -upgrade <dbname> -user <username> -pass <password>