Database Forum - Ingres Topics

Thread preview

Thread	Last Post	Replies

Group for user ingres for LINUX and INGRES2006	29 Jun 2006 07:29 GMT	1
Must the user ingres belongs to root's group for a correct use of INGRES2006 for LINUX? Regards Ber
Check if Proc exists	26 Jun 2006 14:41 GMT	2
I am back working with Ingres after a 10 year gap so I have newbie questions which I have not been able to easily identify on a FAQ. 1. How do I test for the existence of a Procedure? I want to create script for my Procedures. In MS SQL I use something like:-
RE: [Info-ingres] Is it possible to use the CASE statement in an update?	26 Jun 2006 13:29 GMT	2
Hi Manny Try: update Table_A set code_fix = right(code_fix,5)
ingres R3	25 Jun 2006 19:08 GMT	1
I seek Ingres R3 for IBM AIX, where can I find it, I find only ingres 2006 available for download thank you
How do I create an Ingres 2 log file?	23 Jun 2006 09:53 GMT	2
I need to create a log file for an Ingres 2 installation (as a regular filesystem file) ASAP. I don't have any manuals. Can anybody tell me the command/paramters to use for this? Many Thanks,
[Info-ingres] How does Ingres manage partitons at the physical level?	22 Jun 2006 19:08 GMT	1
Hi Gang, I've been trying to figure out how Ingres stores and manages partitions at the physical level. Regular tables have one o/s file for each 'stripe' that can be seen by querying the ifile_info system catalog. I originally thought that Ingres might have one o/s file per ...
RE: [Info-ingres] Invalid TID	21 Jun 2006 15:12 GMT	2
> -----Original Message----- > From: BODH RAJ [mailto:bodh_raj@yahoo.com] > Sent: Wednesday, June 21, 2006 11:54 AM > To: martin.bowes@ctsu.ox.ac.uk
[Info-ingres] OPF_memory logging.	16 Jun 2006 13:00 GMT	3
I have an II 2.6/0305 (int.lnx/00) patch9892 installation which is occassionaly producing errors regarding opf_memory but only at the user end and these are not being printed in the Ingres Errlog. I would have thought they should be. Any commments.
lock question	15 Jun 2006 15:40 GMT	1
>From JDBC we are trying to establish row level locking. When we run the query I'm seeing this in IPM. Why do I see page locks ? IPM -- Locking System Monitor +Lock List
RE: [Info-ingres] Transaction log size (was Huge copy out/in)	15 Jun 2006 14:49 GMT	5
Hi Karl, I'd like to increase the transaction log to approx 40-50 GB. My current log is 1.8GB with 16K block size and 80 log buffers. What's considered a larger block size ? 32K or 64K ?
[Info-ingres] iietab table at MAX page size	14 Jun 2006 20:54 GMT	9
I have a small problem this morning, we have a BLOB table who's iietab table reached ingres' max page size (8385203). Assuming I can scrounge up enough workspace, can I modify a iietab table directly ? Or should I copy it out/in ?
ABF - temp tables and exec sql connect questions...	14 Jun 2006 11:59 GMT	1
I have created a frame in which I am using db1 and have declared a temporary table SESSION.accounts. I then connect to another another db (db2) using 'exec sql connect' in order to retreive some data. I select the data successfully and then
[Info-ingres] install ingres on Debian	14 Jun 2006 11:20 GMT	2
hi , i'll like install ingres on debian , with dpkg extract the binaries files but the config files are missing , can somebody help me?
SQL Injection, a summary	13 Jun 2006 19:55 GMT	4
The original thread managed to stay more or less on-topic for once, but split into three, so I'm starting a new thread for the summary so far. I used some of the comments and some of the links to draw some conclusionsthat nobody actually stated, so please feel free to correct me ...
[Info-ingres] Auditors	13 Jun 2006 18:20 GMT	7
I have the Sarbaines/Oxley auditors in, so this is going to sound like a stupid question. I know I can audit ( and recover ) modifications to data in databases. The auditors want to know if I also track schema changes.