Does the table has any check constraint and when you're loading the
table does the massage file increase rapidly? I guess there is a
generated value of some kind and you're load is trying to load in to
this column and generates an error and writes it to the massage file.
Check this it may be filling up space very rapidly :)
Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
>*:vishnuvardan.[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: Saldana Jose G
[mailto:db2udbdba-ezmlmshield-x57848442.[Email address protected]
Sent: Tuesday, March 11, 2008 7:51 PM
To: LazyDBA Discussion
Subject: RE: Load error using DB2 LUW 9.1
The load looks like:
db2 "load from file.txt of del modified by coldel~ savecount 50000
messages msg10.txt insert into tableName"
and it's executed from this file:
15728640 11629816 27% 8 1% /db2/db2csit/data2
-----Original Message-----
From: John Jonascu
[mailto:db2udbdba-ezmlmshield-x12677998.[Email address protected]
Sent: Tuesday, March 11, 2008 9:14 AM
To: LazyDBA Discussion
Subject: RE: Load error using DB2 LUW 9.1
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
DB2 & UDB email list listserv db2-l LazyDBA home page