You provided info about /var mount point only, would you pls post the full ouput of df -v, so that I could suggest better path for symlink, i want to know the status of your hard disk usage and available free space.

Filesystem 512-blocks Used Avail Capacity Mounted on
/dev/ad4s1a 507356 231688 235080 50% /
devfs 2 2 0 100% /dev
/dev/ad4s1e 507356 8464 458304 2% /tmp
/dev/ad4s1f 299159088 87655644 187570720 32% /usr
/dev/ad4s1d 507356 327368 139400 70% /var
/dev/ad0s1d 37870748 1448372 33392720 4% /backup
devfs 2 2 0 100% /var/named/dev

ok, you can try this: With the above command, you'll write any thing to /var/tmp, it'll be physically stored on /usr/tmp and will use space available there and should not create any problem. Make sure that /usr/tmp doesn't exist, otherwise it'll overwrite its contents.

Regards,
Tayyab

Thanks a lot...will try it and get back to u

do i need to do any restart? or stopping any service before i execute the ln command ?

Thanks

It didn't work
I still get the same error when i run big queries, and the same query works if i limit the number to first 2000 records

this is the error
Error writing file '/var/tmp/MYjXmzH0' (Errcode: 28)

Any idea what to do next ?

Shereenmotor,

It seems that u gave me the link command in reverse.
we removed the link and dit it with usr\tmp as the second parameter and the link is created now.
even with the link created, the same error of failing to write on the tempdir is still there...

I gave the right command, ok let me explain the command in detail. Remove the existing links, and do the following steps:

1)Copy all files from /var/tmp to /usr/tmp with command: 2) Remove directory /var/tmp to release the space: 3)then Run the following symlink command: Hope its helps.

Regards,
Tayyab