Ingres HVR 4.3.1 Now Available
Pamela Fowler
www.ingres.com (http://www.ingres.com/downloads/ingres-
other.php#inghvr) or at http://esd.ingres.com.
Ingres HVR version 4.3 contains many new features, such as;
• Support for Ingres VectorWise as replication target (not source).
• On-line refresh, so end-users can continue changing a database while
Ingres HVR refreshes it to another target
• Replication of Ingres sequence numbers
• Failover utility, for switching over end-users with a virtual IP
address to replicated standby
• XSLT transformation inside file replication
• Unicode support for XML file integrate
• An updated Ingres HVR User Manual (see hvr_home/www/docs/hvrum.pdf)
• Many GUI improvements
• Support for Oracle 11 and SQL Server 2008
• Limited Oracle RAC support (active/passive and unsynchronized active/
active)
Andy
It was suggested awhile ago that I upgrade some of my clients versions of Ingres to 9.2 (linux)...
That was awhile ago.
Should I still go to 9.2 or 10.? ?
Regards,
Andy.
Karl Schendel
10 isn't quite ready yet, but it's very close. At least internally; I'm not
qualified to comment on the external release schedule of the
fully tested Enterprise version.
I'm a wild-eyed optimist, so I'd say use 10. There's tons of great new stuff
in 10, along with significant internal improvements in a number of areas.
On the other hand, 9.2 with the latest service pack (whatever it might
be called) is in production use at many many sites, and may well
be the safe choice. Either choice has its advantages and dangers.
Karl
Paul Mason
10.0 is not GA yet so yes 9.2 is still the recommended version. Depending on how close the upgrade is you might want to start testing with the 10.0 beta.
HTH
Paul
From:
info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of Andy
Sent: 02 September 2010 00:36
To: info-...@kettleriverconsulting.com
Subject: [Info-Ingres] Which version
Hi All,
It was suggested awhile ago that I upgrade some of my clients versions of
Ingres to 9.2 (linux)...
That was awhile ago.
Should I still go to 9.2 or 10.? ?
Regards,
Andy.
Paul Andrews
The book of the day (in PDF/ebook format) is $9.99 . I think the offer
will be available all weekend.
Might interest someone here!
Paul
Ingres Forums
Hi
Where it is possible to download the HVR docs from?
Thank you
Charles
--
sop...@mrinformatica.es
------------------------------------------------------------------------
sop...@mrinformatica.es's Profile: http://community.ingres.com/forum/member.php?userid=1174
View this thread: http://community.ingres.com/forum/showthread.php?t=12491
Ingres Forums
The HVR documentation is only available as part of the actual download
of the product which is generally only available through a
Proof-of-Concept. There is an available whitepaper that talks further
about the software at;
'HVR Software - Documentation'
(http://hvr-software.com/resources/hvr_literature/)
I am checking if there is any other means of accessing the full
documentation set.
Sincerely,
Pamela Fowler
VP of WW Support
Ingres Corporation
--
fowpa01
------------------------------------------------------------------------
fowpa01's Profile: http://community.ingres.com/forum/member.php?userid=1145
Ingres Forums
I talked with HVR and they don't generally post their documentation, nor
does any competitive products, as each tends to use one against the
other.
If you send me your email address I can send you, personally, the
latest documentation for review.
Email me at; pamela...@Ingres.com
Sincerely,
Pamela Fowler
VP of WW Support
Andy
So, now I have installed Ingres 9.2.1(32bit) + p13876 on SuSE linux 11
Everything looks ok, OpenRoad 4.1 connects ok, runs the menus, a lot of screens work fine, but...
When I try to run a program (to create a report) that does a bit of work - some select loops, array processing, queries joining up to 6 tables - nothing over the top, but it runs ok for about 30 seconds and then grinds to almost a halt...
Looking in IPM, Lock List Display, showed nice progress for a little while and then, for my single user, the Count dropped and the Status showed SHARED. I have tried setting "set lockmode session where readlock = nolock" in the ING_SET variable, tried an optimizedb, and sysmod.
I have not traced it down yet but I was wondering if there were any out-of-the-box changes that other people do on 9.2.1?
Or should I have tried Ingres 9.2.0?
Regards,
Andy.
_______________________________________________ Info-Ingres mailing list Info-...@kettleriverconsulting.com http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres
Michael Dyer
Assuming that you have a support contract (using II 9.2.1 with patch 13876 implies that you have), raise an issue with support.
Be ready to let them have output from running the inglogs script a couple of time while the system is in the state where it has ‘ground to a halt’.
Inglogs can hang, as it uses iimonitor, which may hang if Ingres is locked up.
If it does, then just abort it and provide the data that has been produced. (A couple of times)
I routinely run both 32bit and 64bit II 9.2.1, as well as many other versions, in SuSE 11.2.
It runs sweet and as fast as my hardware can be expected.
Michael
Andy
I'm on a very restricted time frame and opted for 9.2.0 and was able to tweak it to the performance required.
Now I have another question.
I used to use the following to determine who is logged in but it no longer works - I only get some of the records - any ideas???
#!/bin/sh
sql -s imadb <<EOF
select client_info, db_name
from ima_server_sessions
where client_info != ''
and db_name != 'imadb'
order by 1, 2
; \g
EOF
Regards,
Andy.
Paul Mason
Hi Andy,
That SQL will work but will only return sessions in the DBMS you’re connected to. If you have more than 1 DBMS then you need to add
Execute procedure ima_set_vnode_domain;
Before the select. This will expand the “horizon” of what you can “see” to all servers in the current instance of Ingres.
Regards
Andy
One more tick on the To-Do/To-Fix List.
Regards,
Andy
_______________________________________________ Info-Ingres mailing list Info-...@kettleriverconsulting.com http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres