Harish:
Some changes here:
1. Create the pipe:
mknod $(mypipe} p
2. Load data from the pipe:
Db2 "load from ${mypipe} replace into your table"
3. Export data from the pipe:
Db2 "export to ${mypipe} select from your table"
4. clean up the pipe
Thanks.
Have a nice day,
Sheila Yao
-----Original Message-----
From: Harish Reddy V. [mailto:harish.[Email address protected]
Sent: Monday, February 27, 2006 11:27 PM
To: Yao, Sheila
Subject: RE: Loading activity failed
I agree that I have to create table with correct page and load this
activity. Out of air I was just thinking if some one can suggest me an
alternative method to this.
Anyways I have just recreated table and tablespace with required page
size.
I would appreciate if you provide an example for the load activity with
pipe.
Regard
-----Original Message-----
From: Yao Sheila [mailto:[Email address protected]
Sent: Tuesday, February 28, 2006 4:20 AM
To: Harish Reddy V.
Subject: RE: Loading activity failed
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret **from
this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Bad thing is that you have to recreate the table with the correct
pagesize. I wonder if you load with pipe?
If you load table with pipe, it should be pretty fast.
How much data is 525 million rows? It shouldn't take that long to load.
Thanks.
Have a nice day,
Sheila Yao
-----Original Message-----
From: Harish Reddy V.
[Email address protected]
Sent: Monday, February 27, 2006 3:45 AM
To: LazyDBA Discussion
Subject: Loading activity failed
Hi,
I am in tricky situation now. Yesterday I have started loading data into
one of the tables in our test DB. Loading activity has run for almost 15
hours and loaded 512 million rows (suppose to load total of 525 million
rows) and stopped throwing an error as below
SQL0659N Maximum size of a table object has been exceeded.
SQLSTATE=54032
SQL2038N A database system error "-2044" occurred during processing.
SQL3532I The Load utility is currently in the "LOAD" phase.
Upon checking the tablespace I could clearly see that , the tablepsace
in this DB is 4KB pagesize where in the source from where I have
exported data in 16 KB . This could be one of culprit for this error.
I request you all to look into this and help me out resolving this.
1) Is it possible to move containers from 4KB tablespace to 16 KB
tablespace . If so how ??
2) In case if I am able to move this container to another tablespace
with enough size, is it possible to restart load activity from where it
has got failed ??
My Environment : DB2 8.1.6 on solaris
Appreciate an early respone on this.
Regards
Harish
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page