Original Message:
Sent: Wed August 02, 2023 04:57 AM
From: David Williams
Subject: Cannot drop a database
Hi,
The definition of
"informix".tspartitiondesc_t
does that reference the datablade?
Regards,
David.
------------------------------
David Williams
Original Message:
Sent: Wed August 02, 2023 04:00 AM
From: Jean Francois BOUDRY
Subject: Cannot drop a database
Thank you David.
But don't really understand what you are calling the 'access method for that table'
There are some references to Timeseries Datablade in the dbimport.out file, but nothing linked to tscontainertable.
And about user table kpi_informix, as was able to drop it.
{ TABLE "informix".tscontainertable row size = 2442 number of columns = 5 index size = 134 }
create table "informix".tscontainertable
(
name varchar(128,1) not null ,
subtype varchar(128,1) not null ,
partitiondesc "informix".tspartitiondesc_t not null ,
flags integer not null ,
pool varchar(128,1)
) extent size 32 next size 32 lock mode row;
revoke all on "informix".tscontainertable from "public" as "informix";
{ unload file name = tscon00121.unl number of rows = 6 }
create unique index "informix".tscontainertable_pk on "informix"
.tscontainertable (name) using btree in table ;
alter table "informix".tscontainertable add constraint primary
key (name) constraint "informix".tscontainertable_cpk ;
{ TABLE "informix".kpi_informix row size = 2056 number of columns = 2 index size = 0 }
{ unload file name = kpi_i00127.unl number of rows = 1 }
create table "informix".kpi_informix
(
kpi_id integer,
cpu_data timeseries(kpi_cpu)
) extent size 32 next size 32 lock mode row;
revoke all on "informix".kpi_informix from "public" as "informix";
*** put loadcur
937 - *** (UTSDF) - Routine mi_get_table_partnum execution failed.
User Defined Routine error.
Regards
------------------------------
Jean Francois BOUDRY
Original Message:
Sent: Tue August 01, 2023 08:33 PM
From: David Williams
Subject: Cannot drop a database
Hi,
Can you look in the dbexport sql file and work out which access methods that load the datablade are used for that table?
Drop and recreate the access methods using the correct path to the datablade file and try again.
Regards,
David.
------------------------------
David Williams
Original Message:
Sent: Tue August 01, 2023 10:14 AM
From: Jean Francois BOUDRY
Subject: Cannot drop a database
Thank you Paul
I did the same,
If no workaround, this database will stay here with its new name.
------------------------------
Jean Francois BOUDRY
Original Message:
Sent: Tue August 01, 2023 09:46 AM
From: Jean Francois BOUDRY
Subject: Cannot drop a database
Hi,
using IDS 14.10FC8 on AIX.
i tried to dbexport/dbimport a database including timeseries.
The dbimport failed.
But now i am not able to drop the database :
CFRSV50211016DB<informix></sauvegarde/kpi2/kpi2>echo "drop database kpi_old"|dbaccess -
214: Cannot remove file for table (informix.tscontainertable).
Error in line 1
Near character position 21
CFRSV50211016DB<informix></sauvegarde/kpi2/kpi2>echo "drop table tscontainertable"|dbaccess kpi_old
Database selected.
214: Cannot remove file for table (informix.tscontainertable).
110: ISAM error: end or beginning of the file.
Error in line 1
Near character position 27
Database closed.
i can select and insert in tscontainertable , but cannot drop this table.
I found this APAR : IT27525: DBEXPORT/DBIMPORT OF A DATABASE WHICH HAS BLADES INSTALLED DOESEN'T WORK PROPERLY
| Ibm | remove preview |
| | IT27525: DBEXPORT/DBIMPORT OF A DATABASE WHICH HAS BLADES INSTALLED DOESEN'T WORK PROPERLY | | When using a dbexport of a database with Timesseries of version 11.70 to dbimport it in version 12.10. will leave database | | View this on Ibm > |
|
|
But there is no workaround explained.
Does someone has a solution to drop this database ?
It is on a production machine so i have to take care, but this database does not have any impact on production.
Regards
------------------------------
Jean Francois BOUDRY
------------------------------