BTW.

I managed to work around by playing its evil little game....

I unextended the database from the work location it wasn't using anyway.No errors.
Then did the extenddb without error.

Perhaps in the future I invent a time machine with the sole purpose of coming back in time to screw with my mind sufficiently that I can invent a timemachine.

Marty

From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 23 September 2010 10:51
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Errors when extending to a new auxilliary work location

Hi All,

On II 9.2.0 (a64.lnx/143)NPTL + 13695.

I have just created a brand new work location called ii_work_6.

When I extend my test database to use it as an auxilliary work location all is well....
createdb -uace bowtest
extenddb -uace bowtest -Uawork -lii_work_6

Its pretty clear from sessions running with set work location use (ii_work_6) and trace point dm1440 that all is working as expected.

So why the F does it collapse in a screaming heap when I attempt to extend my live database to it.?
extenddb -uace ace_pack_live -Uawork -lii_work_6
INGRES EXTENDDB Copyright 2008 Ingres Corporation
E_US008C The location cannot be specified for both work and auxiliary work.
E_IC0046 Error(s) occurred extending database 'ace_pack_live' to location 'ii_work_6'.

Note that this is a brand new location and the only work area that ace_pack_live uses is II_WORK. I have confirmed that with an infodb.

Martin Bowes