Re: [firebird-support] Very slow response after massive delete on table. (FB3 on Win 64)

Thank you, much appreciated.

Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits

, May 20, 2018 6:31 PM Subject: Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits > On 19-5-2018 15:00, fabia...@itbizolutions.com.au [firebird-support] > wrote: >> We are trying to define the best specs for a w

[firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits

We are trying to define the best specs for a windows based Firebird 3 64 bits instance. Based on our knowledge, and the type of applications running we know we will need the best possible performance for 1 to 10 concurrent users demanding queries (reading not writting) from just a few

Re: [firebird-support] Bulk upload options

hoogroups.com> To: <firebird-support@yahoogroups.com> Sent: Wednesday, May 16, 2018 7:10 PM Subject: Re: [firebird-support] Bulk upload options > 16.05.2018 4:48, fabia...@itbizolutions.com.au [firebird-support] wrote: >> Does anyone have experience with bulk updates via isql? Woul

Re: [firebird-support] Bulk upload options

ebird-support@yahoogroups.com> To: <firebird-support@yahoogroups.com> Sent: Wednesday, May 16, 2018 7:10 PM Subject: Re: [firebird-support] Bulk upload options > 16.05.2018 4:48, fabia...@itbizolutions.com.au [firebird-support] wrote: >> Does anyone have experience with bulk updates via isql?

Re: [firebird-support] Bulk upload options

a in fixed length format): INSERT INTO MY_REAL_TABLE(ID, NAME) SELECT ID, NAME FROM BCP_DATA; I think this solutions will do - Original Message - From: "fabia...@itbizolutions.com.au [firebird-support]" <firebird-support@yahoogroups.com> To: <firebird-

[firebird-support] Bulk upload options

I am looking for the fastest way to run a bulk insert. I believe one way would be using isql.exe , I need to plan a solution to upload into a single table around 500 million records. Does anyone have experience with bulk updates via isql? Would it be X times faster than using a normal

[firebird-support] Attempt to set in database number of buffers which is out of acceptable range ...

Hi All Our production server is a Win 64 massive ram memory Firbierd 3 64bits, and our development server is a VM on Win 32 with Fb 3 (32 bits) When we backup the database from the production x64 server, and try to retore it on the win32 server we usually get the following message: Attempt to

Re: [firebird-support] SS FB3.01 - Is it possible to set CPU utilization to max?

Anto Each "request" to the database is managed by one CPU, and 6 CPU will be used in full when 6 concurrent requests are passed to Firebird, however to get Firebird to process each request with all available CPUs is not possible at the moment, it would require a re-write of Firebird. Regards

Re: [firebird-support] Overflow problem

Are you trying to store details of the American public debt? or the world's public debt? Just kiding Not How about assigning another integer field to each record with a value representing the "segment" for the value you are trying to store, and then use an index on that value, I'll explain

[firebird-support] Explicit Transaction + Suspend

Just wondering can my app start a transaction with Begin Transaction and then call a stored procedure that contains the SUSPEND sentence at the end while the transaction is still opened? Is there any special consideration when comencing a transaction other than to ensure the process finished as

Re: [firebird-support] Safe Thread - ODBC

SOLVED - Changed code to use explicit transactions and the problem went away, so I guess implicit transactions was "keeping the transaction opened" for a few extra milliseconds... while the other "process / thread / or ODBC object" was trying to read the data added by the last transaction, and

[firebird-support] Safe Thread - ODBC

We have a multithreaded app written in Clarion 9 (win32), running on several win 2012 64 bits r2, connecting to Firebird 3 (latest build) via ODBC 32 bits (latest ODBC). We are experiencing a rare propblem, that happens not very often. The issue is as follows: The application does not use

[firebird-support] How to "embedded mode" configure and shipping with an App

We are trying to configure and package Firebird 3 as an embedded database with our App. Could someone provide an example of how to do it please? We have configured Firebird to work as embedded locally but we need to ship all files into one directory with our app, and don't know what files are

[firebird-support] Encryption on FB3

