467,926 Members | 1,521 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

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
  • viewed: 3973
Share:
2 Replies
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by yongsing | last post: by
1 post views Thread by efiryago | last post: by
6 posts views Thread by pramod | last post: by
2 posts views Thread by tojigneshshah | last post: by
10 posts views Thread by Troels Arvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.