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

db2group88

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

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

db2group88

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