IDS Forum

RE: Deleting .rsccompdict from dbspace

Posted By: Alexandre Marini
Date: Monday, 19 March 2018, at 7:40 a.m.

In Response To: Re: Deleting .rsccompdict from dbspace (ANDY W.)

Ok my friend, your case is much more complex than mine, of course.
Could you please share your defect id, so that we can track it?

Thanks a lot.
Best regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Informix on Cloud - Database Administrator - 2017
IBM dashDB Managed Service for Analytics and Transactions - 2017
DB2 Advanced DBA - v10.5 for LUW
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
Informix independent consultant
________________________________
De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de ANDY W. <aweis@arz-emmendingen.de>
Enviado: segunda-feira, 19 de março de 2018 06:53
Para: ids@iiug.org
Assunto: Re: Deleting .rsccompdict from dbspace [40874]

Hello together

As you all write I have contacted the Informix Support, and they confirmed
that "Our Problem" is a bug, which is treated as defect and will be fixed in
the next Informix Release. I´ll try to explain where the matter is...

The Problem occurs when the first Table which should be compressed in a
DBSPACE is a AUTO COMPRESSED PARTITIONED TABLE. After initial filling the
Table, you are not able to delete the .rsscompdict, and so it is not possible
to drop the DBSPACE. The Support told us, that reinitialize (!!) is the only
chance to solve this. But the Support told us also, that there is a much
bigger Problem, when running into that special Bug... After server restart it
could happen that other Compression Dictionaries (not related with this Table)
are no longer accesable, and so also of course the Data is lost. We have not
faced that Problem IBM mentioned, so I cannot say more about it.

IBM also told us a workaround which is pretty simple. Just compress a single
existing Table in the DBSPACE BEFORE creating a AUTO COMPRESSED PARTITIONED
TABLE in the DBSPACE will protect you of this defect. But i would not count on
it on a Live System, so we have decided to wait until we start to compress
Tables at least until this bug is fixed.

Andy Weis

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Deleting .rsccompdict from dbspace
  ANDREAS WEIS -- Monday, 15 January 2018, at 4:38 a.m.
  • Re: Deleting .rsccompdict from dbspace
    david@smooth1.co.uk -- Monday, 15 January 2018, at 7:40 a.m.
    • Re: Deleting .rsccompdict from dbspace
      ANDREAS WEIS -- Monday, 15 January 2018, at 8:09 a.m.
      • Re: Deleting .rsccompdict from dbspace
        david@smooth1.co.uk -- Monday, 15 January 2018, at 11:01 a.m.
        • Re: Deleting .rsccompdict from dbspace
          ANDREAS WEIS -- Wednesday, 17 January 2018, at 3:34 a.m.
          • Re: Deleting .rsccompdict from dbspace
            david@smooth1.co.uk -- Wednesday, 17 January 2018, at 3:54 a.m.
            • Re: Deleting .rsccompdict from dbspace
              JEAN-FRANCOIS BOUDRY -- Friday, 19 January 2018, at 2:53 a.m.
              • Re: Deleting .rsccompdict from dbspace
                ALEXANDRE MARINI -- Monday, 12 March 2018, at 10:17 a.m.
                • Re: Deleting .rsccompdict from dbspace
                  ANDY W. -- Monday, 19 March 2018, at 5:53 a.m.
                  • RE: Deleting .rsccompdict from dbspace
                    Alexandre Marini -- Monday, 19 March 2018, at 7:40 a.m.
                    • Re: RE: Deleting .rsccompdict from dbspace
                      ANDY W. -- Monday, 19 March 2018, at 7:50 a.m.
                      • Re: RE: Deleting .rsccompdict from dbspace
                        Alexandre Marini -- Monday, 19 March 2018, at 8:41 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.