Informix

Expand all | Collapse all

Table Recycle Bin?

  • 1.  Table Recycle Bin?

    Posted Fri April 17, 2020 12:46 PM
    Greetings, Family.

    One of my users is asking about a feature he claims exists in Oracle: A sort of recycle bin for table recently dropped tables so that after the initial OhNo!second when you realize what you've just done, the table can be quickly restored.  Well, I've editorialized his description somewhat but you get the idea.  I told him about archecker but he knows about it and does not want to consider it, since it does take kinda long to pull the table back from the backup and then roll forward the logs entries on that table up to 1 minute before the finger-slip.

    Has anyone heard of a feature like that in Informix. either currently or in the works?  Otherwise, please remind me where one can enter a feature request.  If you were an Informix marketing pro, how would you respond to that question? (My hat & cane, please; I need to do a tap dance.)

    Of course, such a facility has its down side:  It won't free up the space of that table until the "recycle bin" is emptied.

    And what would you do for an inadvertent truncate the wrong table owing to a typo?  Well, the analog in files would be >file and there 's no recycle help for that. There comes a point of "tough luck, friend".

    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------


  • 2.  RE: Table Recycle Bin?

    Posted Fri April 17, 2020 12:54 PM

    Hi Jacob

     

    That looks like a cool feature, typically you want to post a Request for enhancement at that location

    https://ibm-data-and-ai.ideas.aha.io/?project=INFX

     

    If Oxxcle has it, why not Informix ?

     

    Please post your RFE and publish its URL here, so that we can vote for it

     

    Have a great week end

     

    Eric

     

     

     

    Eric Vercelletto
    Data Management Architect and Owner / Begooden IT Consulting
    Board of Directors, International Informix Users group
    IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020
    ibm-champion-rgb-130px

    Tel:     +33(0) 298 51 3210
    Mob : +33(0)626 52 50 68
    skype: begooden-it
    Google Hangout: eric.vercelletto@begooden-it.com
    Email:
    eric.vercelletto@begooden-it.com
    www :
    http://www.vercelletto.com
    www  https://kandooerp.org

    image001.jpg@01CDC3E9.1425CBB0

    image002.jpg@01CDC3E9.1425CBB0

    image003.jpg@01CDC3E9.1425CBB0

     

     






  • 3.  RE: Table Recycle Bin?

    Posted Fri April 17, 2020 01:06 PM
    Jacob:

    The closest thing we have in Informix's realm would be an RSS secondary with a DELAY_APPLY set. The secondary can be configured to any changes after a delay. I have a client that runs an HDR secondary, two RSS secondaries, one each for reporting and analytics, and a third RSS on a two hour delay to allow for easy recovery from fumble finger errors like this.

    Art





  • 4.  RE: Table Recycle Bin?

    Posted Fri April 17, 2020 02:52 PM
    Thanks Art.

    I think I'll simply post the URL of this thread to the Slack group where my user posted his question.  It is unlikely that my users have a time-delay RSS but this response is certainly likely to intrigue them.  Also, it might encourage some of them to join this forum.  Some pretty smart & knowledgeable folks.

    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------



  • 5.  RE: Table Recycle Bin?

    Posted Fri April 17, 2020 03:15 PM
    The more users on this forum the better. It adds visibility inside IBM for Informix!

    Art