|
Problem IC96421
|
Status: Closed |
SQL0440N ON SYSIBM BUILT IN FUNCTIONS AFTER RESTORE REPLACE EXISTING OF A DATABASE ONTO A PREVIOUS RELEASE FIX PACK |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
After restoring a backup made on a higher fix pack level onto a
lower level fix pack, SQL0440N will be raised on calling a
sysibm qualified routine such as sysibm.rtrim() :
1. create sample database on v97fp8
2. backup database
3. restore database on v97fp6
4. connect to db
5. db2 "values(sysibm.rtrim('hello'))" ---> fails with SQL0440N
This error will persist throughout first activation of the
database. Once the database is deactivated and reactivated, the
error will no longer be raised. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All restoring over a previous version fixpack *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 10.5 FP3 *
**************************************************************** |
| Local Fix: |
|
| 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 |
First fixed in version 10.5 FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.09.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
|
|
