db2 admin_move_table error SQL1143N

Koen Vannisselroy

db2 admin_move_table error SQL1143N

Hello,

I run this command:

db2 "call sysproc.admin_move_table ('STG_VANNK00', 'MEETPUNT', '', '', 'MOVE')"

and i get this error:

SQL1143N  The operation cannot complete because a file error occurred for the
file "adminotm_STG_VANNK00_MEETPUNTAJqV0kt_23666_140736978700032.dat".
SQLSTATE=HY000

Does anyone recognize this error?

My assumption is that db2inst1 is not allowed to write to this file.

 

Ian Bjorhovde

db2 admin_move_table error SQL1143N
(in response to Koen Vannisselroy)
Koen,

You would probably need to look at your db2diag.log file for complete
details, but my expectation is that the instance owner file system filled
up and caused the failure.


Ian Bjorhovde


On Thu, Dec 15, 2016 at 11:33 PM, Koen Vannisselroy <[login to unmask email]>
wrote:

> Hello,
>
> I run this command:
>
> db2 "call sysproc.admin_move_table ('STG_VANNK00', 'MEETPUNT', '', '',
> 'MOVE')"
>
> and i get this error:
>
> SQL1143N The operation cannot complete because a file error occurred for
> the
> file "adminotm_STG_VANNK00_MEETPUNTAJqV0kt_23666_140736978700032.dat".
> SQLSTATE=HY000
>
> Does anyone recognize this error?
>
> My assumption is that db2inst1 is not allowed to write to this file.
>
>
>
> -----End Original Message-----
>