Restore a damaged i-effect database (PF-DTA) object

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:

CODE

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.

CODE

ADDENVVAR ENVVAR(IEFFECT_AUTOSTARTSBS) VALUE(*NO) LEVEL(*SYS)

Terminate all i-effect activities with :

CODE

ENDEFFSBS SUBSYSTEM(*ALL)

If ZendServer is only used for WebControl, the WebServer can be terminated with

CODE

ENDTCPSVR SERVER(*HTTP) HTTPSVR(ZENDPHP7) 
ENDSBS SBS(ZENDPHP7)

Stop recording in the journal for the object concerned

CODE

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.

CODE

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:

CODE

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.

CODE

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

CODE

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.

CODE

STRTCPSVR SERVER(*HTTP) HTTPSVR(ZENDPHP7) 
STRSBS SBSD(ZENDPHP7/ZENDPHP7)

Start i-effect

Restart the necessary i-effect subsystems

CODE

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.

CODE

RMVENVVAR ENVVAR(IEFFECT_AUTOSTARTSBS) LEVEL(*SYS)