Hi Guys We are considering encrypting the DB, we are on FB 3 on top of Windows 2012 R2 64 bits, the options we have are: 1) Do what we did with FB2, that is encrypt the DB folder with the same user account as the firebird service was running on, and nevel login with that user. That is an OS

Re: [firebird-support] Re: Nbackup restored database size is 50 Mega shorter than original DB

Thanks Vlad - Original Message - From: "hv...@users.sourceforge.net [firebird-support]" To: Sent: Wednesday, September 21, 2016 6:00 AM Subject: [firebird-support] Re: Nbackup restored database size is 50 Mega

[firebird-support] FB 3.0 + ODBC

This is a message to the development team, including all testers, documenters, project management, etc After almost 14 years using Firebird (from version 1 candidate release 3) until today, with FB 3 migration just finalized on Tuesday night this week, with 3 databases (100Mb, 7GB and 70Gb)

Re: [firebird-support] Gbak performance issues on FB3

Ahhh, OK, thanks!!

Re: [firebird-support] "nbackup needs local access to database file"

[firebird-support] To: firebird-support@yahoogroups.com Sent: Sunday, September 11, 2016 5:11 PM Subject: Re: [firebird-support] "nbackup needs local access to database file" On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote: > I am getting this error

Re: [firebird-support] Gbak performance issues on FB3

- Original Message - From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] To: firebird-support@yahoogroups.com Sent: Sunday, September 11, 2016 5:09 PM Subject: Re: [firebird-support] Gbak performance issues on FB3 On 10-9-2016 22:11, fabia...@itbizolutions.com.au [firebird

[firebird-support] "nbackup needs local access to database file"

be running as embebed and it is a superserver with active network connections. Any ideas? - Original Message - From: fabia...@itbizolutions.com.au [firebird-support] To: firebird-support@yahoogroups.com Sent: Sunday, September 11, 2016 6:11 AM Subject: [firebird-support] Gbak p

[firebird-support] Gbak performance issues on FB3

I am running both gbak.exe and nbackup.exe on an FB3 server with Windows 2012 R2 64 bits, 24 processor, 192 GB ram, the nbackup.exe level zero is much faster than the gbak.exe (does not make any sense, it should take about the same time as gbak), both running locally but connecting using the

Re: [firebird-support] "File Database is not found" error appears while the database is been backup with gbak

To Make it perfectly clear, the following statment works: gbak -b -v -z -user SYSDBA -pas Hello-2 -T localhost:DB_FB3.fdb c:\Temp\DB.Fbk And the following DOES NOT work: gbak -b -v -z -user SYSDBA -pas 'Hello-2 -T' localhost:DB_FB3.fdb c:\Temp\DB.Fbk (note the quotes enclosing the password)

Re: [firebird-support] "File Database is not found" error appears while the database is been backup with gbak

ars while the database is been backup with gbak 10.09.2016 17:10, fabia...@itbizolutions.com.au [firebird-support] wrote: > what can I do to run a 24x7 system and have backups every so often without shutting down > the system for a few minutes? Don't ever use embedded connection

Re: [firebird-support] "File Database is not found" error appears while the database is been backup with gbak

: Sunday, September 11, 2016 1:19 AM Subject: Re: [firebird-support] "File Database is not found" error appears while the database is been backup with gbak 10.09.2016 17:10, fabia...@itbizolutions.com.au [firebird-support] wrote: > what can I do to run a 24x7 system and have bac

[firebird-support] "File Database is not found" error appears while the database is been backup with gbak

Hi I just upgraded to FB 3 and the server has a task scheduled after midnight to execute gbak for all 3 databases on the server. I've noticed the database connection attempts fail during the gbak execution. Is this a new "restriction" on gbak FB3? The specifics: gbak with version

Re: [firebird-support] Re: Problems after FB3 upgrade

night as Dimitry explained and FB seems fine) Regards Tony On 08/09/2016 9:23 AM, fabia...@itbizolutions.com.au [firebird-support] wrote: After replacing the existing install with the snapshot I am getting the following error on connection: Connecting... Failed

