RE: dbschema failed in IDS7.31.UD7
--0__=88BBE507DFC1AC538f9e8a93df938690918c88BBE507DFC1AC53
Content-type: multipart/alternative;
Boundary="1__=88BBE507DFC1AC538f9e8a93df938690918c88BBE507DFC1AC53"
--1__=88BBE507DFC1AC538f9e8a93df938690918c88BBE507DFC1AC53
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Ok ..I am hoping u hv got a support contract with IBM ..:-)
Do the following:
export SQDEBUG=3D1
export SQEXPLAIN=3D1
Run your dbschema command again. This will create two files:
1) /tmp/dbschem.time
2) <currentdir>/sqexplain.out
U will be able to identify which command returned the ISAM Error -100 f=
rom
sqexplain.out and the last function called from /tmp/dbschem.time. If i=
ts
simple, you can probably fix it otherwise, pls send this info to the
support guy and he'll be able to fix it for you.
HTH
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
miyaki =
<lcib@yahoo.com> =
Sent by: =
To
owner-informix-li "Simmons, Keith" =
st@iiug.org <keith.simmons@office2office.biz=
>,
informix-list@iiug.org =
=
cc
01/25/2005 04:10 =
AM Subj=
ect
RE: dbschema failed in IDS7.31.U=
D7
=
=
=
=
=
=
Hi all,
I'm able to re-procude this problem in my test
environment. To eliminate all the unrelevant, I create
the test environment with only 1 table in the entire
database.
1) Install the 7.31.UD7
2) Initialize the database engine (oninit -iy)
3) Create the neccessary dbspaces as below
Informix Dynamic Server Version 7.31.UD7 --
On-Line -- Up 00:00:45 -- 381024 Kbytes
Dbspaces
address number flags fchunk nchunks flags
owner name
5e356150 1 1 1 1 N
informix rootdbs
5ee7afc0 2 1 2 2 N
informix testdb
2 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages
flags pathname
5e356210 1 1 0 50000 44901
PO- /dev/rdb16
5ee7b2e0 2 2 0 1000000 999947
PO- /dev/rdb5
5ee87180 3 2 0 1000000 999997
PO- /dev/rdb6
3 active, 2047 maximum
4) Run level 0 archive (ontape -s -L 0)
5) Create a database in testdb dbspace
create database utopia in testdb with buffered log;
6) Create a table in utopia database with primary key
constraint.
create table test_table1
(col1 char(10),
col2 int,
primary key (col1) constraint pk_col1)
7) Run dbschema command as below
dbschema -d utopia -t test_table1 -ss
DBSCHEMA Schema Utility INFORMIX-SQL Version
7.31.UD7
Copyright (C) Informix Software, Inc., 1984-1998
Software Serial Number AAC#J238387
100 - ISAM error: duplicate value for a record with
unique key
If you look at the above steps, you may noticed that I
did not insert any record into the test_table1. But,
I'm still getting the error. This make me even
confused.
Besides, I created another table without using the
primary key constraint, and the dbschema command is
working perfectly. Is it because of the primary key
constraint? Appreciate that someone could help to
explain this.
Thanks in advance.
Miyaki
--- "Simmons, Keith" <keith.simmons@office2office.biz>
wrote:
> Miyaki
>
> I've tried this on Aix 5 and 7.31 UD7 with no
> problems.
> What other tables/columns do you have in the
> database, any
> with the same names?
> Have you run any oncheck against the system tables?
> What was the dbschema syntax you used (I was
> successful with
> dbschema -d database -t table> and
> dbschema -ss -d database -t table>
> Keith
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
sending to informix-list
=
--1__=88BBE507DFC1AC538f9e8a93df938690918c88BBE507DFC1AC53
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Ok ..I am hoping u hv got a support contract with IBM ..:-)<br>
<br>
Do the following:<br>
<br>
export SQDEBUG=3D1<br>
export SQEXPLAIN=3D1<br>
<br>
Run your dbschema command again. This will create two files:<br>
1) /tmp/dbschem.time<br>
2) <currentdir>/sqexplain.out<br>
<br>
U will be able to identify which command returned the ISAM Error -100 f=
rom sqexplain.out and the last function called from /tmp/dbschem.time. =
If its simple, you can probably fix it otherwise, pls send this info to=
the support guy and he'll be able to fix it for you.<br>
<br>
HTH<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE507DFC1AC538f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for miyaki <lcib@yah=
oo.com>">miyaki <lcib@yahoo.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE50=
7DFC1AC538f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">miyaki <lcib@yahoo.com></font></b><font s=
ize=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">01/25/2005 04:10 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D@@