Informix

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

#Informix

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix

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

Original Message:
Sent: Fri October 29, 2021 10:12 AM
From: Andreas Legner
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix

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

Original Message:
Sent: Fri October 29, 2021 10:12 AM
From: Andreas Legner
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix

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

Original Message:
Sent: Fri October 29, 2021 10:12 AM
From: Andreas Legner
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix

Original Message:
Sent: 11/2/2021 1:09:00 PM
From: Eric Vercelletto
Subject: RE: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 10:12 AM
From: Andreas Legner
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix

Original Message:
Sent: 11/3/2021 3:30:00 AM
From: Gerd Kaluzinski
Subject: RE: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: 11/2/2021 1:09:00 PM
From: Eric Vercelletto
Subject: RE: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 10:12 AM
From: Andreas Legner
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix

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

Original Message:
Sent: Fri October 29, 2021 09:57 AM
From: Eric Vercelletto
Subject: For archecker gurus: how do I restore a sequence using archecker ?

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

#Informix