00E70081

Explanation
An SQL statement was issued, but the object that was referenced by the statement cannot be
created, altered, renamed, or dropped. The object is referenced by a prepared dynamic SQL statement
that is currently stored in the dynamic statement cache and is in use by an application.

System action
The requested operation is not performed.

Programmer response

The requested operation cannot be performed until other applications are not referencing the
object by using dynamic SQL. Invalidating a cached statement that references the object by using
RUNSTATS does not accomplish this task. 

Instead, ensure that other applications have quiesced or performed a commit operation. Then, try
the request again. You can also increase the value of the DDLTOX subsystem parameter so that the
statement can wait longer while other applications that reference the object quiesce or perform a
commit operation. 

Problem determination
An SQLCODE -904 is issued.
The message tokens for
that message report the name and type of the object that was referenced.

The resource name is in the form statement-ID or
member-name.statement-ID. statement-ID is
the statement identifier of the statement in the dynamic statement cache that has a claim on an
object that cannot be created, altered, renamed, or dropped.  If the application is running in a
data sharing environment, member-name is the name of the data sharing member on
which the statement is running.

See Collecting data for a cached dynamic statement that blocks another statement with reason code 00E70081 for instructions on how to collect information about the statement that is causing the error.