[firebird-support] Re: think there is a bug in gpre cobol for 2.5.x

2017-07-02 Thread thirdshiftco...@yahoo.com [firebird-support]
Hi- the gods are with me I found older versions at sourceforge.net. well... got to get some sleep. much work tomorrow of a stressful nature. have a cool monday. thx. - jim

[firebird-support] think there is a bug in gpre cobol for 2.5.x

2017-07-02 Thread thirdshiftco...@yahoo.com [firebird-support]
Hi- I gave this a really good look. It seems no matter what i do I get an error in gpre with cobol. here is my cobol code: IDENTIFICATION DIVISION. PROGRAM-ID. Moon. ENVIRONMENT DIVISION. Configuration Section. Special-Names. DATA

[firebird-support] Re: startup and shutdown firebird

2017-07-02 Thread thirdshiftco...@yahoo.com [firebird-support]
hi - I noticed that I am running the firebird server process under a different account than root which is good from what I have read now that I have a firebird:firebird user and group. I run the script in /etc/init.d/firebird start. thanks - jim

[firebird-support] Re: startup and shutdown firebird

2017-07-02 Thread thirdshiftco...@yahoo.com [firebird-support]
Hi- I don't know why installer didn't add one. I just added a group firebird. thx. - jim

[firebird-support] startup and shutdown firebird

2017-07-02 Thread thirdshiftco...@yahoo.com [firebird-support]
hi- I am using fedora 25 Linux. I can't use systemctl because I did a source install. I can use fbguard. I tried gfix, and that won't work it seems. Then I decided per advice from a website to use the script in init.d. That gave me the following msg. init.d # ./firebird stop chown

Re: [firebird-support] Always use BIGINT?

2017-07-02 Thread Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
Hi, I test general impact of compression and I found that for FB 2.5 and FB3 is critical to take another DB page from cache. Also any cache miss significantly reduce performance. With current compression and if we have a number lest say 0x3337 stored in three columns. BIGINT it will be

Re: [firebird-support] Always use BIGINT?

2017-07-02 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, Jul 1, 2017 at 6:23 AM, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > > > what do you mean with alignment? > It varies from machine to machine, but generally in order to add or compare two integers they must be aligned on a