Re: [firebird-support] Re: Problems after FB3 upgrade

After replacing the existing install with the snapshot I am getting the following error on connection: Connecting... Failed! Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements. Install incomplete,

Re: [firebird-support] Re: Problems after FB3 upgrade

@yahoogroups.com Sent: Wednesday, September 07, 2016 11:06 PM Subject: Re: [firebird-support] Re: Problems after FB3 upgrade 07.09.2016 14:23, fabia...@itbizolutions.com.au [firebird-support] wrote: > Would you recommend installing the latest snapshot, or stay with the released FB3 vers

Re: [firebird-support] Re: Problems after FB3 upgrade

Hi All We are going live with the upgrade to FB3 this comming Friday night. Would you recommend installing the latest snapshot, or stay with the released FB3 version? I have read some posts mentioning an issue with "invalid transaction handle" and would like to avoid getting my customer into

Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

Would it be possible that the original update triggered a second update on the same record, hence the value of new and old are the same? For instance a trigger after update calls a procedure to update the same record, the first run of the trigger will have old <> new, but perhaps on the second

Re: [firebird-support] Firebird 3 performance

Hello It is my understanding that the difference in performance is not as in previous versions because the server model has been changed to have multiple processors to attend to multiple requests, however each request is only served by one processor. In other words the FB3 server can assign

[firebird-support] How to make available a Firebird tool I prepared

Hi All This may not be the right place to ask, I have prepared a tool that optimazes and automates the backup for Firebird Databases, providing a backup almost up to the last minute for large production databases (That was the aim when we planned it). I would like tomake it available to other

Re: [firebird-support] Unable to backup production database with gbak and SuperServer 3

Hi Martin Now the error is regarding the user and password, that is good news, the engine trying to grab the DB is the superserver, not the local embedded. Now regarding the user and password, there are big changes in FB3 with security, can I recommend you read the release notes where it

Re: [firebird-support] Engine12 mistery

ry Sibiryakov s...@ibphoenix.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Wednesday, June 15, 2016 6:56 PM Subject: Re: [firebird-support] Engine12 mistery 14.06.2016 22:46, fabia...@itbizolutions.com.au [firebird-support] wrote: > It seems Engine12 is not the same

Re: [firebird-support] Engine12 mistery

12 mistery On 2016-06-14 19:44, fabia...@itbizolutions.com.au [firebird-support] wrote: > My understanding from reading the documentation is: > > Provider = Remote means the client is on the network, excluding > 127.0.0.1 > Provider = Loopback means the client i

Re: [firebird-support] Engine12 mistery

My understanding from reading the documentation is: Provider = Remote means the client is on the network, excluding 127.0.0.1 Provider = Loopback means the client is actually on the same OS instance as the FB3 engine, and it is using the 127.0.0.1 to access the database to avoid the "embedded

[firebird-support] Engine12 mistery

Hi All, Is there a reason why the FB 3 server configured as follows would require Engine12 as a provider? DatabaseAccess = None AuthServer = Srp AuthClient = Srp UserManager = Srp Providers = Remote WireCrypt = Enabled WireCompression = false ServerMode = Super I've noticed the

Re: [firebird-support] FB3 - Is RemoteBindAddress a Serverwide variable or a Database linked variable?

I'll answer myself for 2) 2) page 42 of http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf 1) and 3) remain a question Cheers Fabian - Original Message - From: fabia...@itbizolutions.com.au [firebird-support] To: firebird-support

[firebird-support] FB3 - Is RemoteBindAddress a Serverwide variable or a Database linked variable?

Now that I have the production candidate FB 3 server up and running I am doing some fine tunning, and there a few questions I'd like to ask: 1) The variable "RemoteBindAddress" in firebird.conf is a Server Wide value, or it can be set per database in databases.conf? 2) The "WireCompression"

Re: [firebird-support] FB 3 - Adding anew User

