472,988 Members | 2,927 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,988 software developers and data experts.

create table .... not logged initially error or not?

hi, we install db2 udb v8.1 on windows 64bit, in our application, we
have sql execute "create table .... not logged initially", but from
the operating system event viewer showing error stating that ADM5530E
The COMMIT processing of table "TBSPACEID=3.TABLEID=15107" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you
take a
backup of this table's table space(s).

since our application need to create table on the run time many times,
so the errors keep increasing, but i don't see why when i create a
table without trying to log the info will cause error? anyway to fix
it? thanks
Nov 12 '05 #1
2 4242
Ian
db********@yahoo.com wrote:
hi, we install db2 udb v8.1 on windows 64bit, in our application, we
have sql execute "create table .... not logged initially", but from
the operating system event viewer showing error stating that ADM5530E
The COMMIT processing of table "TBSPACEID=3.TABLEID=15107" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you
take a
backup of this table's table space(s).

since our application need to create table on the run time many times,
so the errors keep increasing, but i don't see why when i create a
table without trying to log the info will cause error? anyway to fix
it? thanks


This is not an error message, it's a warning. It's warning you that
you won't be able to recover the data in the table without performing
a backup of the tablespace.

What is the NOTIFYLEVEL dbm config param set to (this controls how much
info gets written to the windows event log).


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
but from the event viewer, i do see it is showing as error (the event
viewer tell me it is error with red stop sign). currently the
notifylevel is 3. i will change to 2 to see how it works, is this the
right way to do it?

Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@corp.newsgroups.com>...
db********@yahoo.com wrote:
hi, we install db2 udb v8.1 on windows 64bit, in our application, we
have sql execute "create table .... not logged initially", but from
the operating system event viewer showing error stating that ADM5530E
The COMMIT processing of table "TBSPACEID=3.TABLEID=15107" that used
NOT LOGGED INITIALLY has been initiated. It is recommended that you
take a
backup of this table's table space(s).

since our application need to create table on the run time many times,
so the errors keep increasing, but i don't see why when i create a
table without trying to log the info will cause error? anyway to fix
it? thanks


This is not an error message, it's a warning. It's warning you that
you won't be able to recover the data in the table without performing
a backup of the tablespace.

What is the NOTIFYLEVEL dbm config param set to (this controls how much
info gets written to the windows event log).


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: yongsing | last post by:
I tried to create an index on a column of a table. It failed because the creation caused the transaction log to be full. What can I do? Should I export out the data in the table, then recreate the...
2
by: xixi | last post by:
hi, i found that in alter table command , you can do activate not logged initially to help not log any changes made to the table to log file, cause i have to delete almost 1 million records and my...
1
by: DB_2 | last post by:
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 (fareeda@pspl.co.in) > Subject: Re:...
1
by: Daniel Chou | last post by:
Hello, I have two questions about "not logged initially": 1. Before using "alter table tbname activate not logged initially", should the table be created with "not logged initially"? 2....
1
by: efiryago | last post by:
I have about 200 tables in a DB2 V8.1.4 LUW application schema. There is a third party java appllication that accesses this schema. It started failing and relevant entries in db2diag.log have this:...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
6
by: pramod | last post by:
Hi I know we can truncate a table in DB2 by first creating it with NOT LOGGED INITIALLY option. and when we need to truncate it, run the following command alter table <table name> activate...
2
by: tojigneshshah | last post by:
Hi, In a stored procedure, If i use "alter table <tablename> activate not logged intially with empty table", i get SQL104n error. If i use "execute immediate alter table <tablename>...
10
by: Troels Arvin | last post by:
Hello, Until this date, I believed that DB2 has no TRUNCATE TABLE command. But then I came across...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.