[firebird-support] Altering a domain

2015-06-16 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hi, I have defined the following domain : CREATE DOMAIN CURRENCY AS decimal(9,2) I would like to alter it as the following : ALTER DOMAIN CURRENCY AS decimal(18,2) I have many fields in tables that depend on this domain and they are filled with values. Will they be

Re: [firebird-support] Altering a domain

2015-06-16 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: I have defined the following domain : CREATE DOMAIN CURRENCY AS decimal(9,2) I would like to alter it as the following : ALTER DOMAIN CURRENCY AS

Re: [firebird-support] Altering a domain

2015-06-16 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Ann, thank you very much for your clear explanation. Aldo El 16/06/15 a las 12:44, Ann Harrison aharri...@ibphoenix.com [firebird-support] escibió: On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso aldo.car...@argencasas.com mailto:aldo.car...@argencasas.com [firebird-support]

Re: [firebird-support] Corrupted database

2015-06-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, It is a typical corruption usually caused by Firebird abnormal termination due to power outage. You can fix it with IBSurgeon FirstAID more details at www.ib-aid.com Regards, Alexey Kovyazin IBSurgeon 16 июня 2015 г. 6:50 пользователь Nagy Szilveszter nagy_szilvesz...@yahoo.com

[firebird-support] FB 2.1 CS High FBLockPrint Mutex wait figure

2015-06-16 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
I have an Ubuntu 10 Server LTS 64 bit box running Firebird Classic server v2.1.3. I am having an issue with it in that the Mutex wait % statistic from FB_Lock_Print is very high, currently around 42% which I know is way way too high. What I am struggling with is why this is the case. There

[firebird-support] What is recommended modeling tools for Firebird

2015-06-16 Thread Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
Hi All, we are looking for new modeling tool that will replace our unsupported CaseStudio2. I was made quick look at http://www.modelsphere.org/ and http://www.toad-data-modeler.com/enu/default.aspx but I not sure that is right choice. We needs: -model diagram with sub models -user scripting

[firebird-support] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

2015-06-16 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
16.06.2015 11:54, 'Neil Pickles' wrote: Does anyone have any ideas as to what might be causing the high mutex wait %? Outputs for gstat -h and fb_lock_print could be helpful. As well as what exactly custom firebird.conf contents you use (what parameters are set to non-default values).

Re: [firebird-support] What is recommended modeling tools for Firebird

2015-06-16 Thread Louis van Alphen lo...@nucleo.co.za [firebird-support]
We use enterprise architect from sparx systems. Uses UML. I do all my modelling in there. Db, classes, behaviour etc. the nice thing is that everything is then in one place. You also generate DDL scripts from there or reverse engineer. Also generate docs from the model as well as interactive

RE: [firebird-support] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

2015-06-16 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
Thanks Dmitry. This server was last restarted about 12 hours ago. Non standard firebird.conf entries are:- DefaultDbCachePages = 384 TempBlockSize = 2048576 TempCacheLimit = 77108864 LockMemSize = 26214400 LockHashSlots = 30011 Gstat -h output for database 1 Database