Re: [firebird-support] gbak error

['Woody' woody-...@gt.rr.com [firebird-support]]

Not sure it helps, but I once had my FB backup schedule service stop working 
after a server software update. It was a Windows server, though, so not sure it 
applies here. Just something else to think about.

Woody (TMW)


From: mailto:firebird-support@yahoogroups.com 
Sent: Tuesday, August 30, 2016 3:36 PM
To: firebird support 
Subject: Re: [firebird-support] gbak error




no, not a file name collision and plenty of disk space

this just started happening, no change to installed s/w 

Nick Upson,
Principal Operations Engineer, Telensa Ltd.
Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200


On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au 
[firebird-support]  wrote:


  Hello Nick,

  > I'm running fb2.1 on centos5, recently a system has started
  > throwing this error when asked to do a backup, the gbak parameters
  > are unchanged, permissions all seem ok, any suggestions what I might check

  > gbak: ERROR:Unexpected I/O error while writing to backup file
  > gbak:Exiting before completion due to errors

  "gbak parameters are unchanged." Could be you already have a file in
  that location with the same name.

  HB

Re: [firebird-support] Users for application

['Woody' woody-...@gt.rr.com [firebird-support]]

One of the main reasons I have for using individual user names is to be able to 
see who created/modified records. In an industrial system such as the one I 
built and support, knowing who does what is very important, especially if 
something gets entered wrong or changed inadvertently. Management likes to know 
who is doing their job efficiently and who isn’t. 

Woody (TMW)


From: mailto:firebird-support@yahoogroups.com 
Sent: Thursday, June 23, 2016 6:46 AM
To: firebird-support@yahoogroups.com 
Subject: Re: [firebird-support] Users for application




You can still see which process is doing what using a single user, though, 
since the system tables provide you with process name (foo.exe) and ip address 
for each transaction. 

I have the feeling that users are only worth the management cost if you're in a 
big corporation with a bunch of developers and lots of users connecting to the 
database. Then you would use roles and privileges appropriately (with a DBA 
taking care of this, not the developers). But that's just a feeling really, 
since I've never been in such a scenario.

Em qui, 23 de jun de 2016 às 05:30, Tim Ward t...@telensa.com 
[firebird-support]  escreveu:


  On 23/06/2016 03:17, 'Daniel Miller' dmil...@amfes.com [firebird-support] 
wrote:

  
Separate from security theories and considerations of "good practice", 
what, if any, benefits accrue from using multiple users when accessing a 
Firebird database?

  We have different processes using different users. This means that poking 
around in the database to see what's going on (performance, long-lived 
transactions, etc) is a bit easier - we can instantly see which process is 
doing what, as the users are named after the processes.


-- 
Tim Ward

Re: [firebird-support] How do find duplicates in a table?

['Woody' woody-...@gt.rr.com [firebird-support]]

Try this instead:

Select Soc_Sec_No, count(*) from Person
group by Soc_Sec_No
having count(*) > 1

This will list the social security numbers and the count if there are 
more than one without
all the additional selects.

HTH
Woody (TMW)

-Original Message- 
From: 'stwizard' stwiz...@att.net [firebird-support]
Sent: Thursday, February 04, 2016 1:37 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How do find duplicates in a table?

I had finally figured it out just before your reply

SELECT DISTINCT P.SOC_SEC_NO,
  (SELECT COUNT(*)
FROM PERSON P2
   WHERE P2.SOC_SEC_NO = P.SOC_SEC_NO) AS CNT
  FROM PERSON P
WHERE P.SOC_SEC_NO IS NOT NULL
GROUP BY 1
HAVING (SELECT COUNT(*)
  FROM PERSON P3
 WHERE P3.SOC_SEC_NO = P.SOC_SEC_NO) > 1

This appears to work.  See anything that I should change?

-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, February 04, 2016 1:25 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How do find duplicates in a table?

04.02.2016 20:09, 'stwizard' stwiz...@att.net [firebird-support] wrote:
> How do I form a SQL Select statement that will return which records in
> my PERSON table have duplicate SOC_SEC_NO.

   RTFM GROUP BY, HAVING, COUNT().

-- 
   WBR, SD.





Posted by: "stwizard" 


++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu 
there.

Also search the knowledgebases at 
http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links

Re: [firebird-support] Performance issues with ORDER BY

['Woody' woody-...@gt.rr.com [firebird-support]]

SELECT
Table1.ID, Table1.FKID, Table1.MD... some other fields
FROM Table1, Table2 , Table3

WHERE 1 IS NOT NULL
AND (Table2.ID = Table1.FKID)
AND (Table2.FKID = Table3.ID)
AND (Table3.ComputationID = 9)

ORDER BY Table1.ID ASC;


I'd welcome any insight as to what I might be doing wrong.


The first thing I would try would be to update your query format. Try:

Select Table1.ID, Table1.FKID, Table1.MD ... other fields
From Table1

Inner Join Table2 on (Table1.FKID = Table2.ID)
Inner Join Table3 on (Table2.FKID = Table3.ID) and (Table3.ComputationID = 
9)

Order by Table1.ID ASC/DESC;

HTH

Woody (TMW)