Hi Max, Toni Epple [mailto:[EMAIL PROTECTED] wrote: > > I have a reproduceable problem loading long values on 7.4.3.27 (build > 027-121-048-452) with LOGWRITER OFF on Linux SUSE 8.0 (2.4.19-ac4). > The data was extracted from a database running under 7.4.3.25 via a > tableextract command like this: > [snipped DATAEXTRACT command] > > The table has 2 columns (col1 CHAR(16), col2 LONG BYTE ) and about > 30.000 rows. > my_datafile.dat is about 800 k > my_longfile.long is about 280mb > > when I'm starting the upload, everything some values are > inserted, as I > can see in the sql-studio. Then the load on the machine goes up, the > machine becomes nonresponsive, and the only way to stop this is a > hardware reboot. After that none of the values is in the database. > Do you have any hint which of the programs (kernel or lserver) causes the load on your machine? In case it is the kernel I would like to ask you to reproduce the problem with a slow kernel (for tracing). To run the db with a slow kernel you should first stop the kernel and then start it slow with the following commands dbmcli -u <dba>,<pw> -d <db name> dbmcli_prompt> db_stop dbmcli_prompt> db_warm -s
Then reproduce the problem. After that write the trace file to disk with dbmcli -u <dba>,<pw> -d <db name> dbmcli_prompt> trace_prot akbxm The files that are of interest are located in the db rundirectory: rtedump and <dbname>.prt. Could you please send these file gzipped. Thx and regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
