while ((select count(*) from myschema.mytable where var = invar ) > 0 ) do
	delete
		from myschema.mytable
			where id_col in
			(select id_col
				from myschema.mytable
				where var = invar
				fetch first 250000 rows only
			);
	commit;
end while;

while ((select count(*) from myschema.mytable1 where var = invar ) > 0 ) do
	delete
		from myschema.mytable1
			where id_col in
			(select id_col
				from myschema.mytable2
				where var = invar
				fetch first 250000 rows only
			);
	commit;
end while;

while ((select count(*) from myschema.mytable1 where var = invar ) > 0 ) do
	delete
		from myschema.mytable1
			where id_col in
			(select id_col
				from myschema.mytable2
				where var = invar
				fetch first 250000 rows only
			);
	commit;
end while;

while ((select count(*) from myschema.mytable1 where var = invar ) > 0 ) do
	delete
		from myschema.mytable1
			where id_col in
			(select id_col
				from myschema.mytable1
				where id_col in
				(select id_col
					from myschema.mytable2
					where var = invar
				)
			) fetch first 250000 rows only
	commit;
end while;

SQL1477N  Table "db2admin.table" cannot be accessed.  SQLSTATE=55019

SQL1477N Table "<table-name>" cannot be accessed.

Explanation:

An attempt was made to access a table that is not accessible.
The table may not be accessible because of one of the following
reasons:

o   The table had NOT LOGGED INITIALLY activated when the unit of
    work was rolled back.

o   The table is a partitioned declared temporary table and one
    or more partitions failed since the temporary table was
    declared (all declared temporary tables have the schema name
    SESSION).

o   ROLLFORWARD encountered the activation of NOT LOGGED
    INITIALLY on this table or a NONRECOVERABLE load on this
    table.



 Access to this table is not allowed because its integrity cannot
be guaranteed.

User Response:

 One of the following actions can be taken.

o   If the table had NOT LOGGED INITIALLY activated, drop the
    table.  If this table is required, re-create it.

o   If the table is a declared temporary table, drop the table.
    If this table is required, declare it again.

o   Otherwise, restore from a tablespace or database backup.  The
    backup image must have been taken subsequent to the commit
    point following the completion of the non-recoverable
    operation (NOT LOGGED INITIALLY operation, or NONRECOVERABLE
    load).



 sqlcode :  -1477

 sqlstate :  55019