If the table went into SQLCODE=-1477, SQLSTATE=55019 . Is there any option to revert this back without dropping & recreating this.
I altered a table with NOT LOGGED INITIALLY & After that tried to update that table & I can't able to access my table.
Can some one suggest me what have to do without recreating this.
If you activated 'not logged initially' and the UOW failed, you can only drop and recreate the table (docs have clear warnings about this).
Inexperienced people should never use 'not logged initially' without taking all necessary precautions against this situation.
A much safer option is a DGTT or CGTT.