Sabtu, April 11, 2009

fbsvcmgr, Firebird 2.x Command Line Tools Untuk Mengakses Service

Utility fbsvcmgr mulai ada di Firebird 2.1, berguna untuk mengakses firebird server secara command line. Fitur seperti ini sangat membantu untuk melihat server secara remote, dimana koneksi dari tools ber-GUI rada sulit.

Sintaks fbsvcmgr:
fiya@quantan-priska:~$ /usr/local/firebird/bin/fbsvcmgr
Usage: fbsvcmgr manager-name switches...
Manager-name should be service_mgr, may be prefixed with host name
according to common rules (host:service_mgr, \\host\service_mgr).
Switches exactly match SPB tags, used in abbreviated form.
Remove isc_, spb_ and svc_ parts of tag and you will get the switch.
For example: isc_action_svc_backup is specified as action_backup,
isc_spb_dbname => dbname,
isc_info_svc_implementation => info_implementation,
isc_spb_prp_db_online => prp_db_online and so on.
You may specify single action or multiple info items when calling fbsvcmgr once.
Full command line samples:
fbsvcmgr service_mgr user sysdba password masterke action_db_stats dbname employee sts_hdr_pages
(will list header info in database employee on local machine)
fbsvcmgr yourserver:service_mgr user sysdba password masterke info_server_version info_svr_db_info
(will show firebird version and databases usage on yourserver)

SPB adalah Service Parameter Block.

Contoh :
fiya@quantan-priska:~$ sudo /usr/local/firebird/bin/fbsvcmgr service_mgr info_server_version info_svr_db_info info_implementation
Server version: LI-T2.5.0.23247 Firebird 2.5 Beta 1
Number of attachments: 0
Number of databases: 0
Server implementation: Firebird/linux Intel

Contoh lain:
# fbsvcmgr service_mgr -user sysdba -password masterke -action_display_use

Daftar Service Parameter Block:

Tidak ada komentar: