SEO

#1 (**permalink**) 02-26-2008, 05:39 PM

On Tue, 30 Mar 2004 14:17:11 +0200, Knut Stolze wrote:

> Drop the table or truncate it.

Dropping the table was easy, and worked.

Now, I have a rather large table of around 8 million rows with the
following structure:

CREATE TABLE person (
fullname VARCHAR(60) NOT NULL PRIMARY KEY,
age INT NOT NULL CHECK(age>29)
);

The host that I'm experimenting on is not very powerfull, so I'd also like
a smaller table for some of my tests. I did this:

CREATE TABLE child (
fullname VARCHAR(60) NOT NULL PRIMARY KEY,
age INT NOT NULL CHECK(age>=0)
);

I wanted to populate it like this:

INSERT INTO CHILD
SELECT fullname,(age-30) AS age
FROM person;

However, again, I run into a transaction log wall after a while:
SQL0964C The transaction log for the database is full. SQLSTATE=57011

How do I solve this one?

--
Greetings from Troels Arvin, Copenhagen, Denmark

#2 (**permalink**) 02-26-2008, 05:39 PM

Two choices I can think of:
1. Declare a cursor on PERSON and LOAD inro CHILD
2. ALTER TABLE CHILD ACTIVE NOT LOGGED INITIALLY.
Then insert from select as you propose.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

#3 (**permalink**) 02-26-2008, 05:39 PM

If you're at v8 fp2 or higher, you can do something like
select * from employee tablesample system 10

This would select 10 percent of the table.

PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: Importing large comma-separated file