w.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > Cheers, > Fabian > > - Original Message - > From: fabia...@itbizolutions.com.au [firebird-support] > To: fire

Re: [firebird-support] FB 3 - Adding anew User

Hi Helen I understand, I have read the comments, we are reffering to two different things, I mean the sentence in step 2) not further ahead, the sentence as placed on the Release Notes to execute the isql program fails to execute unless it contains the passowrd. What I am referring to is

Re: [firebird-support] FB 3 - Adding anew User

tence works probably on Linux but on Ms WIn 2012 Server R2 it requires the password to run. Cheers, Fabian - Original Message - From: fabia...@itbizolutions.com.au [firebird-support] To: firebird-support@yahoogroups.com Sent: Monday, June 13, 2016 4:34 AM Subject: [firebird-su

[firebird-support] FB 3 - Adding anew User

Hi All, I have configured the FB 3 server to only accept SRP connections and need to add a new User to the security DB, I read GSEC is not the way, and I have tried with isql but for some reason I am not having luck, I am trying the following: I created a script into a file as follows: SET

Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

FB 3.0 64bit is to small? 02.06.2016 15:12, fabia...@itbizolutions.com.au [firebird-support] wrote: > the limit remains as in FB 2.5, meaning you cannot enter a value above 131071 pages , now > I don't know if the bug is on IBExpert, or if Firebird 3.0 rejects the value. Tr

Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

Anto Could you let me know how you setup the DB cache value? I mean what tool or sentence are you using to set it and then check it, because I am having trouble setting the value above 131071 pages with IBexpert, probably an IBExpert bug, but I just want to be sure it is not something else,

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

accidentally? Thanks Rob On 2/06/2016 11:12 a.m., fabia...@itbizolutions.com.au [firebird-support] wrote: Dmitry Something funny is going on regarding the memory consumption, I have attached screenshots showing the memory counters. If you look at the process itself (file

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Dmitry Something funny is going on regarding the memory consumption, I have attached screenshots showing the memory counters. If you look at the process itself (file TaskManager_Process_Firebird_Only_Consumed_2GB.jpg), it only consumed 2 GB. If you look at Windows Task Manager (file

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Hi Dmitry I am progressing with solving this one, the first issue was related with a config variable reserving most of the ram upfront, hence there was no ram available for the DB cache. The second issue was misinterpreting what the following meant: # File system cache size # Note that the

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Vlad Thank you, english is not my first language, I interpreted the sentence as "go calculate the total amount of ram, then set the value as a number within such percentage of your ram...", but thanks for the clarification. Perhaps to avoid other users making the same mistake each configurable

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

Dimitry That is my concern, on FB 2.5 I was able to see the memory allocated as soon as the first connection is granted to the DB, but on FB 3 I am not seeing almost any memory been allocated what makes me believe that something is not right. However as more users connect and use the DB, the

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

...@itbizolutions.com.au [firebird-support] firebird-support@yahoogroups.com: Hi All We are having trouble setting up the database cache size on FB 3.0 running on Windows 2008 R2 64 bits with 32 GB ram. The problem we have is we cannot get the server to allocate the ram

[firebird-support] Issue with Database Cache Size on FB 3.0

Hi All We are having trouble setting up the database cache size on FB 3.0 running on Windows 2008 R2 64 bits with 32 GB ram. The problem we have is we cannot get the server to allocate the ram for the cache as we intend. With FB 2.54 we had the DB cache set very high, close to 1 GB per

[firebird-support] Risks - Experience and doubts regarding upgrading to FB 3.0 from 2.54?

Hi Again We are about to upgrade from Windows 2008 FB 2.54 64 bits into Windows 2012 R2 FB 3.0 64 bits, and would appreciate comments from experienced DB administrators. We use FB as the main DB, and we access it via 32 bit native ODBC (the latest version of Firebird ODBC). I would

Re: [firebird-support] Is Firebird 3 ready for Production?

] Is Firebird 3 ready for Production? 24.05.2016 18:38, Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] wrote: > And regarding the replication, any advise on what product may be the right choice? I would recommend to look at IBPhoenix Replicator. h

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au [firebird-support] <firebird-support@yahoogroups.com> wrote: Now on the flip side, the performance sucks, it is worst than with FB 2.54, and when looking at the task manager on windows it appears only one processor it do

Re: [firebird-support] FB 3 - SMP switched off ?

...@itbizolutions.com.au [firebird-support] wrote: > Do you know if it is planned for Firebird to distribute each client request across all > CPUs? When? Parallel execution of a single request is not planned at all yet. -- W

Re: [firebird-support] Is Firebird 3 ready for Production?

Re: [firebird-support] Is Firebird 3 ready for Production?I see, will read it Cheers Fabian - Original Message - From: 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] To: fabia...@itbizolutions.com.au [firebird-support] Sent: Thursday, May 26, 2016 6:01 AM

