[Info-ingres] ingres 3.0.3 on hp


    Sponsored Links


  • 1. [Info-ingres] Error handling in DBPs
    Hi Roy, > > Being too lazy to read the code myself, does anyone know what (if any) > guiding principle decides when a directly executed DBP keeps control > after an error? The manual states the position very clearly - that's the guiding principal. So either the documentation isnt 100% or this is a bug. I'm running with bug. Marty PS. I'm holding your bottle of wine hostage. Random Duckman Quote #92: Cornfed: Insincere attempts to win the a child's affection can cause his self-esteem to plummet until he drops out of school, has his vocal cords loosed to effect a deeper voice then ends up being the only pig cage dancer at a waterfront leather bar...or so I'm told.
  • 2. Error handling in DBPs
    We all know what the manual says about errors in database procedures: "If the procedure was invoked by a rule, an error has the following effects: - The procedure is terminated. - Those statements in the procedure which have been executed are rolled back. - The statement that fired the rule is rolled back. "If the procedure was executed directly, an error has the following effects: - All statements in the procedure up to the point of the error are rolled back. - The procedure continues execution with the statement following the statement that caused the error." In reality it seems that *directly executed* procedures don't always work that way. Some errors (such as divide by zero) terminate the procedure and control returns immediately to the calling program. Others (such as selecting a null into a non-nullable variable) work as the manual describes. Being too lazy to read the code myself, does anyone know what (if any) guiding principle decides when a directly executed DBP keeps control after an error? Roy
  • 3. [Info-ingres] SPAM: PEACE TO YOU
    This is a multi-part message in MIME format Dear friend I am joel Titoh, working with Diplomatic securities and finance company in europe,i have a deal which i want to talk with you. Our company have assisted some of the african leaders and politicians to move some fund and valuableS through our special arrangments as a consignment.Some of these consignments where not claimed as a result of deaths and some government restriction, therefore sent to suspense whare house. Presently we have some unclaimed ones ready for suspense whare house,but i have perfected arrangment to claim one the the consigment containing a lot of funds if i have a reiable person to assist me. if you are interested in the matter, you let know through this email adress for more datails and how to proceed. Sincerely Joel Titoh
  • 4. Ingres tools
    With the release of Ingres R3, is there any more happening on the 3rd party tools front for Ingres ? Is there any demand for such tools ? Several years ago I wrote a pretty-printer/formatter for Ingres SQL, which incorporated basic support for reporting on code coverage on Ingres database procedures, at the level of statement, branch and loop coverage. As I've recently moved jobs, and have more free time, I've picked up the development of this utility again, and am moving it in the direction of Ingres R3. Is there any demand out there for such a tool/utility ? I'm interested in discussing this on a commercial basis or non-commercial basis with any individuals or organisations who think they may have a use for such a utility. I'm based in the UK, Regards, Mark.

[Info-ingres] ingres 3.0.3 on hp

Postby m-angel » Wed, 22 Mar 2006 23:29:34 GMT

hi , to install i type as user ingres

mkdir ../ingres and ../ingres/install

and on ingres dir


all ok , but ...

a have a message error :

can't access kernel address   23d9c0

run ok , i can createdb ,destroy ...-)

on the other hand can connet whith JDBC server no valid user/passwd

i defined passwd instalation and
with ingresNET i can connet ok

somebody can help ??
(its necesary install as root??)

<div>hi , to install i type as user ingres</div>
<div> </div>
<div>mkdir ../ingres and ../ingres/install</div>
<div> </div>
<div>and on ingres dir</div>
<div> </div>
<div> </div>
<div>all ok , but ...</div>
<div> </div>
<div>a have a message error :</div>
<div> </div>
<div>can't access kernel address   23d9c0</div>
<div> </div>
<div>run ok , i can createdb ,destroy ...-)</div>
<div> </div>
<div>on the other hand can connet whith JDBC server no valid user/passwd </div>
<div> </div>
<div>i defined passwd instalation and </div>
<div>with ingresNET i can connet ok</div>
<div> </div>
<div>somebody can help ??</div>
<div>(its necesary install as root??)</div>

Similar Threads:

1.[Info-Ingres] ckpdb failure for Ingres 2.6 on hp 11.11

2.[Info-ingres] ingres r3 error on hp-ux

hi , i tried install ingres r3 in a

uname -a

HP-UX itanium B.11.23 U ia64 ....

install ok but ....

ingres start with can't access kernel address   23d9c0

 syscheck -v

Checking host "itanium.unizar.es" for system resources required to run Ingres...

64-bit kernel running.

514 file descriptors per-process required.
4096 is the current system hard limit.
2048 is the current system soft limit.

can't access kernel address   23d9c0

the performance is very bad

can something help me


3.[Info-ingres] Ingres Replicator on HP-UX

On 12 Sep 2005 06:44:32 -0700,  XXXX@XXXXX.COM 
< XXXX@XXXXX.COM > wrote:
> Hi, all.

Hi James

