Informix

  • 1.  For archecker gurus: how do I restore a sequence using archecker ?

    Posted Fri October 29, 2021 09:58 AM
    Hi Community,

    simple question today: in case a sequence has been dropped by mistake ( not me ;-) ) How do I recover a sequence from a backup without restoring the whole thing(instance) ?

    Can archecker do the trick ?
    I have seen that archecker handles tables, but what about sequences ?
    Any other way beyond ugly workarounds ?

    Thanks in advance

    Eric

    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------


  • 2.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    IBM Select
    Posted Fri October 29, 2021 10:12 AM
    Don't think there's a provision for sequences in archecker.

    But, isn't all you really need the last value fetched from such sequence and used anywhere, for simply recreating the sequence manually?

    Then, provided that archecker/TLR doesn't forbid system table restore by name (into a differently named target table, of course), why not simply trying to restore your database's syssequences table?

    Now this is one for you to chew on over the weekend and letting us know the result ;-)

    BR,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    Posted Fri October 29, 2021 10:45 AM
    Cool one Andreas :-)

    I will let you know

    Thanks

    Eric

    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------



  • 4.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    Posted Tue November 02, 2021 01:07 PM
    Well, finally I couldn't wait for the week end to do it:
    It works like a charm :-)
    Thanks bunches @Andreas Legner

    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------



  • 5.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    Posted Tue November 02, 2021 01:09 PM

    Additional question about archecker:
    I found out that every time I want to run it with an ipcshm NETTYPE as $INFORMIXSERVER archecker fails.

    Is this expected ? If yes, why ?



    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------



  • 6.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    Posted Wed November 03, 2021 03:30 AM
    ARCHECKER is only running on TCP Connections (even documented), because it starts multi sessions and this can not
    be established with a SHM Connection.

    Mit freundlichen Grüßen / Kind regards


    Gerd Kaluzinski

    DataOps Application Consultant
    IBM Cloud and Cognitive Software
    -------------------------------------------------------------------------------------------------------------------------------------------
    IBM Deutschland
    Mies-van-der-Rohe-Straße 6
    80807 München
    Phone: +49-175-228 1983
    E-Mail: gerd.kaluzinski@de.ibm.com
    -------------------------------------------------------------------------------------------------------------------------------------------
    IBM Deutschland GmbH

    Vorsitzender des Aufsichtsrats: Sebastian Krause
    Geschäftsführung: Gregor Pillen (Vorsitzender), Agnes Heftberger, Gabriele Schwarenthorer, Christian Noll, Nicole Reimer, Frank Theisen
    Sitz der Gesellschaft: Ehningen / Registergericht: Amtsgericht Stuttgart, HRB 14562 / WEEE-Reg.-Nr. DE 99369940







  • 7.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    Posted Wed November 03, 2021 04:26 AM

    That's a clear response ��

     

    Thank you Gerd!

     

    Eric Vercelletto
    Data Management Architect and Owner / Begooden IT Consulting
    KandooERP Founder and CTO
    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

     

     






  • 8.  RE: For archecker gurus: how do I restore a sequence using archecker ?

    Posted Fri October 29, 2021 10:13 AM
    Eric:

    Probably but it will be FAR faster to just recreate it manually. All you need to know is the name of the sequence and the last value that it produced, then:

    CREATE SEQUENCE my_seq
           INCREMENT BY 1 START WITH 123456
           NOMINVALUE MAXVALUE 2337203685
           CYCLE NOCACHE ORDER;

    or

    CREATE SEQUENCE my_seq
           INCREMENT BY 1 START WITH 123456
           NOMINVALUE NOMAXVALUE
           CYCLE NOCACHE ORDER;

    Setting the START value one higher that the last value that was used from it.

    Art


    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------