dbexport problem on NT4 server

dbexport problem on NT4 server

Post by kenke » Fri, 09 Mar 2001 15:14:45



Dear Sir/Madam

I have just install IDS 2000 9.20.TC1 and I-Reach 2.02 on NT 4 Server, I
tried to dbexport I-Reach 2.02 by typing following command but not working,

dbexport dbname
and
dbexport dbname -ss

both of commands are  hang on the half way of process, last part of massage
is showing like following:

{ unload file name = webcm00134.unl number of rows = 16 }

create table "informix".webcmpages
    (
        id varchar(40) not null ,
        description varchar(40) not null ,
        real_level integer,
        object "informix".html,
        time_stamp datetime year to second not null ,
        primary key (id) constraint "informix".pk_webcmpages
    );
revoke all on "informix".webcmpages from "public";

Thanks For Help

Alister Chen

 
 
 

dbexport problem on NT4 server

Post by Murray Woo » Sat, 10 Mar 2001 07:22:27


Any messages in the Informix messages log?
Is this the full schema for this table?
Can you run a schema of the NEXT table (by tabid) in the database?

MW

-----Original Message-----


Sent: Thursday, March 08, 2001 7:15 PM

Subject: dbexport problem on NT4 server

Dear Sir/Madam

I have just install IDS 2000 9.20.TC1 and I-Reach 2.02 on NT 4 Server, I
tried to dbexport I-Reach 2.02 by typing following command but not working,

dbexport dbname
and
dbexport dbname -ss

both of commands are  hang on the half way of process, last part of massage
is showing like following:

{ unload file name = webcm00134.unl number of rows = 16 }

create table "informix".webcmpages
    (
        id varchar(40) not null ,
        description varchar(40) not null ,
        real_level integer,
        object "informix".html,
        time_stamp datetime year to second not null ,
        primary key (id) constraint "informix".pk_webcmpages
    );
revoke all on "informix".webcmpages from "public";

Thanks For Help

Alister Chen


 
 
 

1. Q: dbexport/dbimport under NT4.0

Hi,

i have export our database from Unix Machine with dbexport <dbname> -c
-t <tapedevice> -b 20 -s 60000 (Informix Online 5.0)
And then I will import to Informix Dynamicserver 7.2 under NT4.0 :
dbimport <dbname> -c -t \\.\TAPE0 -b 20 - s 60000
but it comes errormessage : device don't support the block size . ???
The Tape is ok and goes well under NT. It is SCSI Tape Wangtek 5525.
Could someone help me ? The Tape size is 60 MB. Should I take 61440
(60x1024) for the Tapesize ?

Thank you,

Suriawan

PS : sorry for my english :)

--

 ---------------------------------------

           Suriawan Limantara            


 ---------------------------------------

2. ADO and SYBASE

3. Converting NT4.0 Workstation to NT4.0 Server

4. Transaction Handling for Non-Transactional Database

5. STATUS 95 ERROR NT4 W/STATION TO NT4 SERVER

6. Double-Click UDL to edit fails saying "Unexpected Error. Please investigate."

7. dbexport problem, has anybody has this problem

8. Can you rank or do you shoot blanks?

9. dbexport universal server to dynamic server

10. Problems with Active/Active cluster on SQL Server 7/NT4 Enterprise

11. NT4, SQL Server 6.5 and IIS4 problems

12. Problem Installing SQL Server 6.5 on NT4.0

13. NT4,SQL Server 6.5, IIS4 Problems