The load utility uses temporary work space. It will use the current
directory if you do not specify the a temporary path. What does the LOAD
statement look like and where are you executing it from?

-----Original Message-----
From: Saldana Jose G
[mailto:db2udbdba-ezmlmshield-x47645627.[Email address protected]
Sent: Tuesday, March 11, 2008 10:08 AM
To: LazyDBA Discussion
Subject: Load error using DB2 LUW 9.1

Hello everybody,



I'm loading data into a table space that is created in file system
/db2/db2csit/data2, but when I start the load utility, the file system
that starts filling up is /db2/db2csit until gets full an throws an
error file system full.



3407872 1689584 51% 477 1% /db2/db2csit

524288 523880 1% 4 1% /db2/db2csit/db2dump

262144 261776 1% 4 1% /db2/db2csit/smstempspace

15728640 11629816 27% 8 1% /db2/db2csit/data2



This is what /db2/db2csit contains:



drwxr-xr-x 12 db2csit db2admin 4096 Mar 05 15:38 .

drwxr-xr-x 44 root system 4096 Feb 02 16:06 ..

-rwxr----- 1 db2csit db2admin 147 Aug 16 2007 .profile

-rw------- 1 db2csit db2admin 13552 Mar 09 23:18 .sh_history

-rw------- 1 db2csit db2admin 45 Feb 22 14:19 .vi_history

drwxr-xr-x 5 db2csit db2admin 4096 Feb 26 14:41 data1

drwxrwxr-x 3 db2csit db2admin 256 Nov 28 10:59 db2csit

drwxrwxr-x 3 db2csit db2admin 256 Aug 13 2007 db2dump

drwxr-xr-x 2 root system 256 Aug 13 2007 lost+found

drwxr-xr-x 2 db2csit db2admin 256 Nov 28 10:56 rscbl2

drwxrwx--- 3 db2csit db2admin 256 Aug 13 2007 smstempspace

drwxrwsr-t 18 db2csit db2admin 4096 Nov 28 10:59 sqllib





Could anyone help me troubleshooting this? How can I make the load go
into the right container? What factors are making grow the wrong file
system?



Thanks in advance



Jose Gabriel



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.7/1324 - Release Date: 3/10/2008
7:27 PM


No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.7/1324 - Release Date: 3/10/2008
7:27 PM



DB2 & UDB email list listserv db2-l LazyDBA home page