Hi good afternoon.
We are facing a large problem in our DB2 DataBase,i.e. a SQL0290N error when trying to load an empty file into several tables. Please, any help will is welcome!!
We are executing and script with a load followed by a SET INTEGRITY:
>>db2 "load client from $PATH/EmptyData.del of del modified by coldel; replace into maestro_squema.table1";
>>db2 SET INTEGRITY FOR maestro_squema.table1 ALLOW READ ACCESS IMMEDIATE CHECKED
The CHECK INTEGRITY returns an error:
"DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0290N Table space access is not allowed. SQLSTATE=55039"
And leaves the tablespace containing the "table1" in "0x0020 Backup pending", so when trying to access the "table1" we get a error sqlCode=-668 because the table integrity is not checked.
We have no idea why the tablespace is moving into "Backup pending" state.
Tablespace details with LIST TABLESPACE are as follow:
Tablespace ID = 3
Name = TBS_DAT_4K
Type = System managed space
Contents = All permanent data. Regular table space.
State = 0x0020
Total pages = 65362
Useable pages = 65362
Used pages = 65362
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 192
Number of containers = 1
Minimum recovery time = 2014-01-23-12.11.35.000000
The tablespace file system has plenty free space in disk.
Please help!! And thanks so much for reading!!!