100 - ISAM error: duplicate value for a record wit

IDS - 9.21.UC2 OSLEVEL - AIX 4.3.3.0 I'm receiving an isam error 100 on a dbschema. What is happening and how to correct the problem? dbschema -d db_nros -ss > dbschema_db_nros.out fragment by expression (div_no <= '008' ) in nroxtdh_01 , (div_no = '009' ) in nroxtdh_02 , ((div_no >= '010' ) AND (div_no <= '023' ) ) in nroxtdh_03 , ((div_no >= '024' ) AND (div_no <= '041' ) ) in nroxtdh_04 , ((div_no >= '042' ) AND (div_no <= '049' ) ) in nroxtdh_05 , ((div_no >= '050' ) AND (div_no <= '071' ) ) in nroxtdh_06 , ((div_no >= '072' ) AND (div_no <= '082' ) ) in nroxtdh_07 , (div_no >= '083' ) in nroxtdh_08 extent size 32 next size 32 lock mode row; revoke all on "dbarnr1".nr0xtdh from "public"; 100 - ISAM error: duplicate value for a record with unique key. $finderr 100 -100 ISAM error: duplicate value for a record with unique key. A row that was to be inserted or updated has a key value that already exists in its index. For C-ISAM programs, a duplicate value was presented in the last call to iswrite, isrewrite, isrewcurr, or isaddindex. Review the program logic and the input data. For SQL products, a duplicate key value was used in the last INSERT or UPDATE. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU *******************************************************************

Would I have to repair the sysmaster database in order to resolve this 100 isam error? Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox, Ernest Sent: Saturday, August 14, 2010 5:44 PM To: ids@iiug.org Subject: 100 - ISAM error: duplicate value for a record.... [20923] IDS - 9.21.UC2 OSLEVEL - AIX 4.3.3.0 I'm receiving an isam error 100 on a dbschema. What is happening and how to correct the problem? dbschema -d db_nros -ss > dbschema_db_nros.out fragment by expression (div_no <= '008' ) in nroxtdh_01 , (div_no = '009' ) in nroxtdh_02 , ((div_no >= '010' ) AND (div_no <= '023' ) ) in nroxtdh_03 , ((div_no >= '024' ) AND (div_no <= '041' ) ) in nroxtdh_04 , ((div_no >= '042' ) AND (div_no <= '049' ) ) in nroxtdh_05 , ((div_no >= '050' ) AND (div_no <= '071' ) ) in nroxtdh_06 , ((div_no >= '072' ) AND (div_no <= '082' ) ) in nroxtdh_07 , (div_no >= '083' ) in nroxtdh_08 extent size 32 next size 32 lock mode row; revoke all on "dbarnr1".nr0xtdh from "public"; 100 - ISAM error: duplicate value for a record with unique key. $finderr 100 -100 ISAM error: duplicate value for a record with unique key. A row that was to be inserted or updated has a key value that already exists in its index. For C-ISAM programs, a duplicate value was presented in the last call to iswrite, isrewrite, isrewcurr, or isaddindex. Review the program logic and the input data. For SQL products, a duplicate key value was used in the last INSERT or UPDATE. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

No, dbschema doesn't look at sysmaster, only the database's catalog tables. This sounds like a bug in dbschema, creating the same temp object more than once, or some similar problem. Did you try myschema and see if it has the same problem? Open a support case. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Aug 16, 2010 at 4:37 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Would I have to repair the sysmaster database in order to resolve this > 100 isam error? > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Knox, Ernest > Sent: Saturday, August 14, 2010 5:44 PM > To: ids@iiug.org > Subject: 100 - ISAM error: duplicate value for a record.... [20923] > > IDS - 9.21.UC2 OSLEVEL - AIX 4.3.3.0 > > I'm receiving an isam error 100 on a dbschema. What is happening and > how to correct the problem? > > dbschema -d db_nros -ss > dbschema_db_nros.out> > fragment by expression > > (div_no <= '008' ) in nroxtdh_01 , > > (div_no = '009' ) in nroxtdh_02 , > > ((div_no >= '010' ) AND (div_no <= '023' ) ) in nroxtdh_03 > > , > > ((div_no >= '024' ) AND (div_no <= '041' ) ) in nroxtdh_04 > > , > > ((div_no >= '042' ) AND (div_no <= '049' ) ) in nroxtdh_05 > > , > > ((div_no >= '050' ) AND (div_no <= '071' ) ) in nroxtdh_06 > > , > > ((div_no >= '072' ) AND (div_no <= '082' ) ) in nroxtdh_07 > > , > > (div_no >= '083' ) in nroxtdh_08 > > extent size 32 next size 32 lock mode row; > > revoke all on "dbarnr1".nr0xtdh from "public";> > 100 - ISAM error: duplicate value for a record with unique key. > > $finderr 100 > > -100 ISAM error: duplicate value for a record with unique key. > > A row that was to be inserted or updated has a key value that already > > exists in its index. For C-ISAM programs, a duplicate value was > > presented in the last call to iswrite, isrewrite, isrewcurr, or > > isaddindex. Review the program logic and the input data. For SQL > > products, a duplicate key value was used in the last INSERT or UPDATE. > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > ************************************************************************ > ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636d3430f358c2a048e043a81