Login Register Actian.com  

Actian Community Blogs



Posted 2016-10-20 at 12:47 PM by Rimoun

Ingres Community
Posted in Uncategorized
Views 431 Comments 0 Rimoun is offline Edit Tags

Ingres 11 technical preview

Posted 2016-06-23 at 06:38 AM by geraintjones
Updated 2016-06-23 at 07:00 AM by geraintjones

Actian recently published a technical preview of Ingres 11 on their Electronic Software Delivery site, for users to give the tyres a good kick, try out new features and provide feedback. I don't remember previous pre-releases being made so publicly available, it's a move I appreciate and am sure other users will too.

Just a week after the preview was made available there’s already an excellent review of many of the new features by Nikos Vaggalis here, and linked to from his post...
Ingres Community
Posted in Ingres
Views 1322 Comments 2 geraintjones is offline Edit Tags

Checking the Existence of Database Assets

Posted 2015-11-19 at 09:04 AM by rhann
Updated 2015-11-19 at 11:59 AM by rhann (Forgot to show the \macro command)

The Ingres tm terminal monitor—better known as sql—has a macro facility that provides, among other things, conditional execution.

The following example checks to see if the myproc procedure exists and if it does (tuplecount—that is, row count—is greater than 0), it skips everything between the \branch and the next-step label (\mark):
SELECT distinct procedure_name
FROM iiprocedures
WHERE procedure_name = 'myproc'
AND procedure_owner = dbmsinfo('username');
rhann's Avatar
Ingres Community
Posted in Ingres, Vectorwise
Views 1764 Comments 0 rhann is offline Edit Tags

Ingres lock wait durations

Posted 2015-11-16 at 07:11 AM by geraintjones

A useful new feature appearing in the latest (mid November 2015) patches for Ingres 10.2 is a dbmsinfo() call which returns the cumulative lock wait duration for the current session.

> sql -d -s iidbdb
INGRES TERMINAL MONITOR Copyright 2014 Actian Corporation
select dbmsinfo('lock_wait');\g

Ingres Community
Posted in Ingres
Views 1436 Comments 1 geraintjones is offline Edit Tags

OpenROAD 6.2 Webinars

Posted 2015-05-21 at 01:05 PM by clach04
Updated 2015-05-26 at 05:13 PM by clach04 (Updated with additional link to Upcoming Actian Webinars)

We're going to do some presentations on OpenROAD 6.2, these will be recorded so if you miss the live event you will be able to watch it at a later date, or rewatch it :-)

We have three scheduled:
  1. OpenROAD 6.2- Overview. This is for anyone using Ingres and OpenROAD
  2. OpenROAD 6.2 - Loadnrun - this is aimed at both developers and engineers who deploy applications. You can still deploy using your existing techniques but Loadnrun makes it much easier as well as having some additional
Ingres Community
Posted in Ingres, OpenROAD
Views 2252 Comments 4 clach04 is offline Edit Tags
© 2011 Actian Corporation. All Rights Reserved