Hi, Thanks for your response. you are right, because of log files the process is hanging after loading certain amount of records from source file. using following commands I turned logging off and I was able to load all the records(>100000) from the source file. dbmcli -d <db> -u <dbmuser,dbmpass> > db_admin > util_connect > util_execute SET LOG WRITER OFF > util_release > exit After executing above commands to turn logging off, i am having problem to access my database with resource type user id. some times even its not letting me to log in as DBA( -u dba,dba = wrong userid and password message), any ideas. if i login as db_admin then does process force DB kernel to disable other users like dba and other resource users? Once again thanks for your help. regards, VCB
"Brunzema, Martin" <[EMAIL PROTECTED]> wrote: > -----Urspr�ngliche Nachricht----- > Von: Bhanu Vasireddy [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 10. Juni 2004 23:09 > An: [EMAIL PROTECTED] > Betreff: Data load problem with "dataload " command > > > HI > > I am having problem to load massive data into table . i have > around 750000 rows in the > source file in following format > > "asdf","1","this is my data" > "asdg","2","This is my data2" > > and here are my table definition and load command > > create table TERM_DETAILS( > term varchar(20) primary key, > ID integer not null, > details varchar(3000) default 'none') > > dataload table TERM_DETAILS IGNORE DUPLICATES infile 'terms.txt' > > > after executing above commands process is loading around > 400000 rows in 10 to 15 minutes and simply hanging. is anyone > successfully loaded millions of rows in MaxDB > table. > Hi, have a look into the file knldiag. Maybe you'll find there an error-message. regards, Martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
