Possible Bug?
Posted in 2008
I hate that title - but thought it might get attention. Also in case anyone
missed it mikeb@fourthgeneration.com IS on vacation...
IDS 10.00.UC8
Solaris 2.8
I was having issues removing a device from the onpload database. Using the
onpladm delete device <DEV_NAME> syntax I was received a -284 error. I looked
at the entries in the onpload:device table and discovered there were duplicate
rows associated with the device I was trying to delete. The device table has
no unique index or primary key column defined - only an index on the "name"
column.
dbschema -d onpload -t device -ss
{ TABLE "informix".device row size = 714 number of columns = 9 index size =
133 }
create table "informix".device
(
name char(128),
seq integer,
type char(5),
file char(384),
blocksize integer,
devicesize integer,
pipecommand char(128),
lockflag char(1),
header text
) extent size 16 next size 16 lock mode page;
revoke all on "informix".device from "public" as "informix";
create index "informix".ix100_1 on "informix".device (name) using
btree in table ;
According to the doc there is supposed to be a primary key constraint on the
name column and it's only supposed to be a char(18)...
name CHAR(18) Name of the device array described in this row (primary key)
From:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.hpl.doc/hplms
t02.htm#ToC_435
I'm tellin...
Thanks -
Mike