ERROR [55019] [IBM][DB2/NT] SQL1477N? For table "DB_YHJX.YHJX_FHDKFHZ" an object "521" in table space "3" cannot be accessed.? SQLSTATE=55019
SQL1477N? 對(duì)于表 "<表名>"，不能訪問表空間 "<表空間標(biāo)識(shí)>" 中的對(duì)象 "<對(duì)象標(biāo)識(shí)>"。
說明:
試圖訪問一個(gè)表，而該表的其中一個(gè)對(duì)象是不可訪問的。由于下列原因之一，該表可能不可訪問：
1.當(dāng)回滾工作單元時(shí)，該表激活了 NOT LOGGED INITIALLY。
2.該表是一個(gè)已創(chuàng)建的分區(qū)臨時(shí)表或者已聲明的分區(qū)臨時(shí)表，由于已聲明此臨時(shí)表或者已將它實(shí)例化，因此一個(gè)或多個(gè)數(shù)據(jù)庫分區(qū)失敗。
3.ROLLFORWARD 在此表上遇到了 NOT LOGGED INITIALLY 激活，或者遇到了NONRECOVERABLE 裝入。
不允許訪問此表，因?yàn)椴荒鼙ＷC其完整性。
是不是你的存儲(chǔ)過程里 有將表清空的語句類似于
ALTER TABLE? 表名 ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

I got a call from a lication team yesterday
that many tables are "can not be acceed" all of sudden.

SQL1477N? Table "RI_ A_T1" ca ot be acceed.? SQLSTATE=55019
SQL1477N? Table "RI_ L_T2" ca ot be acceed.? SQLSTATE=55019
SQL1477N? Table "RI_ T_T3" ca ot be acceed.? SQLSTATE=55019
SQL1477N? Table "RI_PTC_T4" ca ot be acceed.? SQLSTATE=55019

After talking to the developer, he coded some tables with "not logged initially" hope to get better performance,
somehow a job did not complete succe fully and caused many tables in-co istent state.

It mea? that whenever you i ue ALTER TABLE ... ACTIVATE NOT LOGGED INITIALLY then everything between that and the next commit is not logged.
If you encounter a rollback/failure, as you recover the table is marked inacce ible and you ca ot recover it.
Your only option is "DROP" and then "CREATE"? those in question tables again.

Holly smoke! I understand now why those IBM guys brag db2 is so superior than Oracle --
(UDB software lab is in Toronto, got lucky talk to those db2 developers/managers face to face).?
Fortunately, db2 dba is only my secondary job.? How do you guys feel?? Look at those Oracle forums so red and hot.

總結(jié)：NOT LOGGED INITIALLY慎用，中途失敗將導(dǎo)致表要被刪除重建。

DB2 SQL1477N問題