TOP をテンプレートにして作成
ホーム
バックアップ
一覧
検索
最終更新
ヘルプ
ログイン
開始行
* Command-line Utilities [#xf279d46]
cf) [[Firebird 2.5 Release Notes:http://www.firebirdsql.o...
** fbtracemgr [#x2e4fef6]
This is a new CLI utility for interfacing with the new tr...
fbtracemgr <action> [<parameters>]
*** Action Switches [#i3f436ce]
-STA[RT] Start trace session
-STO[P] Stop trace session
-SU[SPEND] Suspend trace session
-R[ESUME] Resume trace session
-L[IST] List existing trace sessions
*** Parameters [#kaaf1653]
Action parameters
-N[AME] <string> Session name
-I[D] <number> Session ID
-C[ONFIG] <string> Trace configuration file name
Connection parameters
-SE[RVICE] <string> Service name
-U[SER] <string> User name
-P[ASSWORD] <string> Password
-FE[TCH] <string> Fetch password from file
-T[RUSTED] <string> Force trusted authentication
*** Examples using fbtracemgr [#tefb45a4]
fbtracemgr -SE remote_host:service_mgr -USER SYSDBA -PAS...
fbtracemgr -SE service_mgr -START -NAME my_trace -CONFIG...
fbtracemgr -SE service_mgr -SUSPEND -ID 2
fbtracemgr -SE service_mgr -RESUME -ID 2
fbtracemgr -SE service_mgr -STOP -ID 4
Notes
All switches and parameter identifiers are case-insensitive
To stop an interactive trace session on any platform, pre...
*** V.2.5.1 Improvements [#b1d4130b]
The diagnostics of internal trace errors were improved. (...
Output is now flushed periodically. (Tracker reference CO...
** Retrieve Password from a File or Prompt [#y38db3e9]
Any command-line utility that takes a -password parameter...
As a second stage towards hiding the password from unauth...
*** New -fetch_password Switch [#h9ce9fa7]
Firebird 2.5 introduces the new switch -fet[ch_password] ...
PLEASE NOTE
The exception to the rules is the qli utility, for which ...
The new switch cannot be applied to substitute for the -p...
Usage of -fetch_password
The switch requires one parameter, an unquoted string tha...
For example,
isql -user sysdba -fet passfile server:employee
extracts the first line of from a file named “passfile” i...
The filename can be specified as stdin:
isql -user sysdba -fet stdin server:employee
If stdin is the terminal, a prompt is presented—
Enter password:
—requiring the operator to type in the password.
Tip
On POSIX, the operator will also be prompted if s/he spec...
-fetch /dev/tty
This technique could be useful if, for example, you neede...
bunzip2 -c emp.fbk.bz2 | gbak -c stdin /db/new.fdb
-user sysdba -fetch /dev/tty
** gsec [#bb6979ce]
The following improvements have been added for gsec:
Since v.2.1, Windows domain administrators have had full ...
In the Administrative Features chapter is a detailed over...
This automatic mapping can also be done in a gsec command...
*** Mapping an OS Administrator to the RDB$ADMIN Role [#a...
The new -mapping switch is used to enable or disable the ...
-mapping {set | drop}
Granting the RDB$ADMIN Role to a Firebird User
The introduction of the RDB$ADMIN system role has made it...
The same can be achieved in gsec using the new switch -ad...
-admin {YES | NO}
*** Command-line Help for gsec [#gc9a8b98]
Claudio Valderrama
Tracker reference: CORE-756)
Parameter help has been implemented for gsec, accessible ...
** fbsvcmgr [#f4ebd384]
Additions made to gsec and the Service Parameter Block (S...
for gsec -mapping, two new tag items: isc_action_svc_set_...
for gsec -admin: the new parameter isc_spb_sec_admin, of ...
For a full overview of the RDB$ADMIN role, refer to the t...
** gbak [#jfea27af]
*** Repair Switches for Malformed Strings [#o29e887c]
The gbak utility has two new restore switches intended to...
Switch Syntax
-FIX_FSS_D(ATA) <charset> -- fix malformed UNICODE_FSS ...
-FIX_FSS_M(ETADATA) <charset> -- fix malformed UNICODE_...
Hints with Malformed String Exceptions for Restores
(CORE-2754, A. dos Santos Fernandes)
When a restore fails with malformed string errors, gbak w...
*** Preserve Character Set Default Collation [#ca2152c1]
An improvement allows the current value of RDB$DEFAULT_CO...
Tracker reference CORE-789.
*** Improve Insertion Performance for Restore [#k16221f3]
Adriano dos Santos Fernandes
(v.2.5.1) Improved performance in the records insertion p...
Tracker reference CORE-3433.
** nBackup [#y37dce26]
*** New Switches Added [#f1e8054b]
Four switches were added to NBackup:
-FE <filename> Fetch password from file
-Z Print version information
-? Help
-D ON|OFF Force direct I/O on or off
-FE :: Supports the feature allowing the authentication p...
-Z :: Prints the version details of the nbackup executable.
-? :: Prints a terse list of usage instructions for the s...
-D :: ON option enables direct input and output operation...
Windows service-capable platforms
ON in all versions.
POSIX
OFF in 2.0-2.0.5, 2.1-2.1.2, 2.1.4, 2.5 and higher
ON in 2.1.3 and 2.0.6, provided O_DIRECT is available; ot...
Note
Using -D ON has no effect if neither O_DIRECT nor POSIX_F...
Note
Support for the new -D switch is also included among chan...
*** I/O Resource Load Reduced on POSIX [#h3b5c4d0]
An improvement has been done for POSIX versions to addres...
Note
The “cost” may be a 10 to 15 percent increase in the time...
Tracker reference CORE-2316.
** isql [#m482eaf0]
Some changes to the isql interactive query tool have been...
*** SQLSTATE instead of SQLCODE [#nc97cb0a]
isql now returns the SQLSTATE completion code in diagnost...
*** Improvement for Exponential Number Output [#tdad0be1]
Claudio Valderrama
Tracker reference CORE-1171.
isql has always output different formatting of numbers on...
select cast ('-2.488355210669293e+39' as double precision)
from rdb$database;
On POSIX, the result is -2.488355210669293e+39
On Windows, the result was -2.488355210669293e+039
The isql output has been modified so that the Windows out...
*** SHOW COLLATIONS in isql Help [#fb11fe23]
Help for SHOW COLLATIONS has been added to the command-li...
*** SET ROWCOUNT Statement Added [#j6193059]
Mark O'Donohue
Added mainly to assist testers, this command enables a li...
Example of Use
The following isql statement will stop returning rows aft...
SQL>set rowcount 10000;
** gpre (Precompiler) [#xbba1524]
*** Some Updates [#kedc8e1d]
Stephen Boyd
Adriano dos Santos Fernandes
Tracker reference CORE-1527.
GPRE now supports the IS NOT DISTINCT predicate and CASE/...
Deprecated Features with Future Impact on Utilities
In anticipation of the dropping of the intrinsic function...
** gstat [#j8f1cf3a]
Claudio Valderrama
Tracker reference CORE-1411.
The gstat statistics reporting utility now has -? and -he...
最終行:
* Command-line Utilities [#xf279d46]
cf) [[Firebird 2.5 Release Notes:http://www.firebirdsql.o...
** fbtracemgr [#x2e4fef6]
This is a new CLI utility for interfacing with the new tr...
fbtracemgr <action> [<parameters>]
*** Action Switches [#i3f436ce]
-STA[RT] Start trace session
-STO[P] Stop trace session
-SU[SPEND] Suspend trace session
-R[ESUME] Resume trace session
-L[IST] List existing trace sessions
*** Parameters [#kaaf1653]
Action parameters
-N[AME] <string> Session name
-I[D] <number> Session ID
-C[ONFIG] <string> Trace configuration file name
Connection parameters
-SE[RVICE] <string> Service name
-U[SER] <string> User name
-P[ASSWORD] <string> Password
-FE[TCH] <string> Fetch password from file
-T[RUSTED] <string> Force trusted authentication
*** Examples using fbtracemgr [#tefb45a4]
fbtracemgr -SE remote_host:service_mgr -USER SYSDBA -PAS...
fbtracemgr -SE service_mgr -START -NAME my_trace -CONFIG...
fbtracemgr -SE service_mgr -SUSPEND -ID 2
fbtracemgr -SE service_mgr -RESUME -ID 2
fbtracemgr -SE service_mgr -STOP -ID 4
Notes
All switches and parameter identifiers are case-insensitive
To stop an interactive trace session on any platform, pre...
*** V.2.5.1 Improvements [#b1d4130b]
The diagnostics of internal trace errors were improved. (...
Output is now flushed periodically. (Tracker reference CO...
** Retrieve Password from a File or Prompt [#y38db3e9]
Any command-line utility that takes a -password parameter...
As a second stage towards hiding the password from unauth...
*** New -fetch_password Switch [#h9ce9fa7]
Firebird 2.5 introduces the new switch -fet[ch_password] ...
PLEASE NOTE
The exception to the rules is the qli utility, for which ...
The new switch cannot be applied to substitute for the -p...
Usage of -fetch_password
The switch requires one parameter, an unquoted string tha...
For example,
isql -user sysdba -fet passfile server:employee
extracts the first line of from a file named “passfile” i...
The filename can be specified as stdin:
isql -user sysdba -fet stdin server:employee
If stdin is the terminal, a prompt is presented—
Enter password:
—requiring the operator to type in the password.
Tip
On POSIX, the operator will also be prompted if s/he spec...
-fetch /dev/tty
This technique could be useful if, for example, you neede...
bunzip2 -c emp.fbk.bz2 | gbak -c stdin /db/new.fdb
-user sysdba -fetch /dev/tty
** gsec [#bb6979ce]
The following improvements have been added for gsec:
Since v.2.1, Windows domain administrators have had full ...
In the Administrative Features chapter is a detailed over...
This automatic mapping can also be done in a gsec command...
*** Mapping an OS Administrator to the RDB$ADMIN Role [#a...
The new -mapping switch is used to enable or disable the ...
-mapping {set | drop}
Granting the RDB$ADMIN Role to a Firebird User
The introduction of the RDB$ADMIN system role has made it...
The same can be achieved in gsec using the new switch -ad...
-admin {YES | NO}
*** Command-line Help for gsec [#gc9a8b98]
Claudio Valderrama
Tracker reference: CORE-756)
Parameter help has been implemented for gsec, accessible ...
** fbsvcmgr [#f4ebd384]
Additions made to gsec and the Service Parameter Block (S...
for gsec -mapping, two new tag items: isc_action_svc_set_...
for gsec -admin: the new parameter isc_spb_sec_admin, of ...
For a full overview of the RDB$ADMIN role, refer to the t...
** gbak [#jfea27af]
*** Repair Switches for Malformed Strings [#o29e887c]
The gbak utility has two new restore switches intended to...
Switch Syntax
-FIX_FSS_D(ATA) <charset> -- fix malformed UNICODE_FSS ...
-FIX_FSS_M(ETADATA) <charset> -- fix malformed UNICODE_...
Hints with Malformed String Exceptions for Restores
(CORE-2754, A. dos Santos Fernandes)
When a restore fails with malformed string errors, gbak w...
*** Preserve Character Set Default Collation [#ca2152c1]
An improvement allows the current value of RDB$DEFAULT_CO...
Tracker reference CORE-789.
*** Improve Insertion Performance for Restore [#k16221f3]
Adriano dos Santos Fernandes
(v.2.5.1) Improved performance in the records insertion p...
Tracker reference CORE-3433.
** nBackup [#y37dce26]
*** New Switches Added [#f1e8054b]
Four switches were added to NBackup:
-FE <filename> Fetch password from file
-Z Print version information
-? Help
-D ON|OFF Force direct I/O on or off
-FE :: Supports the feature allowing the authentication p...
-Z :: Prints the version details of the nbackup executable.
-? :: Prints a terse list of usage instructions for the s...
-D :: ON option enables direct input and output operation...
Windows service-capable platforms
ON in all versions.
POSIX
OFF in 2.0-2.0.5, 2.1-2.1.2, 2.1.4, 2.5 and higher
ON in 2.1.3 and 2.0.6, provided O_DIRECT is available; ot...
Note
Using -D ON has no effect if neither O_DIRECT nor POSIX_F...
Note
Support for the new -D switch is also included among chan...
*** I/O Resource Load Reduced on POSIX [#h3b5c4d0]
An improvement has been done for POSIX versions to addres...
Note
The “cost” may be a 10 to 15 percent increase in the time...
Tracker reference CORE-2316.
** isql [#m482eaf0]
Some changes to the isql interactive query tool have been...
*** SQLSTATE instead of SQLCODE [#nc97cb0a]
isql now returns the SQLSTATE completion code in diagnost...
*** Improvement for Exponential Number Output [#tdad0be1]
Claudio Valderrama
Tracker reference CORE-1171.
isql has always output different formatting of numbers on...
select cast ('-2.488355210669293e+39' as double precision)
from rdb$database;
On POSIX, the result is -2.488355210669293e+39
On Windows, the result was -2.488355210669293e+039
The isql output has been modified so that the Windows out...
*** SHOW COLLATIONS in isql Help [#fb11fe23]
Help for SHOW COLLATIONS has been added to the command-li...
*** SET ROWCOUNT Statement Added [#j6193059]
Mark O'Donohue
Added mainly to assist testers, this command enables a li...
Example of Use
The following isql statement will stop returning rows aft...
SQL>set rowcount 10000;
** gpre (Precompiler) [#xbba1524]
*** Some Updates [#kedc8e1d]
Stephen Boyd
Adriano dos Santos Fernandes
Tracker reference CORE-1527.
GPRE now supports the IS NOT DISTINCT predicate and CASE/...
Deprecated Features with Future Impact on Utilities
In anticipation of the dropping of the intrinsic function...
** gstat [#j8f1cf3a]
Claudio Valderrama
Tracker reference CORE-1411.
The gstat statistics reporting utility now has -? and -he...
ページ名:
新規
名前変更
ホーム
一覧
検索
最終更新
バックアップ
ヘルプ
最終更新のRSS