When transporting schemas via a restore if the instance owner does not have permission to bind then no objects are transfered.

Since DB2 V9.7, the user who restores the database by default is not granted with SYSADM and DBA authority after the database is restored. If the user happens to be different from the instance user in the source database, this will cause an issue like this.

The solution is db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES then run the restore again.


DB2 recreating autostorage files.


DB2 Insert Performance – tracking Page Splits

INSERT could be slowed down by latch contention in “Adding Index Key” operations


DB2 10.5 Fixpack 4 Cancun.

Database product installation FAQ update to include Cancun http://www.smooth1.co.uk/installs/dbinstalls.html.

Also Cancun New Features document started http://www.smooth1.co.uk/db2/cancun.html

Database product installation FAQ

Database product installation FAQ http://www.smooth1.co.uk/installs.html

Currently SQL Server,DB2 10.5,Oracle,SAP ASE 16.0,Informix 12.10.FC4

Top Ten Performance Features of DB2 LUW 10.1 and 10.5

Top Ten Performance Features of DB2 1LUW 0.1 and 10.5 – http://www.idug.org/p/bl/et/blogid=19&blogaid=229