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

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.