canceling admin_move_table fails if source table have restrict on drop
in [DB2]
|
Prev: Password validation messages
Next: canceling admin_move_table fails if source table have restricton drop
From: hsn_ on 8 Jun 2010 02:31 db2 => create table z2 (a integer) in alexaidx DB20000I Pøíkaz SQL byl úspì¹nì dokonèen. db2 => alter table z2 add restrict on drop DB20000I Pøíkaz SQL byl úspì¹nì dokonèen. db2 => call sysproc.admin_move_table(current schema,'Z2','USERSPACE1','USERSPACE 1','USERSPACE1',NULL,NULL,NULL,NULL,NULL,'INIT') Výsledná sada 1 -------------- KEY VALUE -------------------------------- --------------------------------------------- -------------------------------------------------------------------------------- --- AUTHID MAJITEL INDEXNAME INDEXSCHEMA INIT_END 2010-06-08-08.24.13.953000 INIT_START 2010-06-08-08.24.13.718000 STAGING Z2AAAAXSs STATUS COPY TARGET Z2AAAAXSt VERSION 09.07.0002 Bylo vybráno 9 záznamù. Stav pøi návratu = 0 db2 => call sysproc.admin_move_table(current schema,'Z2','USERSPACE1','USERSPACE 1','USERSPACE1',NULL,NULL,NULL,NULL,NULL,'CANCEL') SQL0672N Operace DROP není pro tabulku "MAJITEL.Z2AAAAXSt" povolena. SQLSTATE=55035 |