|
Problem IC94025
|
Status: Closed |
BINDING DB2UCKTB.BND AGAINST LOWER RELEASE DB2 LUW DATABASE THROWS ERROR. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Binding db2ucktb.bnd from DB2 LUW 10.5 client to DB2 LUW 9.5 or
9.7 databases throws error as below. (Note that db2ucktb.bnd is
listed in db2ubind.lst file, therefore binding the db2ubind.lst
file will also hit the issue.)
db2 bind sqllib/bnd/db2ucktb.bnd BLOCKING ALL GRANT PUBLIC
LINE MESSAGES FOR db2ucktb.bnd
------
----------------------------------------------------------------
----
SQL0061W The binder is in progress.
666 SQL0104N An unexpected token "TEMPORAL" was found
following
"VALUES (CURRENT ". Expected tokens may
include: "CONCAT".
SQLSTATE=42601
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous
errors.
SQL0091N Binding was ended with "3" errors and "0"
warnings.
Explanation: The statement that causes the above error is valid
and needed for DB2 LUW 10.5 databases, and is not run against
DB2 LUW 9.5 or 9.7 databases, but it still causes the whole bind
operation to fail. Adding the SQLERROR CONTINUE bind option
will allow the bind operation to complete successfully, with the
statement giving a warning (no longer an error) that can be
safely ignored.
The fix for this APAR is to make the bind operation for
db2ucktb.bnd to use the SQLERROR CONTINUE option implicitly
(i.e. even when the option is not specified), thus the bind will
complete successfully.
Note: Similar issue may exist when binding db2ucktb.bnd against
DB2 non-LUW (host) databases. The same fix applies (if the
issue exists). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW Version 10.5 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
Use SQLERROR CONTINUE option to bind db2ucktb.bnd against DB2
LUW 9.5 or 9.7 servers. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 LUW Version 10.5 Fix Pack 3. |
| Workaround |
Use SQLERROR CONTINUE option to bind db2ucktb.bnd against DB2
LUW 9.5 or 9.7 servers. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.07.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
