Db2 Version,Release,Modpacks,Fixpacks and Interim Fixes
Posted: December 30, 2017 Filed under: DB2, DB2 LUW, Uncategorized | Tags: DB2, DB2 LUW Leave a comment11.1.2.3 iFix001
11 (Version) seperatedly licensed, major feature changes,starts 5 year maintenance clock,download from Passport Advantage
1 (Release) Minor but significant feature changes,starts 5 year maintenance clock,download from Passport Advantage
2 (Modpack) Can include new functionality,does not start new maintenance clock, download from Fix Central
3 (Fixpack) Cumulative update of all available fixes and APARs,does not start new maintenance clock,download from Fix Central
iFix001 (iFix – Interim Fix) Tested and verified set of small number of key fixes and APARs,cumulative,Downloads found on Fix Central,Supported for the maintenance life of the Version.Release.
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 LUW Setting up Shadow Tables
Posted: November 16, 2016 Filed under: DB2 10.5, DB2 LUW, Shadow Tables | Tags: DB2 LUW, Shadow Tables Leave a commentJust heard someone at IDUG EMEA 2016 asking about how to setup DB2 LUW shadow tables.
This will depend upon DB2 Version,you also need a compatible CDC (Infosphere Replication) version,check via Finding System Requirements for IBM Software Products.
The steps are at http://www.smooth1.co.uk/db2/cancun.html#1.1
NOTE: This was written when the feature first came out DB2 LUW 10.5 FP4.
CDC Components to download were:
- InfoSphere CDC for DB2 for LUW
- InfoSphere CDC Access Server
- InfoSphere CDC Management Console
Finding System Requirements for IBM Software Products.
Posted: November 14, 2016 Filed under: DB2 LUW, Informix | Tags: DB2 LUW, Informix Leave a commentIBM has a Software Product Compatibility Reports facility.
http://www-969.ibm.com/software/reports/compatibility/clarity/softwareReqsForProduct.html
DB2 LUW 11.1
Posted: April 26, 2016 Filed under: DB2 11.1, DB2 LUW, Uncategorized | Tags: DB2 LUW Leave a commentDB2 11.1 has been announced with a download date of June 15 2016
Potential new features are:
Core workloads
Enterprise Encryption supports Centralized Key Managers (KMIP)
Support for Encryption to use KMIP 1.1 with a Centralized Key Manager
– update dbm cfg using keystore_type kmip
– update dbm cfg using keystore location /home/justdave/isklm.cfg
Config file contains host, port number etc.
Technology Preview of support for Hardware Security Modules
Simpler Deployment
Greater Availability
Zero Data Loss HADR
More online management
More platforms supported
Power Linux (LE) supported
Virtualization for RDMA (x86) supported
Very Large Database Performance
Faster throughput
Better upgrades
DB2 9.7 and higher can be directly upgraded to DB2 11.1 (support for upgrades from 3 releases back)
Online upgrades with no need for an offline backup.
A recovery procedure including roll-forward thtough a database upgrade exists. This does not include DPF and requires upgrading from DB2 10.5 FP7 or higher.
Steamlined HADR upgrade
HADR environments can be upgraded with need to re-initialized the secondary. This does not apply to Purescale and requires upgrading from DB2 10.5 FP7 or higher.
Warehousing workloads
MPP supports BLU
DPF renamed to MPP
Faster ELT/ETL Performance
More Query Workloads Optimized
More functions supported
Generated Columns
RCAC
OLAP+BLU Performance increased
Multi-Lingual SQL Advances
Postgres syntax
Support for European Languages
Codepage 819
DB2 10.5 Fixpack 6 is out
Posted: August 27, 2015 Filed under: DB2 10.5, DB2 LUW | Tags: DB2 10.5, DB2 LUW Leave a commentDB2 10.5 Fixpack 6 is out
http://www-01.ibm.com/support/docview.wss?uid=swg24040522
“Fix Pack 6 does not contain new enhancements, and there were no changes to the existing functionality. This fix pack and future fix packs will deliver only APAR and security vulnerability fixes.”
Managing GSKit Master Keys
Posted: May 2, 2015 Filed under: DB2 LUW, Informix | Tags: DB2 LUW, Informix Leave a commenthttp://www.ibm.com/developerworks/data/library/techarticle/dm-1504-master-encrypted-keys/index.html
Managing GSKit Master Keys
How do you enable a JDBC trace for a Java Stored Procedure or Java UDF?
Posted: April 30, 2015 Filed under: DB2 LUW | Tags: DB2 LUW Leave a commentHow do you enable a JDBC trace for a Java Stored Procedure or Java UDF?
Question
How do you enable a JDBC trace for a Java Stored Procedure or Java UDF?
Answer
Issue the following command on the database server:
db2set DB2_JVM_STARTARGS=”-Ddb2.jcc.override.traceLevel=-1 -Ddb2.jcc.override.traceFile=/tmp/jdbc_trace -Ddb2.jcc.override.traceFileAppend=true”
… where /tmp/jdbc_trace can be any path/file name that has write privilege by the DB2 fenced user id.
If the database manager configuration parameter KEEPFENCED is set to YES, then this command will require the DB2 instance to be recycled:
db2stop
db2start
To remove this parameter issue the command:
db2set DB2_JVM_STARTARGS=
… and then restart the DB2 instance again (assuming KEEPFENCED=YES is used).
Binding DB2 Base Packages for Various Versions
Posted: April 29, 2015 Filed under: DB2 LUW | Tags: DB2 LUW Leave a commentBinding DB2 Base Packages for Various Versions
DB2 10.5 Fixpack 4 Cancun New Features
Posted: November 9, 2014 Filed under: DB2 10.5, DB2 LUW Leave a commentDatabase product installation FAQ update to include Cancun http://www.smooth1.co.uk/installs/dbinstalls.html.
Also Cancun New Features document WIP http://www.smooth1.co.uk/db2/cancun.html
just dave info 