Wiki source code of Reset H2 Database

Last modified by Danniar Firdausy on 2024/09/19 10:17

Hide last authors
Eva Torken 1.1 1 {{container}}
2 {{container layoutStyle="columns"}}
3 (((
Erik Bakker 12.1 4 eMagiz runtimes may contain H2 databases. These databases might need to be wiped clean. This microlearning will guide you through the process of resetting such H2 databases and will also inform you on the considerations that are important before resetting.
Eva Torken 1.1 5
6 Should you have any questions, please get in touch with [[academy@emagiz.com>>mailto:academy@emagiz.com]].
7
8 == 1. Prerequisites ==
9
10 * Intermediate knowledge of the eMagiz platform
11
12 == 2. Key concepts ==
Danniar Firdausy 13.11 13 This microlearning centers on the reset of a H2 database. The key aspects are:
Danniar Firdausy 13.12 14 * When to use the H2 reset option.
15 * How to perform a H2 reset.
Danniar Firdausy 13.11 16 * Implications of resetting the H2 database.
Eva Torken 1.1 17
18 == 3. H2 Database reset ==
Erik Bakker 12.1 19 A reset of the H2 database is used when the database is not performing as expected. This can be because it is retaining the information it is supposed to deliver. It can also be that the database has been unstable and is therefore not performing correctly.
Eva Torken 1.1 20
Eva Torken 3.1 21 === 3.1 Cloud ===
Eva Torken 6.1 22 In short, the reset of a H2 database is described below.
Eva Torken 7.1 23 * The reset of the H2 database does the following:
Danniar Firdausy 13.12 24 ** Removes the H2 databases that are registered under the standard eMagiz data folder.
25 ** Re-adds the removed H2 databases.
26 * With a reset, you start with a clean slate.
27 ** H2 databases are emptied.
Eva Torken 4.1 28
Eva Torken 3.1 29 [[image:Main.Images.Release Blog.WebHome@release-217-template-tango-remove-h2.png]]
Eva Torken 1.1 30
Erik Bakker 12.1 31 To execute this action please navigate to Deploy -> Architecture. After you have done so you can access the context menu of a particular runtime (via a right mouse click), while in "Start Editing" mode, and select the option called "Reset H2". By pressing this button you execute all steps mentioned above. It is possible to press the 'Reset H2' button for all cloud runtimes, it will however **only have an effect** if a H2 database exists for the runtime.
Eva Torken 3.1 32
33 === 3.2 On-premise ===
Erik Bakker 12.1 34 When the H2 database of an on-premise runtime needs to be reset the action needed is different. Here, the only action needed is to reset the runtime. This is because the H2 database is stored inside the container when running on-premise instead of in EFS as it is in the cloud.
Eva Torken 3.1 35
Eva Torken 4.1 36 For more information on resetting a runtime, please check out the following microlearning:
Eva Torken 5.1 37 * [[Reset runtime>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.eMagiz Runtime Management.intermediate-emagiz-runtime-management-reset-runtime.WebHome||target="blank"]]
Eva Torken 6.1 38
39 === 3.3 Implications ===
Erik Bakker 12.1 40 Resetting a database has implications. It will remove and re-add all H2 databases on the runtime you have selected. Therefore, all data, which are most likely functional messages, in the databases will be lost. This should be taken into account before deciding to reset a H2 database.
Eva Torken 6.1 41
Eva Torken 1.1 42 == 4. Key takeaways ==
43
Danniar Firdausy 13.12 44 * The 'Reset H2' button empties all registered H2 databases within the default eMagiz data folder.
45 * The 'Reset H2' button is only used for cloud runtimes, for on-premise runtimes a reset of the runtime is needed.
46 * Using the reset button will empty all runtime related H2 databases. Therefore, the messages in the database will be lost.
Eva Torken 1.1 47
48 == 5. Suggested Additional Readings ==
Danniar Firdausy 13.9 49 If you are interested in this topic and want more information on it please read the following microlearnings:
Danniar Firdausy 13.2 50
Danniar Firdausy 13.6 51 * [[RCA Knowledge Base (Menu)>>doc:Main.eMagiz Support.RCA Knowledge Base.WebHome||target="blank"]]
52 ** [[Runtime Issues (Navigation)>>doc:Main.eMagiz Support.RCA Knowledge Base.rca-knowledgebase-runtime-issues.WebHome||target="blank"]]
Danniar Firdausy 13.7 53 *** [[No Data Delivered to Backend System (Explanation)>>doc:Main.eMagiz Support.RCA Knowledge Base.rca-knowledgebase-runtime-issues.rca-knowledgebase-no-data-in-backend.WebHome||target="blank"]]
Danniar Firdausy 13.3 54 * [[Intermediate (Menu)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.WebHome||target="blank"]]
55 ** [[Solution Architecture (Navigation)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Solution Architecture.WebHome||target="blank"]]
Danniar Firdausy 13.4 56 *** [[H2 Database, Function (Explanation)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Solution Architecture.intermediate-solution-architecture-function-of-h2-database||target="blank"]]
57 ** [[eMagiz Runtime Management (Navigation)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.eMagiz Runtime Management.WebHome||target="blank"]]
58 *** [[Reset Runtime (Explanation)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.eMagiz Runtime Management.intermediate-emagiz-runtime-management-reset-runtime.WebHome||target="blank"]]
Danniar Firdausy 13.2 59 * [[Expert Level (Menu)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.WebHome||target="blank"]]
60 ** [[Solution Architecture (Navigation)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Solution Architecture.WebHome||target="blank"]]
Danniar Firdausy 13.5 61 *** [[H2 Database for other applications>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Solution Architecture.expert-solution-architecture-h2-database-for-other-applications||target="blank"]]
Danniar Firdausy 13.10 62 * [[Reset H2 (Search Results)>>url:https://docs.emagiz.com/bin/view/Main/Search?sort=score&sortOrder=desc&highlight=true&facet=true&r=1&f_space_facet=0%2FMain.&l_space_facet=10&f_type=DOCUMENT&f_locale=en&f_locale=&f_locale=en&text=%22reset+h2%22||target="blank"]]
Danniar Firdausy 13.5 63
64 )))
Eva Torken 1.1 65 (((
66 {{toc/}}
67 )))
68 {{/container}}
69 {{/container}}