Restore i-effect
Restore the license program 2MEBEFF
If i-effect® is to be reset to a status BEFORE installing an update or upgrade, this manual contains the necessary processing steps. Since the automated installation of i-effect performs an automatic rollback when the installation is aborted, the procedure described here should only be used if the automatic restore in the installation program fails or if you want to switch to a previous version.
Before starting a restore, the installed i-effect® version must be uninstalled or deleted cleanly, otherwise the libraries and IFS directories will be partially overwritten and a corrupt installation could be the result.
Restoring from the automatic installation backup
The automatic installation creates a backup of the following objects before an update or upgrade:
Libraries (names may differ for personalized installation)
IEFFECT
IEFFECTDB
IEFFECTSYS
IFS directories
/home/ieffect/
/i-effect/VxRxMx
A backup can be restored from these objects.
Restore to the state BEFORE the last installation
With the help of the following script call, the installation can be reset to the status BEFORE the last installation, the installation objects must still be present in /tmp/2mebeff, or a new ISO must be unpacked there (see below).
/tmp/2mebeff/scripts/restore2mebeff.sh -t *lastThe *LAST option indicates that the last backup created is to be used.
The backups are identified with a sequential number. The backup entry with the highest sequential number represents the last backup made.
The backups made can be viewed in the IEFFSAVE library. The version status and date of the backup can be read from the object description.
Object | Type | Attribut | Text | Description |
|---|---|---|---|---|
APP | *FILE | SAVF | APP 2.8.3 Wed Sep 02,2020 17:25:26 | Backup of the application schema BEFORE the last installation |
APP0 | *FILE | SAVF | APP 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the application schema BEFORE the penultimate installation |
DB | *FILE | SAVF | DB 2.8.3 Wed Sep 02,2020 17:25:26 | Backup of the database schema BEFORE the last installation |
DB0 | *FILE | SAVF | DB 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the database schema BEFORE the penultimate installation |
ENV | *FILE | PF-DTA | ENV 2.8.3 Wed Sep 02,2020 17:25:26 | Backup of the environment variables BEFORE the last installation |
ENV0 | *FILE | PF_DTA | ENV 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the environment variables BEFORE the penultimate installation |
IFS | *FILE | SAVF | IFS 2.8.3 Wed Sep 02,2020 17:25:26 | Backup the IFS directories BEFORE the last installation |
IFS0 | *FILE | SAVF | IFS 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the IFS directories BEFORE the penultimate installation |
LNG | *FILE | SAVF | LNG 2.8.1 Wed Sep 02,2020 17:25:26 | Backup of the secondary language library BEFORE the penultimate installation |
LNG0 | *FILE | SAVF | LNG 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the secondary language library BEFORE the penultimate installation |
SYS | *FILE | SAVF | SYS 2.8.3 Wed Sep 02,2020 17:25:26 | Backup of the sysbasema BEFORE the last installation |
SYS0 | *FILE | SAVF | SYS 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the sysbasema BEFORE the penultimate installation |
VRM | *FILE | PF-DTA | VRM 2.8.3 Wed Sep 02,2020 17:25:26 | Backup of the version setting BEFORE the last installation |
VRM0 | *FILE | PF-DTA | VRM 2.8.1 Wed Aug 28,2020 14:35:12 | Index 0: Backup of the version setting BEFORE the penultimate installation |
Deploy script
The recovery is performed with the latest version of a script that must be provided beforehand:
Extract the subfolder 2MEBEFF from the ISO of i-effect and copy the folder to /tmp on your IBM i system.
The script is then called with this path.
Reset to the backup with the index "1"
After entering the following command in a QSH session, the desired status (different from *last) is restored:
/tmp/2mebeff/scripts/restore2mebeff.sh -t 1Customization for i-effect® 2.7
If a version 2.7 was restored with this restore, the following adjustment must be made manually
CHGUSRPRF USRPRF(IEFFECT) JOBD(IEFFECTSYS/IEFFECTD) GRPPRF(*NONE)Protocol
The following messages appear on the console during a restore:
/i-effect/v2r8m0/base/tools/scripts/restore2mebeff.sh -t *last
Check access rights...
Check for existing backup files...
Read backup environment settings...
Restoring into:
Home directory:/home/ieffect
Application schema:IEFFECT28 in catalog:K009777T on device:*SYSBAS
System schema:IEFFECTS28
Database schema:IEFFECTDB in catalog:K009777T on device:*SYSBAS
IFS directory:/i-effect/V2R8M0
Check locks....
Starting restore...
Removing journals...
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
Removing current schema IEFFECT28...
Removing current schema IEFFECTS28...
Removing current schema IEFFECTDB...
Restoring IEFFECT28 from IEFFSAVE/APPSCHEMA on device *SYSBAS...
CPC3703: 1212 Objekt(e) von IEFFECT28 nach IEFFECT28 zurückgespeichert.
Restoring IEFFECTS28 from IEFFSAVE/SYSSCHEMA on device *SYSBAS...
CPC3703: 162 Objekt(e) von IEFFECTS28 nach IEFFECTS28 zurückgespeichert
Restoring IEFFECTDB from IEFFSAVE/DBSCHEMA on device *SYSBAS...
CPC3703: 355 Objekt(e) von IEFFECTDB nach IEFFECTDB zurückgespeichert.
Restoring IFS directories /i-effect/V2R8M0 and /home/ieffect
CPC370F: 2713 Objekte zurückgespeichert.
CPCA082: Objekt kopiert.
Repairing DB...
*** ***
*** Setting up i-effect with the following settings ***
Current running version: V2R8M0
Current APP device: *SYSBAS
Current APP catalog: K009777T
Current APP schema: IEFFECT28
Current APP schema path: /QSYS.LIB/IEFFECT28.LIB
Current IFS device: *SYSBAS
Current IFS path: /i-effect/V2R8M0
Current DB device: *SYSBAS
Current DB catalog: K009777T
Current DB schema: IEFFECTDB
Current DB schema path: /QSYS.LIB/IEFFECTDB.LIB
Current LNG device: *SYSBAS
Current LNG schema: *NONE
Current URL: jdbc:as400://localhost/IEFFECTDB
TARGET APP device: *SYSBAS
TARGET APP catalog: K009777T
TARGET APP schema: IEFFECT28
TARGET APP schema path: /QSYS.LIB/IEFFECT28.LIB
TARGET IFS device: *SYSBAS
TARGET IFS path: /i-effect/V2R8M0
TARGET DB device: *SYSBAS
TARGET DB catalog: K009777T
TARGET DB schema: IEFFECTDB
TARGET DB schema path: /QSYS.LIB/IEFFECTDB.LIB
TARGET LNG device: *SYSBAS
TARGET LNG schema: *NONE
TARGET URL: jdbc:as400://localhost/IEFFECTDB
Mode: REPAIRDB
Source: *ALL
Creating temporary database IEFFTMPDB.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
Updating the database with /i-effect/V2R8M0 jdbc:as400://localhost/IEFFTMPDB IEFFECT28 IEFFTMPDB /i-effect/V2R8M0/BASE/database/changesets/master.xml
Checking differences between IEFFECTDB and IEFFTMPDB.
Diffing the database with /i-effect/V2R8M0 jdbc:as400://localhost/IEFFECTDB IEFFECT28 IEFFECTDB jdbc:as400://localhost/IEFFTMPDB /tmp/IEFFECTDB_IEFFTMPDB.diff.xml
Applying difference to IEFFECTDB.
Updating the database with /i-effect/V2R8M0 jdbc:as400://localhost/IEFFECTDB IEFFECT28 IEFFECTDB /tmp/IEFFECTDB_IEFFTMPDB.diff.xml
Applying current changeset to IEFFECTDB.
Recreating functions & procedures...
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
DB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.
Updating the database with /i-effect/V2R8M0 jdbc:as400://localhost/IEFFECTDB IEFFECT28 IEFFECTDB /i-effect/V2R8M0/BASE/database/c
hangesets/master.xml
***************************************************************************************
*** Nothing changed.
*** Repaired:
TARGET DB device: *SYSBAS
TARGET DB catalog: K009777T
TARGET DB schema: IEFFECTDB
TARGET DB schema path: /QSYS.LIB/IEFFECTDB.LIB
TARGET URL: jdbc:as400://localhost/IEFFECTDB
***************************************************************************************
Checking product installation...
Restore finished successfully The log file /tmp/YYYYMMDD-restore.log contains the extended log for this restore.