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