Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Cannot drop a database

    Posted 08/01/23 09:47 AM

    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
    ------------------------------


  • 2.  RE: Cannot drop a database

    Posted 08/01/23 09:59 AM
    Had that one before, I think you will need IBM to hack it. I just deleted all tables manually except tscontainertable (dumb table name) and renamed the DB.

    Cheers
    Paul

    On 8/1/2023 8:47 AM, Jean Francois BOUDRY via IBM TechXchange Community wrote:
    01000189b15a1c81-fdbdecd6-3959-49b8-a7b1-5fb191e9459c-000000@email.amazonses.com">
    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... -posted to the "Informix" group
    IBM TechXchange Community

    Informix

    Post New Message
    Cannot drop a database
    Reply to Group Reply to Sender
    Jean Francois BOUDRY
    Aug 1, 2023 9:47 AM
    Jean Francois BOUDRY

    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
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  



     
    You are subscribed to "Informix" as paul@oninit.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe. 

    --  Paul Watson Oninit www.oninit.com Tel: +1 913 364 0360 Cell: +1 913 387 7529  Oninit® is a registered trademark of Oninit LLC  If you want to improve, be content to be thought foolish and stupid Failure is not as frightening as regret





  • 3.  RE: Cannot drop a database

    Posted 08/01/23 10:14 AM

    Thank you Paul

    I did the same,
    If no workaround, this database will stay here with its new name.



    ------------------------------
    Jean Francois BOUDRY
    ------------------------------



  • 4.  RE: Cannot drop a database

    Posted 08/01/23 10:17 AM
    I thought it was fixed though in 12.10.something, not seen in 14.10

    On 8/1/2023 9:14 AM, Jean Francois BOUDRY via IBM TechXchange Community wrote:
    01000189b17301d0-d11bd899-dfbe-443e-a03b-7d602a99e1d9-000000@email.amazonses.com">
    Thank you Paul I did the same, If no workaround, this database will stay here with its new name. ------------------------------ Jean Francois... -posted to the "Informix" group
    IBM TechXchange Community

    Informix

    Post New Message
    Re: Cannot drop a database
    Reply to Group Reply to Sender
    Jean Francois BOUDRY
    Aug 1, 2023 10:14 AM
    Jean Francois BOUDRY

    Thank you Paul

    I did the same,
    If no workaround, this database will stay here with its new name.



    ------------------------------
    Jean Francois BOUDRY
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  
    -------------------------------------------
    Original Message:
    Sent: Tue August 01, 2023 09:46 AM



     
    You are subscribed to "Informix" as paul@oninit.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.



    Original Message


  • 5.  RE: Cannot drop a database

    Posted 08/01/23 08:33 PM

    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


  • 6.  RE: Cannot drop a database

    Posted 08/02/23 04:01 AM

    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


  • 7.  RE: Cannot drop a database

    Posted 08/02/23 04:57 AM

    Hi,

    The definition of 

    "informix".tspartitiondesc_t 

    does that reference the datablade?

    Regards,
    David.



    ------------------------------
    David Williams
    ------------------------------

    Original Message


  • 8.  RE: Cannot drop a database

    Posted 08/03/23 04:37 AM

    Hi,

    no, it is a lvarchar.

    create distinct type "informix".tspartitiondesc_t as  lvarchar ;

    But i think i will let this database, it is not critical and it does not use space.

    Thank you for your help


    Regards



    ------------------------------
    Jean Francois BOUDRY
    ------------------------------

    Original Message


Related Content