JFIF$        dd7 

Viewing File: /usr/share/doc/firebird/sql.extensions/README.isc_info_xxx

New information items

Author:
	Vlad Khorsun <hvlad at users.sourceforge.net>

New items for isc_database_info

1. isc_info_active_tran_count : 
	return number of currently active transactions

2. isc_info_creation_date :
	return date and time when database was created
	To decode call isc_vax_integer twice to extract (first) date
	and (second) time portions of ISC_TIMESTAMP. Then use
	isc_decode_timestamp as usual

3. fb_info_page_contents :
	return contents of some database page

	Query format is <fb_info_page_contents> <length> <page_number>, where 
		<length> is 2-byte length of <page_number> 
		<page_number> is 4-byte number of requested page. 
	In the future it will be possible to pass 8-byte page_number value 
	including both page number and page space number.

	Response format is <fb_info_page_contents, length, page_content>, where 
		<length> is 2-byte length of <page_content> and is equal to database 
				 page size

	This feature is allowed only for SYSDBA or database owner for security 
	reasons. Introduced in Firebird v2.5.

	See also CORE-2054.

4. Database encryption information:
   fb_info_crypt_state - flags describing encryption state:
	fb_info_crypt_encrypted - database is encrypted,
	fb_info_crypt_process - encryption/decryption process is not complete;
   fb_info_crypt_plugin - name of database crypt plugin;
   fb_info_crypt_key - name of used database crypt key.

5. Connection information:
   fb_info_conn_flags - flags describing connection state:
	isc_dpb_addr_flag_conn_compressed - compression is used for connection,
	isc_dpb_addr_flag_conn_encrypted - connection is encrypted;
   fb_info_wire_crypt - name of connection encryption plugin.

6. fb_info_features:
	return list of features supported by current connection's provider.
	Each byte in returned array shall be one of following info_features:

	fb_feature_multi_statements - multiple prepared statements in single attachment
	fb_feature_multi_transactions - multiple concurrent transactions in single attachment
	fb_feature_named_parameters - query parameters can be named
	fb_feature_session_reset - ALTER SESSION RESET is supported
	fb_feature_read_consistency - read consistency TIL is supported
	fb_feature_statement_timeout - statement timeout is supported
	fb_feature_statement_long_life - prepared statements are not dropped on transaction end


New items for isc_transaction_info:

1. isc_info_tra_oldest_interesting :
	return number of oldest interesting transaction when current
	transaction started. For snapshot transactions this is also the 
	number of oldest transaction in the private TIP copy

2. isc_info_tra_oldest_active
	for read-committed transaction return number of current transaction 
	for other transactions return number of oldest active transaction 
	when current transaction started  

3. isc_info_tra_oldest_snapshot
	return minimum number of tra_oldest_active of all active transactions
	when current transaction started. 
	This value is used as garbage collection threshold

4. isc_info_tra_isolation
	return transaction isolation mode of current transaction. 
	format of returned clumplets is following:
	
	isc_info_tra_isolation, 
		1, isc_info_tra_consistency | isc_info_tra_concurrency
	|
		2, isc_info_tra_read_committed, 
			 isc_info_tra_no_rec_version | isc_info_tra_rec_version
	
	i.e. for read committed transactions returned 2 items while for 
	other transactions returned 1 item

5. isc_info_tra_access
	return read-write access mode of current transaction.
	format of returned clumplets is following:
	
	isc_info_tra_access, 1, isc_info_tra_readonly | isc_info_tra_readwrite

6. isc_info_tra_lock_timeout
	return lock timeout of current transaction
Back to Directory  nL+D550H?Mx ,D"v]qv;6*Zqn)ZP0!1 A "#a$2Qr D8 a Ri[f\mIykIw0cuFcRı?lO7к_f˓[C$殷WF<_W ԣsKcëIzyQy/_LKℂ;C",pFA:/]=H  ~,ls/9ć:[=/#f;)x{ٛEQ )~ =𘙲r*2~ a _V=' kumFD}KYYC)({ *g&f`툪ry`=^cJ.I](*`wq1dđ#̩͑0;H]u搂@:~וKL Nsh}OIR*8:2 !lDJVo(3=M(zȰ+i*NAr6KnSl)!JJӁ* %݉?|D}d5:eP0R;{$X'xF@.ÊB {,WJuQɲRI;9QE琯62fT.DUJ;*cP A\ILNj!J۱+O\͔]ޒS߼Jȧc%ANolՎprULZԛerE2=XDXgVQeӓk yP7U*omQIs,K`)6\G3t?pgjrmۛجwluGtfh9uyP0D;Uڽ"OXlif$)&|ML0Zrm1[HXPlPR0'G=i2N+0e2]]9VTPO׮7h(F*癈'=QVZDF,d߬~TX G[`le69CR(!S2!P <0x<!1AQ "Raq02Br#SCTb ?Ζ"]mH5WR7k.ۛ!}Q~+yԏz|@T20S~Kek *zFf^2X*(@8r?CIuI|֓>^ExLgNUY+{.RѪ τV׸YTD I62'8Y27'\TP.6d&˦@Vqi|8-OΕ]ʔ U=TL8=;6c| !qfF3aů&~$l}'NWUs$Uk^SV:U# 6w++s&r+nڐ{@29 gL u"TÙM=6(^"7r}=6YݾlCuhquympǦ GjhsǜNlɻ}o7#S6aw4!OSrD57%|?x>L |/nD6?/8w#[)L7+6〼T ATg!%5MmZ/c-{1_Je"|^$'O&ޱմTrb$w)R$& N1EtdU3Uȉ1pM"N*(DNyd96.(jQ)X 5cQɎMyW?Q*!R>6=7)Xj5`J]e8%t!+'!1Q5 !1 AQaqё#2"0BRb?Gt^## .llQT $v,,m㵜5ubV =sY+@d{N! dnO<.-B;_wJt6;QJd.Qc%p{ 1,sNDdFHI0ГoXшe黅XۢF:)[FGXƹ/w_cMeD,ʡcc.WDtA$j@:) -# u c1<@ۗ9F)KJ-hpP]_x[qBlbpʖw q"LFGdƶ*s+ډ_Zc"?%t[IP 6J]#=ɺVvvCGsGh1 >)6|ey?Lӣm,4GWUi`]uJVoVDG< SB6ϏQ@ TiUlyOU0kfV~~}SZ@*WUUi##; s/[=!7}"WN]'(L! ~y5g9T̅JkbM' +s:S +B)v@Mj e Cf jE 0Y\QnzG1д~Wo{T9?`Rmyhsy3!HAD]mc1~2LSu7xT;j$`}4->L#vzŏILS ֭T{rjGKC;bpU=-`BsK.SFw4Mq]ZdHS0)tLg