Montag, 21 of April of 2014

Archives from month » Januar, 2012

General availability (GA) for IBM DB2 products

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

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

 

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:

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


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: