Thank you Mark, it is very clear now.
Greetings.
Walter.
On Mon, Sep 9, 2013 at 8:24 AM, Mark Rotteveel wrote:
> On 9-9-2013 03:43, W O wrote:
> > 3. The restored database can have another 2.000.000.000 of commited
> > transactions, doing a total of 4.000.000.000 of commited transactions.
>
Evening Lane,
On 09/09/13 16:21, lcampbell wrote:
> OK, this is scary. How do I query the TID to determine if my DB is
> approaching the limit?
SQL> select MON$NEXT_TRANSACTION from mon$database;
MON$NEXT_TRANSACTION
785
or
$ fbstat -h employee | grep -i
Querying the MON$Database table.
Depending on your engine version (minor ODS) the current TID value should be
available as a column.
Sean
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of W O
Sent: Monday, September 09, 2013 12:14 PM
To: firebird-s
> On 9/8/2013 5:53 PM, Helen Borrie wrote:
>>
>> At 11:53 a.m. 9/09/2013, W O wrote:
>>
>> >Thank you very much for your answer Helen.
>> >
>> >I do backups every day, one full and several incrementals. Well,
>> rather it is done automatically by my program.
>>
>> That sounds like nBackup. Restorin
Excellent Lester!!!
That's the answer I was looking for.
Greetings.
Walter.
On Mon, Sep 9, 2013 at 3:31 AM, Lester Caine wrote:
> W O wrote:
> > 3. The restored database can have another 2.000.000.000 of commited
> > transactions, doing a total of 4.000.000.000 of commited transactions.
> I
On 9/8/2013 5:53 PM, Helen Borrie wrote:
At 11:53 a.m. 9/09/2013, W O wrote:
>Thank you very much for your answer Helen.
>
>I do backups every day, one full and several incrementals. Well,
rather it is done automatically by my program.
That sounds like nBackup. Restoring from nBackups does N
On 9-9-2013 03:43, W O wrote:
> 3. The restored database can have another 2.000.000.000 of commited
> transactions, doing a total of 4.000.000.000 of commited transactions.
> Is that right?
Yes and no. After a backup & restore you have a new database with one
committed transaction (that has the s
>Hi, every body!
> I have a problem. Ask everybody to help me.
> I have a table ,The table's DDL is
>
>Ext_Meter
>(
> ID integer,
> LastTime timestamp,
> LastReading numeric(12,2),
> Notes varchar(50)
>)
>
> TableA have about 10,000 rows, use it to record the last time and the last
> value
At 01:43 p.m. 9/09/2013, W O wrote:
>Thank you very much for answering me, Helen
>
>Well, I had not expressed well. My program does a full backup with GBAK every
>day, another full backup with NBACKUP and several incremental backups, all
>automatically. It does restore (when needed), send the b
W O wrote:
> 3. The restored database can have another 2.000.000.000 of commited
> transactions, doing a total of 4.000.000.000 of commited transactions. Is that
> right?
Yes
But another way of saying it is ... there is no limit on the number of
committed
transaction, as long as you backup and r
14 matches
Mail list logo