DB2 SQL1477N问题
ERROR SQL1477NFor table "DB_YHJX.YHJX_FHDKFHZ" an object "521" in table space "3" cannot be accessed.SQLSTATE=55019SQL1477N对于表 "<表名>"，不能访问表空间 "<表空间标识>" 中的对象 "<对象标识>"。
说明:
试图访问一个表，而该表的其中一个对象是不可访问的。由于下列原因之一，该表可能不可访问：
1.当回滚工作单元时，该表激活了 NOT LOGGED INITIALLY。
2.该表是一个已创建的分区临时表或者已声明的分区临时表，由于已声明此临时表或者已将它实例化，因此一个或多个数据库分区失败。
3.ROLLFORWARD 在此表上遇到了 NOT LOGGED INITIALLY 激活，或者遇到了NONRECOVERABLE 装入。
不允许访问此表，因为不能保证其完整性。
是不是你的存储过程里 有将表清空的语句类似于
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.
SQL1477NTable "RI_ A_T1" ca ot be acceed.SQLSTATE=55019
SQL1477NTable "RI_ L_T2" ca ot be acceed.SQLSTATE=55019
SQL1477NTable "RI_ T_T3" ca ot be acceed.SQLSTATE=55019
SQL1477NTable "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 meathat 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.
总结：NOT LOGGED INITIALLY慎用，中途失败将导致表要被删除重建。
页:
[1]