[firebird-support] Unsubscribe
[Non-text portions of this message have been removed]
[firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?
Hi guys. My application needs to call gfix every day to check our clients databases. How can I know the result of gfix execution? I would not like to parse the output messages from the console. I would like to know the ExitCode returned by the gfix executable but I can not find description for it on the Internet. Could anyone provide me with this information? Thanks.
Re: [firebird-support] Computed field Dependencies
Hi Martijn, i did what u said, but when i try to alter the field in Database Workbenc it shows me the same thing: Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536 i cant find this dependencie, i´m so disappointed with Firebird :-( could u explain me in detail how to do that ? thanks a lot Em 08-04-2013 10:32, Martijn Tonies escreveu: > > Hello Gugui, > > > I´m just trying to increase the varchar field type, so i´ve solved all > > the dependencies, but there is one that i can´t solve and it is a > > Computed Field type ! > > > > when i try: > > > > ALTER TABLE CLIENTE ALTER RAZAO_SOCIAL TYPE VARCHAR(60); > > > > returns: > > > > Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536 > > > > in the RDB$DEPENDENCIES table: > > > > RDB#DEPENDENT_NAME RDB$DEPEPENDED_ON_NAME RDB$FIELD_NAME > > RDB$DEPENDENT_TYPE > > RDB$1536 CLIENTE RAZAO_SOCIAL 3 > > RDB$1536 CLIENTE IDCLIENTE > > 3 > > RDB$1536 PEDIDO IDCLIENTE > > 3 > > RDB$1536 CLIENTE [null] > > 3 > > > > > > RDB$DEPENDENT_TYPE = 3 = Computed Field > > > > how to solve it ? > > You cannot, easily. ;) > > Download Database Workbench at www.upscene.com - alter the computed by > field > and it will generate the required statements for you. > > Note: it's tricky, but has been proven as working. > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com > > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL > Anywhere, MySQL, InterBase, NexusDB and Firebird! > > ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?
Hej, AFAIK there are no dedicated return codes for gfix. So you'll get a non-zero return code if there is a problem while executing gfix, but not from gfix when there are any problems with a database. cheers, Marcus un_spoken schrieb: > Hi guys. > > My application needs to call gfix every day to check our clients databases. > How can I know the result of gfix execution? I would not like to parse the > output messages from the console. I would like to know the ExitCode returned > by the gfix executable but I can not find description for it on the Internet. > > Could anyone provide me with this information? > > Thanks. > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > >
Re: [firebird-support] Computed field Dependencies
Hi, > Hi Martijn, i did what u said, but when i try to alter the field in > Database Workbenc it shows me the same thing: > > Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536 > > i cant find this dependencie, i´m so disappointed with Firebird :-( > > could u explain me in detail how to do that ? Hm, that is surprising. Newer versions of Firebird support altering the COMPUTED BY clause. What version of Firebird are you using? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?
> Could anyone provide me with this information? http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-caveats.html#d0e30504 Sadly, that's not much use. It's the part of the gfix manual that says "almost all exit codes from gfix, even up to version 2, are zero". I haven't tested gfix 2.5 yet, but at least as far as 2.0 it's almost always zero, even in the event of a problem. I'll check and get back tou you to see if there's anything in the release notes from 2.0 onwards that may have changed this. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?
On 09/04/13 14:35, Norman Dunbar wrote: > I'll check and get back tou you to see if there's anything in the > release notes from 2.0 onwards that may have changed this. I've checked all the release notes and it seems the error reporting problem was raised as CORE-1548 on tracker, and was fixed in 2.1 RC1. I checked my 2.5.1 gfix and attempting to shutdown a shut database returns 1 while a successful shutdown returns 0. So, you might need to be on at least 2.1 RC1 to get the benefits. HTH Cheers, Norm. PS. I'll update the docs to clarify this. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
Re: [firebird-support] Computed field Dependencies
hi Marijn, i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0 Em 09-04-2013 10:31, Martijn Tonies escreveu: > Hi, > >> Hi Martijn, i did what u said, but when i try to alter the field in >> Database Workbenc it shows me the same thing: >> >> Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536 >> >> i cant find this dependencie, i´m so disappointed with Firebird :-( >> >> could u explain me in detail how to do that ? > Hm, that is surprising. > > Newer versions of Firebird support altering the COMPUTED BY clause. > > What version of Firebird are you using? > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com > > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL > Anywhere, MySQL, InterBase, NexusDB and Firebird! > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > > > ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Computed field Dependencies
Hi, > i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0 In that case, here's how DBW does it for you: // delete field dependencies for field "MYTESTFIELD" delete from rdb$dependencies where rdb$dependent_name = (select f.rdb$field_name from rdb$fields f join rdb$relation_fields rf on rf.rdb$field_source = f.rdb$field_name where rf.rdb$relation_name = 'DML_TEST1' and rf.rdb$field_name = 'MYTESTFIELD'); // add temporary test field ALTER TABLE DML_TEST1 ADD DBW$$TEMP COMPUTED BY ( 'test' || 'moere' ); // copy generated BLR from temp test field to your test field UPDATE rdb$fields SET RDB$COMPUTED_BLR = (select RDB$COMPUTED_BLR from rdb$fields where rdb$field_name = (select rdb$field_source from rdb$relation_fields where rdb$field_name = 'DBW$$TEMP' and rdb$relation_name = 'DML_TEST1')), RDB$COMPUTED_SOURCE = (select RDB$COMPUTED_SOURCE from rdb$fields where rdb$field_name = (select rdb$field_source from rdb$relation_fields where rdb$field_name = 'DBW$$TEMP' and rdb$relation_name = 'DML_TEST1')) WHERE rdb$field_name = (select rdb$field_source from rdb$relation_fields where rdb$relation_name = 'DML_TEST1' and rdb$field_name = 'MYTESTFIELD'); COMMIT; // create valid new dependencies insert into rdb$dependencies select * from rdb$dependencies where rdb$dependent_name = (select f.rdb$field_name from rdb$fields f join rdb$relation_fields rf on rf.rdb$field_source = f.rdb$field_name where rf.rdb$relation_name = 'DML_TEST1' and rf.rdb$field_name = 'DBW$$TEMP'); // drop temporary computed field ALTER TABLE DML_TEST1 DROP DBW$$TEMP; If this doesn't help for you, I'd be interested in a copy of the database to see what's going on. ;) Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Computed field Dependencies
On Tue, 09 Apr 2013 10:51:43 -0300, Gugui wrote: > hi Marijn, > > i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0 Alter table for computed fields was added in Firebird 2.5: http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-table.html#langrefupd25-alter-table Mark
Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?
On 09/04/13 14:50, Norman Dunbar wrote: > PS. I'll update the docs to clarify this. I've updated the docs for gfix to reflect the fact that prior to 2.1RC1 error exits were zero, regardless, but since 2.1RC1, success returns zero while errors return 1. A new pdf is available at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-gfix.pdf and html is online at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix.html - although you may need to refresh your cache to make sure you have the latest. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767
[firebird-support] Database version
Hello, what is the best approach to assign a version to the database. Let's say it's starts with 1.0.1.1 then 1.0.1.2.. etc,, I'm looking at storing it with the DB itself. Is there a way to store it and read it from system variables?.. I wanted to use a DB field but it sounds too much for what I want to accomplish. Thank you, -Halim
RE: [firebird-support] Database version
> what is the best approach to assign a version to the database. > Let's say it's starts with 1.0.1.1 then 1.0.1.2.. etc,, I'm looking at > storing it with > the DB itself. Is there a way to store it and read it from system variables?.. > I wanted to use a DB field but it sounds too much for what I want to > accomplish. We created an SP (Get_Schema_Version) which we update when we deploy new schema. Sean
[firebird-support] Re: Restart and stop Firebird 2.5.2 on Linux
Hola Maximiliano: Efectivamente tenemos Ubuntu 10.4 Muchas gracias por la ayuda. Lo llevaré a cabo y espero que ya no tenga más preguntas respecto a esto. Saludos! Atte: Jorge Botello --- In firebird-support@yahoogroups.com, Maximiliano Robaina wrote: > > De: jorgebj > Para: firebird-support@yahoogroups.com > Enviado: viernes, 5 de abril de 2013 19:17 > Asunto: [firebird-support] Restart and stop Firebird 2.5.2 on Linux > > > > > Hello everyone: > > How to restart and stop Firebird 2.5.2 on Linux? > No rebooting the server. > > In version 2.1 of FireBird the command fbmgr was used to stop and restart > Firebird. > > In Firebird 2.5.2 command no longer exists fbmgr.bin > > Thanks for your help > --- > Hi Jorge, > > I suppose It depend on which distro you are. > > On Ubuntu I do: > sudo service firebird2.5-super restart > > Or > > sudo service firebird2.5-super stop > sudo service firebird2.5-super start > > > Regards >
[firebird-support] Re: Restart and stop Firebird 2.5.2 on Linux
Hello Konstantin: Yes, I saw your post earlier but I was unable to find those files scripts. I am new in Linux and the Linux installation on the server was made by a supplier. I think the installation was not normal because there are some files and folders that are not in the normal installation routes, eg FireBird manual indicates that the installation path is /opt/firebird, on my server there is no such path. But keep looking for those files scripts :) I appreciate very much your help. Regards Jorge Botello --- In firebird-support@yahoogroups.com, Konstantin Khomoutov wrote: > > On Fri, 05 Apr 2013 22:17:09 - > "jorgebj" wrote: > > > How to restart and stop Firebird 2.5.2 on Linux? > > No rebooting the server. > > > > In version 2.1 of FireBird the command fbmgr was used to stop and > > restart Firebird. > > > > In Firebird 2.5.2 command no longer exists fbmgr.bin > > Did you see this [1] my response to your first post on this topic? > > 1. http://tech.groups.yahoo.com/group/firebird-support/message/121289 >
[firebird-support] Re: Firebird server maximum number of simultaneous connections
--- In firebird-support@yahoogroups.com, "frodrigues_fcprd" wrote: > > Hi, > > We are using a set of 20 databases that are accessed simultaneously by 20 (or > more) applications (each one with multiple threads). These applications > (written in c# and using the FirebirdSql.Data.FirebirdClient.dll) basically > retrieve records from the database, perform a special processing (IO bound > not CPU bound) and update the database with the results. > > Originally we had a single database but decided to split it in order to > separate the processing across multiple servers if necessary. > > We are not concerned with the response time of the database but we would like > to known if there is a limit for the number of connections that the firebird > server can support. We would like to run as much applications and threads as > possible in order to speed up the processing of the database records but we > do not known how many connections the firebird server can support. The > applications and the firebird server will be executed in the same computer. It is limited by the resources that you have Memory and CPU (the more the better) Firebird can be capable to sustain more than 2500 connections with proper big iron servers http://www.firebirdnews.org/?p=6797