If you get a message during the operation of i-effect that a database object is damaged, you can restore the object with the help of these instructions
Symptom
In the system, the following display may appear in the job log or with the system operator:
Message . . . Damage in file ACTION in library IEFFECTDB
has been determined.
Cause ... . The requested operation was not executed for file ACTION in
Library IEFFECT not executed due to a corruption. File ACTION
was either damaged or destroyed.
Troubleshooting: Delete file ACTION and recreate. Afterwards the
Repeat request.
Restore
The following steps are necessary to end i-effect in a controlled manner and restore the damaged object
End i-effect
Setting the following environment variable ensures that the i-effect subsystems do not start automatically during recovery.
ADDENVVAR ENVVAR(IEFFECT_AUTOSTARTSBS) VALUE(*NO) LEVEL(*SYS)
Terminate all i-effect activities with :
ENDEFFSBS SUBSYSTEM(*ALL)
If ZendServer is only used for WebControl, the WebServer can be terminated with
ENDTCPSVR SERVER(*HTTP) HTTPSVR(ZENDPHP7)
ENDSBS SBS(ZENDPHP7)
Stop recording in the journal for the object concerned
ENDJRNPF FILE(IEFFECTDB/AKTION)
JRN(IEFFECT/QSQJRN)
Saving the damaged object
The following commands are used to save the contents of the damaged object
This step will only be successful if the data part of the object is not damaged.
QSH CMD('db2 "create table qgpl.aktion as (select * from ieffectdb.aktion) with data"')
Deleting the damaged object
The object and all dependent object types such as indexes are deleted with:
qsh cmd('db2 "drop table ieffectdb.aktion cascade"')
Restore object from backup
Use this script call to repair the database and recreate the missing object.
/i-effect/v2r8m0/base/tools/scripts/setup.sh --mode repairdb
Copying back data
The following command will restore the backed up data.
This step can only be executed if the backup of the data part as described above was successful.
QSH CMD('db2 "insert into ieffectdb.aktion (select * from qgpl.aktion)"')
Start Zend Services and i-effect
If the web servers have stopped services, they can be restarted with the following command.
STRTCPSVR SERVER(*HTTP) HTTPSVR(ZENDPHP7)
STRSBS SBSD(ZENDPHP7/ZENDPHP7)
Start i-effect
Restart the necessary i-effect subsystems
STREFFSBS SUBSYSTEM(*ALL)
or
STREFFSBS SUBSYSTEM(*AS2 *EMAIL *EDI *SERVER ...)
Enable automatic startup of the subsystems
When the environment variable is removed, the subsystems are started again automatically if required.
RMVENVVAR ENVVAR(IEFFECT_AUTOSTARTSBS) LEVEL(*SYS)