DB2 transport schemas with DB2_RESTORE_GRANT_ADMIN_AUTHORITIES

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.

http://www-01.ibm.com/support/docview.wss?uid=swg21685941&myns=swgimgmt&mynp=OCSSEPGG&mync=E


DB2 recreating autostorage files.

http://www-01.ibm.com/support/docview.wss?uid=swg21682091&myns=swgimgmt&mynp=OCSSEPGG&mync=E


DB2 Insert Performance – tracking Page Splits

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

http://www-01.ibm.com/support/docview.wss?uid=swg21681439&myns=swgimgmt&mynp=OCSSEPGG&mync=E


SAP Sybase TechSelect agenda.

SAP Sybase TechSelect agenda has been put up – http://uksug.com/sites/default/files/uploads/2014_techselect_invite_upload.pdf


SQL Server 2008 SP4 and 2008 R2 SP3

SQL Server 2008 R2 SP3 and SQL Server 2008 SP4 are now available!

http://blogs.technet.com/b/dataplatforminsider/archive/2014/10/01/sql-server-2008-r2-sp3-and-sql-server-2008-sp4-are-now-available.aspx

How to obtain the latest service pack for SQL Server 2008 http://support2.microsoft.com/kb/968382

How to obtain the latest service pack for SQL Server 2008 R2 http://support.microsoft.com/kb/2527041

NOTE: Both 2008 R2 SP3 and 2008 SP4 contain the fix for “MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014” http://support2.microsoft.com/kb/2984340.