www.ruban.de – DB2 experts web site: General availability (GA) for IBM DB2 products General Availability (GA) of IBM DB2 software products: (link to annoucement if available): 26.03.2004: DB2 for z/OS V8 16.03.2007: DB2 for z/OS V9.1 22.10.2010: DB2 for z/OS V10.1 31.10.2007: DB2 for LUW V9.5 19.06.2009: DB2 for LUW V9.7 08.03.2012: » www.ruban.de

General availability (GA) for IBM DB2 products

General Availability (GA) of IBM DB2 software products: (link to annoucement if available):

26.03.2004: DB2 for z/OS V8
16.03.2007: DB2 for z/OS V9.1
22.10.2010: DB2 for z/OS V10.1
31.10.2007: DB2 for LUW V9.5
19.06.2009: DB2 for LUW V9.7
08.03.2012: DB2 11 for z/OS (ESP)

IBM’s official web pages:

See also post ”End of Service dates for IBM DB2 products”.

End of service (EOS) date for DB2 products

End of Service dates for IBM DB2 products:

30.06.2008: DB2 for OS/390 V7
30.09.2009: DB2 LUW V8.x EoS
30.04.2012: DB2 LUW V9.1 EoS
30.04.2012: DB2 for z/OS V8
30.04.2013: DB2 LUW V9.5 EoS
27.06.2014: DB2 for z/OS V9
30.09.2014: DB2 LUW V9.7 EoS

IBM’s official web pages:

Seee also post “General Availability of DB2 products”.

NLS and unicode support

Understanding DB2 Universal Database character conversion (IBM, PDF)

DB2 UDB National Language Support for the Command Line Processor and Utilities (IBM,PDF)

When code page conversion occurs (DB2 V9.7 Info Center)

Supported territory codes and code pages (DB2 V9.7 Info Center)

Ermittlung der Codepage-Einstellungen mit dem DB2 Command “db2 -a connect to ….”.

FOR BIT DATA werden wie Daten mit Codepage=0 verschlüsselt verarbeitet.

Beachte: The IBM DB2 Driver for JDBC and SQLJ returns data from a ResultSet.getString call for a CHAR FOR BIT DATA or VARCHAR FOR BIT DATA column as a lowercase hexadecimal string.

Displaying/selecting [VAR]CHAR FOR BIT DATA table columns:

SELECT CAST(COL_FOR_BIT_DATA AS [VAR]CHAR(nn) FOR SBCS DATA)  
FROM YOURTABLE</span>

1 2	SELECT CAST(COL_FOR_BIT_DATA AS [VAR]CHAR(nn) FOR SBCS DATA) FROM YOURTABLE</span>

What ist the codepage of a table column – querying the DB2 catalog:
(FOR BIT DATA columns are shown with CODEPAGE=0)

SELECT COLNAME, TYPENAME,  CODEPAGE FROM SYSCAT.COLUMNS
WHERE TABNAME = 'YOURTABLE'

1 2	SELECT COLNAME, TYPENAME, CODEPAGE FROM SYSCAT.COLUMNS WHERE TABNAME = 'YOURTABLE'

Unicode Standards: www.unicode.org
Unicode Standard: A Technical Introduction
Introduction to Unicode (ICU User Guide) (Source Forge Net)
Unicode Support speziell für DB2 z/OS Version 8:
All for One and One for All – Introducing Unicode, Part 1 and Part 2 (Quelle: IBM UK)
DB2 UDB for z/OS Internationalization Guide (IBM, FTP, PDF)
II13049: SUPPORT FOR UNICODE: STEPS FOR INSTALLING AND CUSTOMIZING (PART 2)
II13048: SUPPORT FOR UNICODE: STEPS FOR INSTALLING AND CUSTOMIZING (PART 1)
The secret life of Unicode (IBM)
Understanding DB2 Universal Database character conversion (IBM, PDF)
DB2 UDB National Language Support for the Command Line Processor and Utilities (IBM)

Overview relational und object-oriented database systems

Overview relational and object-oriented database systems
relationale database system with OO extensions
manufacturer	product	supported platforms	link
IBM	DB2 Universal Database	AIX, HP-UX, Linux, (0S/2), (OS/390), Sun/Solaris, Windows, z/OS	http://www.ibm.com/software/db2/data
Oracle	Oracle	AIX, Linux, (OS/390), True64, Sun/Solaris, Windows, z/OS	http://www.oracle.de
Sybase	Adaptive Server	AIX, HP-UX, Irix, Linux, Sun/Solaris, True64, Windows	http://www.sybase.de
Borland	Interbase	Linux, Sun/Solaris, Windows	http://www.interbase.com
CA Computer Associates	Ingres/OpenROAD	Unix, OpenVMS, Linux, WIndows	http://www.ca.com
Microsoft	SQL Server	Windows NT/2000/XP	http://www.microsoft.de
object-oriented database systems
manufacturer	product	supported platforms	link
CA Computer Associates	Jasmine	on request	http://www.ca.com
Object Design	ObjectStore	AIX, HP-UX, Irix, True64, Sun/Solaris, Windows	http://www.objectstore.com
Versant	Versant VDS	AIX, HP-UX, Irix, Sun/Solaris, Linux, Windows	http://www.versant.de
post-relationale database systems
manufacturer	products	supported platforms	link
InterSystems	Caché	Win 95/95/ME/NT/2000/XP, Linux, Compaq OpenVMS, Linux, AIX, HP-UX, True64, Sun/Solaris	http://www.intersystems.de
Poet Software	FastObjects	HP-UX, Linux, Sun/Solaris, Windows	http://www.fastobjects.de
Mapping Tools
manufacturer	products	supported platforms	link
Thought	CocoBase Enterprise O/R	n/a	http://www.thoughtinc.com
Poet Software	FastObjects SQL Object Factory	Win 2000/NT/XP/ME, Sun/Solaris	http://www.fastobjects.de
Sun Microsystems	Jaba Blend	n/a	http://www.sun.de
Software Tree	JDX	n/a	http://www.softwaretree.com
ONTOS	ObjectSpark	n/a	http://www.objectspark.com
Rogue Wave Software	SourcePro DB	AIX, AS/400, Windows, Sun/Solaris, HP-UX, (OS/390), True64, Red Hat Linux, z/OS	http://www.roguewave.com

This table requires a revision.

Installing a license for DB2 Connect Personal Edition V9.7

Launching the installation of DB2 Connect Personal Edition opens the product selection list but only the IBM Data Server Client is in the list. The DB2 Connect Personal Edition product is not presented as an option.

IBM Data Server Client and DB2 Connect Personal Edition are the same product and use the same . To activate the DB2 Connect Personal Edition capabilities the only requirement is to apply the DB2 Connect Personal Edition license after installing the IBM Data Server Client.

Links to IBM Sources:

IBM’s tools and sources for trouble-shooting access-path related problems

Do you search for tools and “how-to” solve access-path related problems. Here are some interesting links:

Troubleshooting access-path-related performance problems
Covers deployment of DB2PLI8 program (for DB2 Version 8 and DB2 9).
Sending a SQL query to IBM support

www.ruban.de – DB2 experts web site

Search

DB2 forum

Topics

Archive

Ads

Archives from month » Januar, 2012