By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Question related to "CREATE TABLE AS SELECT" in DB2

P: n/a
Greetings,

I was searching Google for ways to turn off transaction logging for
some queries. I came across this old post from Feb 2003:
From: fareeda (fa*****@pspl.co.in)
Subject: Re: Question related to "CREATE TABLE AS SELECT" in DB2
Newsgroups: comp.databases.ibm-db2
Date: 2003-02-27 21:11:59 PST

FYI:

Following 3 things need to be done
1) create table as not logged initially
2) set autocommit=off
3) and activate the not logged initially option
Now the inserts happen without the use of transaction logs

Regards
Fareeda


I would like to give it a try. Steps 1 and 2 are easy enough.
However, I am not sure what is meant by step 3: "activate the not
logged initially option".

I admit I am new to DB2 so perhaps I am looking at the wrong manuals,
but how do I activate this? Is this a server configuration parameter?
Or is it a SQL command option?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DB_2 wrote:
Greetings,

I was searching Google for ways to turn off transaction logging for
some queries.
Queries are never logged, so what do you really want to do?
I came across this old post from Feb 2003:
Following 3 things need to be done
1) create table as not logged initially
2) set autocommit=off
3) and activate the not logged initially option
Now the inserts happen without the use of transaction logs

Regards
Fareeda
I would like to give it a try. Steps 1 and 2 are easy enough.
However, I am not sure what is meant by step 3: "activate the not
logged initially option".


Run "ALTER TABLE ... ACTIVATE NOT LOGGED INITIALLY"
I admit I am new to DB2 so perhaps I am looking at the wrong manuals,
but how do I activate this? Is this a server configuration parameter?
Or is it a SQL command option?


It is an SQL statement.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.