Does the isrecovery tool provided within 9.1.2 really work for taking backups along with restore? We tried backup but then it won't restore. Is isrecovery tool something reliably used for backups and restore within datastage?
Thanks,
isrecovery tool backup/restore
Moderators: chulett, rschirm, roy
isrecovery tool backup/restore
Datastage is the best thing that happened to ETL
It appear lot of restores happened(engine,service,DSODB) when it came to projects recovery failed with the error below:
CDIBR2425I Task finished: Load source data from work directory.
CDIBR2424I Task starting: Prepare the DataStage engine for loading projects.
CDIBR2424I Task starting: Create the DSODB database restore scripts.
CDIBR2425I Task finished: Create the DSODB database restore scripts.
CDIBR2424I Task starting: Execute the restore script for the DSODB database.
CDIBR2425I Task finished: Execute the restore script for the DSODB database.
CDIBR2424I Task starting: Update connection properties for DSODB database.
CDIBR2425I Task finished: Update connection properties for DSODB database.
CDIBR2424I Task starting: Update host name in DSODB.
CDIBR2425I Task finished: Update host name in DSODB.
CDIBR2424I Task starting: Recreate the DSODB database schema.
CDIBR2425I Task finished: Recreate the DSODB database schema.
CDIBR2424I Task starting: Upgrade the DSODB database.
CDIBR2425I Task finished: Upgrade the DSODB database.
CDIBR2429I Tasks executing:
Prepare the DataStage engine for loading projects.
CDIBR2429I Tasks executing:
Prepare the DataStage engine for loading projects.
CDIBR2429I Tasks executing:
Prepare the DataStage engine for loading projects.
CDIBD2055E The files for the InfoSphere Information Server engine were not upgraded. The action performed was 'MIGRATE_UVACCOUNT'.
Caused by:
Failed to open table 'UV_TABLES' from the original system.
CDIBR2427I Task has error: Prepare the DataStage engine for loading projects.
CDIBR2078I Recovery finished with errors.
CDIBR2425I Task finished: Load source data from work directory.
CDIBR2424I Task starting: Prepare the DataStage engine for loading projects.
CDIBR2424I Task starting: Create the DSODB database restore scripts.
CDIBR2425I Task finished: Create the DSODB database restore scripts.
CDIBR2424I Task starting: Execute the restore script for the DSODB database.
CDIBR2425I Task finished: Execute the restore script for the DSODB database.
CDIBR2424I Task starting: Update connection properties for DSODB database.
CDIBR2425I Task finished: Update connection properties for DSODB database.
CDIBR2424I Task starting: Update host name in DSODB.
CDIBR2425I Task finished: Update host name in DSODB.
CDIBR2424I Task starting: Recreate the DSODB database schema.
CDIBR2425I Task finished: Recreate the DSODB database schema.
CDIBR2424I Task starting: Upgrade the DSODB database.
CDIBR2425I Task finished: Upgrade the DSODB database.
CDIBR2429I Tasks executing:
Prepare the DataStage engine for loading projects.
CDIBR2429I Tasks executing:
Prepare the DataStage engine for loading projects.
CDIBR2429I Tasks executing:
Prepare the DataStage engine for loading projects.
CDIBD2055E The files for the InfoSphere Information Server engine were not upgraded. The action performed was 'MIGRATE_UVACCOUNT'.
Caused by:
Failed to open table 'UV_TABLES' from the original system.
CDIBR2427I Task has error: Prepare the DataStage engine for loading projects.
CDIBR2078I Recovery finished with errors.
Datastage is the best thing that happened to ETL
Figured from IBM a few things, which makes this tool no more relevant.
1. isrecovery tool is deprecated, it's not there already in 11.3
2.For the use case of us using this before an outage, is recovery tool can't be used. It's more of a disaster recovery tool, expects a clean install to be done first.
I'll close this post as the tool is dead.
1. isrecovery tool is deprecated, it's not there already in 11.3
2.For the use case of us using this before an outage, is recovery tool can't be used. It's more of a disaster recovery tool, expects a clean install to be done first.
I'll close this post as the tool is dead.
Datastage is the best thing that happened to ETL