-903,Host file I/O error

Hello,

I've got this error while starting a backup of my database(7.4.3.32):
ERR
-24988,ERR_SQL: sql error
-903,Host file I/O error

If I restart the database the backup will success. But after a while (a few
days) the error comes back.
I found the following error message in knldiag.err while backup failed:

2004-11-14 04:36:07  1131 ERR 11000 d0_aopen Error during thread creation,
resource limit.
2004-11-14 04:36:07  1225 ERR 52012 SAVE     error occured, basis_err 3700


Is this an os resource limit? I use SLES 8.0.
I tried to modifiy the limits.conf for the user sapdb:

sapdb@db:~> ulimit -a
core file size        (blocks, -c) 0
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
max locked memory     (kbytes, -l) unlimited
max memory size       (kbytes, -m) unlimited
open files                    (-n) 4096
pipe size          (512 bytes, -p) 8
stack size            (kbytes, -s) unlimited
cpu time             (seconds, -t) unlimited
max user processes            (-u) 7168
virtual memory        (kbytes, -v) unlimited


But the maximum number of threads is still 1024:

2004-11-22 05:42:04  9910     12931 INFO     maximum cpu time: unlimited
2004-11-22 05:42:04  9910     12932 INFO     maximum number of processes: 0
MB
2004-11-22 05:42:04  9910     12891 INFO     maximum core size: 0 MB
2004-11-22 05:42:04  9910     12892 INFO     maximum number of open files:
4096
2004-11-22 05:42:04  9910     12933 INFO     maximum file size: unlimited
2004-11-22 05:42:04  9910     12895 INFO     maximum number of threads: 1024
2004-11-22 05:42:04  9910     12934 INFO     maximum stack size: unlimited
2004-11-22 05:42:04  9910     12935 INFO     lockable memory size: unlimited
2004-11-22 05:42:04  9910     12893 INFO     maximum virtual memory size:
unlimited
2004-11-22 05:42:04  9910     12936 INFO     resident set size size:
unlimited
2004-11-22 05:42:04  9910     12894 INFO     maximum heap size: unlimited


Am I on the right way? How can I increase the maximum number of threads?
Thanks for helping,

regards,
Kolja


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx