469,926 Members | 2,174 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

activate not logged initially - bug or feature?

I'm sorry but previously command

ALTER TABLE tbl ACTIVATE NOT LOGGED INITIALLY

on table created without NOT LOGGED INITIALLY option was impossible.
Or not?

IMHO, more better give error or warning on this statement for table
created wihtout NOT LOGGED INITIALLY.

Andy

May 19 '06 #1
4 2771
bughunter@ru wrote:
I'm sorry but previously command

ALTER TABLE tbl ACTIVATE NOT LOGGED INITIALLY

on table created without NOT LOGGED INITIALLY option was impossible.
Or not?

IMHO, more better give error or warning on this statement for table
created wihtout NOT LOGGED INITIALLY.

You are correct that this used to be teh case.
However to perform such an alter you need at leats control over the
table and the amount of damage that can be done is no bigger (or
smaller) than using a LOAD REPLACE with empty table.
So there was really no point in an error.
Warnings in my experience get either ignored by customers or treated
like error....

Either way, it is what it is now. There is no going back.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
May 19 '06 #2
I'm customer too and don't ignore any warnings :-) But I was very
surprised when a some numbers of table was in inconsistence state after
restore from online backup. And it was very important tables. Yes, it
was a bug in my script - I made mistake in schema name. But no way to
detect this sutiation. For example, I can detect tables with not logged
property and can use this attribute to avoid sutiation with lost
table/data after restore from online backup. Currently this property is
not useful :-(.

Another question - how detect inconsistence tables after restore?

Andy

May 19 '06 #3

bughunter@ru wrote:
I'm customer too and don't ignore any warnings :-) But I was very
surprised when a some numbers of table was in inconsistence state after
restore from online backup. And it was very important tables. Yes, it
was a bug in my script - I made mistake in schema name. But no way to
detect this sutiation. For example, I can detect tables with not logged
property and can use this attribute to avoid sutiation with lost
table/data after restore from online backup. Currently this property is
not useful :-(.

Another question - how detect inconsistence tables after restore?


Dont know whether restore is a special case, but status is normally
what I look for

select tabschema, tabname, status from syscat.tables where status <>
'N'
/Lennart

May 19 '06 #4
Status = 'N'. I have no idea how found a tables with

[IBM][CLI Driver][DB2/NT] SQL1477N Table "LOADING.ACCNTAB" cannot be
accessed. SQLSTATE=55019

Only one method - create script with select from all tables

select 'select 1 from ' || CREATOR ||'.'||name||' fetch first row
only;'
from SYSIBM.SYSTABLES
where creator not like 'SYS%' and type = 'T'
;

then run and check. But for db with more 1K tables it's a very long
process.

2ibm team - what's do you think? Why are you change a normal working
ability?
More better do storing a original text (format) for
view/trigger/function.

Andy

May 25 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Joshua Beall | last post: by
4 posts views Thread by Alexander Pope | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.