Archecker problems
Posted in 2018
Hi,
I'm trying to restore a table into a temporary table, but i'm having one
error, and i can not find information about it.
This is the log:
STATUS: Arguments [-bdvs -X -f file.cmd]
STATUS: AC_STORAGE /tmp
STATUS: AC_MSGPATH /tmp/ac_msg.log
STATUS: AC_VERBOSE on
STATUS: AC_TAPEBLOCK 2048 KB
STATUS: AC_IXBAR /opt/ids1210fc10/etc/ixbar.130
STATUS: AC_SCHEMA file.cmd
TIME: [2018-10-01 09:37:29] All old validation files removed.
STATUS: Dropping old log control tables
STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
STATUS: Temporary workspace has been set
STATUS: Restore only physical image of archive
STATUS: Target table [tabla_temporal] already created
STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR tabla_temporal DISABLED]
STATUS: Extracting table BBDD:tabla into BBDD:tabla_temporal
WARNING: Source table [tabla] has no storage option
ERROR: No storage space to scan
STATUS: No storage space to scan
STATUS: archecker completed Physical Restore pid = 1251 exit code: 3
And this is the cmd file:
set workspace to dbspace;
database BBDD;
create table tabla
(
a decimal(11,0) not null
) extent size 16 next size 16 lock mode row;
create table tabla_temporal
(
a decimal(11,0) not null ,
) extent size 16 next size 16 lock mode row;
insert into tabla_temporal select * from tabla;
restore to "2018-09-24 05:00:00" with no log;
Any idea about what is happening?
Thanks in advance.