> I'm about to start a project to evaluate Ingres Replicator for a
> customer who wishes to implement a contingency plan between databases
> at two different sites.  The idea is relatively simple: from each site,
> data will be replicated to an unprotected read-only target database at
> the other site.
> While I have had substantial experience with "older versions" of
> Replicator, it's been a few years since I have really worked with it.
> I believe that the last version that I really ever implemented was OI
> 2.0... which still was based on database rules instead of the newer
> change recorder / distribution threads architecture.
> I have a couple of questions for anyone with any experience with the
> latest versions, and would greatly appreciate any help I can get!
> 1) The customer's version of Ingres is Ingres II 2.0/0001 (hpb.us5/00).
>  They are scheduled to migrate to Ingres II 2.5 in November.  Are there
> any major differences (architectural changes or bug fixes) between
> these versions of Replicator? Can we expect any problems with migrating
> replicator, or would there be any good reasons to wait and implement
> replication only after 2.5 is installed?

The major differences between 2.0 and 2.5 will be that the change
recorder is now built into the DBMS and the replicator server is
generic - and therefore doesn't have to be built.

I confess I've never done a replicator migration.   You'd need to drop
all the rules and procedures that are the 2.0 change recorder so I
imagine the easiest way to migrate, especially if your replication
scheme is straightforward, would be to freeze any database changes,
dereplic them, upgrade Ingres and the database and re-configure

> 2) I know that in the older versions, each "replicator server" must be
> compiled and linked within the specific Ingres environment. I assume
> this is still true (according to the manual, it still is). My customer
> is hesitant to purchase HP-UX's software development kit for what is
> initially just an evaluation phase.  Does anyone know of another
> alternative for C language compilation on an HP-UX 11i box?

Are you sure you read the 2.5 manual? In any case 2.5 was when we
introduced the generic replication server so you won't need a C
compiler to build one.

See ftp://ftp.ca.com/CAproducts/ingres/docs/Ingres_25/rep.pdf

> 3) If anyone has any caveats or recommendations for this kind of
> environment, I will gladly receive suggestions!  I'm mostly afraid of
> possible locking / deadlock problems (which was what I suffered most
> with in past versions!).  Have there been any improvements in this
> area?

You can now specify the lockmodes for the replication threads dealing
with the distribution and input queues, as well as the shadow and
archive tables. See Chapter 8 of the Replicator manual.

The other thing I would say, is that at this time, I'd be thinking of
upgrading to 2.6 rather than 2.5, if not r3. More features, better
performance and a longer support life.


Paul Mason

4.[Info-ingres] HP-UX 11.11 performance with Ingres 2.6

At 9:37 AM -0500 4/1/05, Dennis Roesler wrote:
>Ingres II 2.6/0305 (hpb.us5/00)
>HP-UX B.11.11 rp3440 (8GB memory) and RAID 1 on the disks
>   - patch PHCO_30544 Pthread enhancement and fixes installed
>We're migrating some data to a new schema.  Not really having a 
>benchmark of how long it would take to process the data I started 
>doing some tests.
>One set of data was taking over 5 hours and a different set of data 
>was taking a little over 2 hours.  Not really having a benchmark to 
>go by I wasn't sure if this was unreasonable or not.
>For some reason I decided to test how long it would take to process 
>the data on linux.  The linux box is a Compaq P4 desktop (512MB 
>memory and a single 40G disk) with RH FC3 and r3/109 installed using 
>express_install, no other configuration changes.
>I copied the data and script to the linux box and when I ran the 
>same scripts on the same data sets the jobs took ~45min and ~15mins 
>respectively.  At first I thought the script bombed out in some 
>places, but looking at the script logs all the data was processed 
>I have a call in to tech support to try and resolve why there would 
>be such a discrepancy on the two systems.  I've tried various 
>suggestions from tech support, but there is no significant gains in 
>processing time.
>Any suggestions?  I can post any relevant config info, but at this 
>point I'm not sure what is relevant.


Our experience with Ingres and Linux on "somewhat equal" hardware is that
Linux beats the crap out of Solaris and HP-UX.

Dunno why.

Michael Leo               Java, J2EE, BEA WebLogic,
Caribou Lake LLC          Oracle, Open Source, Ingres,
 XXXX@XXXXX.COM       Real Enterprise Applications

Climate is what we expect. Weather is what we get.
    - Mark Twain

5.[Info-ingres] Ingres Replicator on HP-UX

On 27 Sep 2005 06:26:15 -0700,  XXXX@XXXXX.COM 
< XXXX@XXXXX.COM > wrote:
> >The major differences between 2.0 and 2.5 will be that the change
> >recorder is now built into the DBMS and the replicator server is
> >generic - and therefore doesn't have to be built.
> Thanks Paul!  That's exactly the information that I was looking for.
> Eric Mischke had already indicated to me that he thought it was no
> longer necessary to have a compiler; but it's great to substantiate it
> with a reason why!   Is there a  "new features" guide or whitepaper for
> Replicator 2.5 /2.6 anywhere out there, that specifically targets the
> changes from 2.0 to the latest version?


Sorry for the delay in replying.

I'm not aware of a new features guide for Replicator specifically. I
checked the general one on SupportConnect but it doesn't mention
Replicator and it's fairly brief in any case.

Sorry I can't be of more help.

Paul Mason

6. [Info-Ingres] ingres hp 11.11

7. [Info-ingres] [ingres] [Info-ingres] Dates users were created in Ingres

8. [Info-ingres] RES: [Info-ingres] RES: [Info-ingres] SQL Injection attacks

Return to DATABASE


Who is online

Users browsing this forum: No registered users and 75 guest