by Zunino, Ka » Fri, 01 Aug 2003 00:10:48
Unfortunately, I've found that on some versions of IDS, the last entry in the dbimport.out is not necessarily the last step it was working on that bombed. (I assume that you really are looking in the dbimport.out and not the dbexport.out ;) The process seems to dump the log into dbimport.out using a buffer of some sort, such that what is in dbimport.out may not be the actual step that was working at the time of the failure. (I've had this experience several times with dbimport on an older version of IDS 7.) Make sure that whether this table was actually created and the privileges revoked. Then check the steps which should have been done immediately after that to see if any were performed but not logged in the dbimport.out .
I assume that the "nect size" is a cut/paste error, since the dbexport would not have created that typo. Did you edit the file between the dbexport and dbimport?
-----Original Message-----
From: Darren Robertson [mailto: XXXX@XXXXX.COM ]
Sent: Wednesday, July 30, 2003 2:50 AM
To: XXXX@XXXXX.COM
Subject: Re: dbexport did not create indexes
First of all thanks for the feedback I have received for this already.
Further.
I've been able to get the dbexport.out file and it doesn't complete.
Hence why no indexes are created. Looking at this made me think as if
the problem lies with the size/number of extents. However searching
through this NG has shown that the "error" is quite generic and will
show up in a number of different situations.
create table "user".protocol
(
dbprotocol integer not null
) extent size 16 nect size 16 lock mode page;
revoke all on "user".protocol from "public";
This is the last entry of the dbexport. Any further feedback would be
greatly appreciated.
Thanks.
D.
**********************************************************************
Privileged/Confidential information may be contained in this message.
If you are not an addressee indicated in this message (or responsible
for delivery of the message to such person[s]), you may not copy or
deliver this message to anyone. If you have received this message in
error, you should destroy and delete it from your computer and notify
the sender by reply email. Opinions, conclusions and other information
in this message that do not relate to the official business of
Diversified Collection Services shall be understood as neither given
nor endorsed by the company. Accordingly, Diversified Collection
Services disclaims all responsibility and accepts no responsibility for
the consequences of any person(s) acting, or refraining from acting,
on such information prior to the receipt by that person(s) of
subsequent written confirmation.
**********************************************************************
sending to informix-list