From: Bhanu Vasireddy (sepra1972yahoo.com)
Date: Fri Jun 11 2004 - 18:41:03 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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" <martin.brunzemasap.com> wrote:

> -----Ursprüngliche Nachricht-----
> Von: Bhanu Vasireddy [mailto:sepra1972yahoo.com]
> Gesendet: Donnerstag, 10. Juni 2004 23:09
> An: maxdblists.mysql.com
> 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/maxdb?unsub=matt.woodsadsdish.com

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]