Re: dbimport error
This is a discussion on Re: dbimport error within the Informix forums, part of the Database Server Software category; --> HI, Finally, the problem was resolved. We need add more directories(>=2) to PSORT_DBTEMP if if we have PSORT_NPROCS >=2. ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 01:08 PM
| ||||
| ||||
 Re: dbimport error HI, Finally, the problem was resolved. We need add more directories(>=2) to PSORT_DBTEMP if if we have PSORT_NPROCS >=2. Interesting! Any comments? Thanks, Quman On 9/25/06, Quman <yquman@gmail.com> wrote: > I am doing dbimport and bumped with the error, > > > create unique index "informix".user_email_idx on "informix".user_email > (user_id,email_id) using btree in dbdata00 ; > *** execute sqlobj > 212 - Cannot add index. > > 2 - No such file or directory > > > The confuse thing is that the above statement can be run in DBACCESS > successfully(after importing was stopped) > > I did not see any OS error. > > Any tips are appreciated. > > Quman > > > informix@erika $ finderr 2 > -2 No such file or directory. > > An operating-system error code with the meaning shown was unexpectedly > returned to the database server. Look for other operating-system error > messages that might give more information. > > > informix@erika $ onstat -version > Program Name: onstat > Build Version: 10.00.UC4 > Build Number: N204 > Build Host: ibm6c1b > Build OS: AIX 5.2 > Build Date: Fri Nov 18 23:37:26 CST 2005 > GLS Version: glslib-4.00.UC7 >      |
Linear Mode
