Symptom
You want to move table data online using the stored procedure ADMIN_MOVE_TABLE.
Other terms
online table move stored procedure, DB2 LUW
Reason and Prerequisites
You are using DB2 9.7 GA and you would like to move table data online.For DB2 9.7 GA, the stored procedure ADMIN_MOVE_TABLEmust notbe used.There is a known problem which will be corrected in DB2 [...]
Symptom
Transaction log files of a DB2 system are accidentally lost and you need to make the database accessible to export important data.
Other terms
transaction logfiles db2reset online backup
Reason and Prerequisites
Transaction log files are the backbone of a relational database system. As soon as a log file is lost, database consistency can no longer be [...]
Symptom
Upgrade or deployment of a NetWeaver 6.40 or 7.0 system fails with the following error message:
Caught exception during application deployment from SAP J2EE Engine’s deploy service:
java.rmi.RemoteException: Error occurred while deploying ear file. .
Reason: None of the available containers recognized the components of application ; it is not possible to make deploy.
Other terms
deploy, upgrade, online, [...]
Symptom
You want to move tables online between tablespaces using the stored procedure ONLINE_TABLE_MOVE.
Other terms
online table move stored procedure
Reason and Prerequisites
For Linux and UNIX only: You are using DB2 Version 8.2.2 or higherFor Windows only: You are using DB2 Version 9.1 or higherDB2 registry variable DB2_SKIPDELETEDmustbe set to OFF.The SYSTOOLSPACE tablespace must be accessible for ‘PUBLIC’.
To [...]