DB2 LUW announcements at IDUG NA 2017
Posted: May 3, 2017 Filed under: DB2 10, DB2 11.1, DB2 9.7, DB2 LUW | Tags: DB2 10, DB2 11.1, DB2 9.7, DB2 LUW Leave a commentFrom Peter Bradford @scend we have:
#1 We made requests for enhancements (RFEs) public!
#2: DB2 Developer-C! All DB2 features, free for development, a MySQL substitute! Download 6/22
#3: The new “Download & Go” installation experience, available with Developer-C Download 6/2. Download a platform specific binary. Small download, less than 15 minutes to install. Install reduced to 3 clicks and User/Password input only.
#4: We will support DB2 V11 on Solaris Sparc later this year with our V11.1.3.3 release, by 12/15/17 (if not sooner)
#5: New “Continuous Support” offering for customers on DB2 V9.7 and V10.1!
How To and Workaround assistance, no new defect fixes
This still provides existing fixed but no new custom special builds or codes fixed
If you have questions contact
Email: askcs@us.ibm.com
Twitter: @db2support or https://twitter.com/db2_support
DB2 transport schemas with DB2_RESTORE_GRANT_ADMIN_AUTHORITIES
Posted: October 5, 2014 Filed under: DB2 10, DB2 10.5, DB2 LUW Leave a commentWhen 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.
Posted: October 5, 2014 Filed under: DB2 10, DB2 10.5, DB2 LUW Leave a commenthttp://www-01.ibm.com/support/docview.wss?uid=swg21682091&myns=swgimgmt&mynp=OCSSEPGG&mync=E
DB2 Insert Performance – tracking Page Splits
Posted: October 5, 2014 Filed under: DB2 10, DB2 10.5, DB2 LUW Leave a commentINSERT 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
DB2 10.5 Fixpack 4 Cancun.
Posted: August 30, 2014 Filed under: DB2 10, DB2 10.5, DB2 LUW | Tags: DB2 10.5 Leave a commentDatabase 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
Posted: August 20, 2014 Filed under: DB2 10, DB2 LUW, Informix 12, Microsoft SQL Server, Microsoft SQL Server 2014, Oracle 12c, SAP Sybase ASE | Tags: DB2 10.5, DB2 LUW, Informix, Informix 12, Microsoft SQL Server, Microsoft SQL Server 2014, Oracle 12c, SAP Sybase ASE Leave a commentDatabase product installation FAQ http://www.smooth1.co.uk/installs.html
Currently SQL Server,DB2 10.5,Oracle 12.1.0.2,SAP ASE 16.0,Informix 12.10.FC4
Top Ten Performance Features of DB2 LUW 10.1 and 10.5
Posted: February 25, 2014 Filed under: DB2 10 Leave a commentTop Ten Performance Features of DB2 1LUW 0.1 and 10.5 – http://www.idug.org/p/bl/et/blogid=19&blogaid=229
just dave info 