The CLI driver
contains a number of major enhancements for Version 10.1.
Review the technical changes and new functionality that are
included in the following Version 10.1 fix packs. Each fix pack for
a release is cumulative: it contains all the technical changes and
new functionality that were included in previous fix packs for that
release.
FP2:
Enhancements to the DB2 interactive CLI command
(db2cli)
Version 10.1 Fix Pack 2 and later fix packs include
the following enhancements to the
db2cli command:
FP2: Support for testing database
connectivity with the IBM Data
Server Driver Package software and the db2dsdriver.cfg file
In
Version 10.1 Fix Pack 2 and later fix packs, the
IBM® Data
Server Driver Package software can test database connectivity:
FP2:
Support for the special characters in a password
In Version
10.1 Fix Pack 2 and later fix packs, the CLI driver
accepts special characters in the password, with some exceptions.
See Password rules for
drivers and CLPPlus.
FP2: New attributes
Version
10.1 Fix Pack 2 and later fix packs include the following new attributes:
- You can set the SQL_FREE_MEMORY_ON_STMTCLOSE_YES and SQL_FREE_MEMORY_ON_STMTCLOSE_NO
attributes at the statement and connection level to free memory on
the client when you specify the SQL_CLOSE action.
See Connection attributes
(CLI)
list.
- You can set the SQL_ATTR_DBC_SYS_NAMING_YES and SQL_ATTR_DBC_SYS_NAMING_NO
connection attributes to enable and disable the SQL naming mode on
the DB2 for i server.
See Connection attributes
(CLI)
list.
- You can set the SQL_ATTR_DB2TRC_STARTUP_SIZE environment attribute
to specify the DB2 trace buffer
size on all platforms. See Environment attributes
(CLI)
list.
FP2: Enhancements to the db2dsdriver.cfg
file
Version 10.1 Fix Pack 2 and later fix packs include
the following enhancements to the
db2dsdriver.cfg file:
FP1: Enhancements
to the DB2 interactive CLI command
(db2cli) (Windows)
Version
10.1 Fix Pack 1 and later fix packs include the following enhancements
to the
db2cli command:
- You can issue the db2cli validate command to
obtain a complete list of IBM data server client packages
that are installed on a Windows operating
system. When you issue the command on a Windows operating system, the db2cli command
reports all duplicate and conflicting settings for the same property
in the same DSN, database, or global section of the db2dsdriver.cfg file.
- You can issue the db2cli validate command to
check duplicate or conflicting keyword entries in the same section
of the db2dsdriver.cfg file.
- On Windows operating
systems, new options are added to the registerdsn parameter
for the db2cli command:
- The db2cli registerdsn -remove command include
the following new options:
- -alldsn
- -copyname copy_name
- -allcopies
- -force
- -dsn
- The db2cli registerdsn -add command includes
the new -dsn option.
- The db2cli registerdsn -list command includes
the following new options:
- -copyname copy_name
- -allcopies
See db2cli - DB2 interactive CLI command .
FP1: Support for DB2 for i servers
has been further enhanced
In Version 10.1 Fix Pack 1 and
later fix packs,
CLI applications
support the following features in
DB2 for i servers:
FP1: SQL_ATTR_NETWORK_STATISTICS
attribute support has been further enhanced
In Version 10.1
Fix Pack 1 and later fix packs, you can obtain the server time for
COMMIT or ROLLBACK SQL operations on DB2 for z/OS® Version
10 and later. SeeConnection attributes (CLI)
list.
FP1: New LDAP keywords for
the db2dsdriver.cfg file
In Version
10.1 Fix Pack 1 and later fix packs, the following new keywords are
added to the
db2dsdriver.cfg for the LDAP support:
- EnableLDAP
- LDAPServerHost
- LDAPServerport
- ClientProvider
- BaseDN
- UserID
- Password
See
IBM Data
Server Driver configuration keywords.
FP1: Prefetched cursor support
for seamless automatic client reroute