Hello
We are trying to migrate some existing users to the new RDB$ADMIN using some
dynamic SQL. We have the following SQL
for
--Gets a list of users from our system
select ib_username from user_group_users where user_group_no = 1
into :v_username
do
begin
--Give the user
Hello, Aage!
Friday, April 13, 2012, 11:55:38 PM, you wrote:
AJ gbak -se service_mgr
AJ -fix_fss_metadata ISO8859_1
AJ -fix_fss_data ISO8859_1
AJ -rep -v -z
AJ -user SYSDBA -password masterkey
AJ E:\...\...\sl1b3_20120412.fbk15 SL1
AJ ==
AJ Previous restores have
On Mon, 16 Apr 2012 16:10:21 +0200, Olaf Kluge olaf.kl...@satron.de
wrote:
Now I have two ideas. I create a table with all fields (separate for
each
information) and an import stored procedure fill this table with
information
from the long string. (line_number = substring(:str_in from 1 for
Nick,
FBScanner
http://ib-aid.com/products/firebird_interbase/monitoring/FBScanner
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
I'm looking for suggestion as to the best way to monitor my
installations for slow queries, etc
the only options I have been able to identify is to write my own isql
Dmitry Kuzmenko wrote:
if you run same command line for the same DB, i.e.
backup/restore, backup/restore, etc, than you killed metadata in it.
I think we are facing a major misunderstanding. Note, there are 2
sites involved.
1.
Site A is running Fb/1.5. A backup is made nightly from a
Dmitry Kuzmenko schrieb am 16.04.2012 um 10:59 (+0400):
Friday, April 13, 2012, 11:55:38 PM, you wrote:
AJ gbak -se service_mgr
AJ -fix_fss_metadata ISO8859_1
AJ -fix_fss_data ISO8859_1
AJ -rep -v -z
AJ -user SYSDBA -password masterkey
AJ E:\...\...\sl1b3_20120412.fbk15 SL1
AJ