Re: [firebird-support] FB 3 - SMP switched off ?

, Fabian - Original Message - From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, May 26, 2016 6:01 PM Subject: Re: [firebird-support] FB 3 - SMP switched off ? 25.05.2016 19:34, fabia...@itbizolutions.com.au

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

-support@yahoogroups.com Sent: Thursday, May 26, 2016 4:53 AM Subject: Re: [firebird-support] Re: Is Firebird 3 ready for Production? On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au [firebird-support] <firebird-support@yahoogroups.com> wrote: Now on the fli

[firebird-support] FB 3 - SMP switched off ?

Hi All First of all CONGRATS to all developers for the 3.0 project, the Firebird DB engine has been an excelent tool for us for more than a decade, and we do appreciate the efforts and great product the developing team has created! Specifically to the SMP capable feature, we are not sure

Re: [firebird-support] Is Firebird 3 ready for Production?

Thanks Alexey, will try it and post back with comments - Original Message - From: Alexey Kovyazin a...@ib-aid.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, May 26, 2016 6:58 AM Subject: Re: [firebird-support] Is Firebird 3 ready for Production?

Re: [firebird-support] Is Firebird 3 ready for Production?

Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset NONE), and now the backup and restore workes fine, with no errors. I've noticed the new FB3 DB has now two SYSDBA users, one

Re: [firebird-support] FB 3 issues with String from FB 2.54

Subject: Re: [firebird-support] FB 3 issues with String from FB 2.54 On 23-5-2016 03:45, fabia...@itbizolutions.com.au [firebird-support] wrote: > I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and > after hitting a string related error for some time i ha

Re: [firebird-support] FB 3 issues with String from FB 2.54

Hi Kjell We had a FB 2.54 DB with a few varchars defined as charset ASCII, the intention was to stop users from entering unreadable characters, so the charset was there to attempt to filter garbage, at least that was the idea), anyways we converted all domains from charset ASCII to NONE, and

[firebird-support] Re: Is Firebird 3 ready for Production?

Pete Thanks for your input. We managed to get the DB upgraded to 3.0 (removed all charset ASCII definitions on fields while on 2.54, then backup the DB and restored it on 3.0, and it all worked). Now on the flip side, the performance sucks, it is worst than with FB 2.54, and when looking

[firebird-support] Is Firebird 3 ready for Production?

Hi All We have a multi-user, multi-company, cloud based system running with Firebird 2.54 as the main database, with about 100 concurrent connections. We are considering migrating to FB 3.0 to take advantaje of the SMP architecture, we have a 32 core / processors server, so we are hopping to

[firebird-support] Re: ODP: FB 3 issues with String from FB 2.54

liviuslivius liviuslivius poczta.onet.pl [firebird-support] yahoogroups.com> writes: > > > > > > > hi, > > will be good to know which charsets did you tried. utf8, none, octets... > > but remember to connet to db also with this charset settings > > regards, > Karol Bieniaszewski >

[firebird-support] FB 3 issues with String from FB 2.54

Hi All I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and after hitting a string related error for some time i have got to the point where I do understand the issue, but I don't know how to solve it. The issue is pretty simple, the FB 2.54 DB contains a few characters