Feb 05 2010
Relationship between Java Stored Procedures and Jar files
1. If you run sqlj.replace_jar do you need to drop/recreate your stored procedure (SP)? 2. If you run sqlj.remove_jar and then sqlj.install_jar do you need to drop/create your SP?
Feb 04 2010
IZ56782: RECURSIVE LOOP IN SQLISCHD(), CAUSED BY SPLIT INDEX PAGE TO AN EMPTY PAGE INCORRECTLY.
We found this problem in a hang issue happened at backward phase of crash recovery.
Feb 04 2010
IC66000: MEMORY LEAK DURING ALTER TABLESPACE MAY LEAD TO SQL0954C, "NOT ENOUGH STORAGE IS AVAILABLE"
If many tables exist within a given tablespace, out of memory errors may be seen when altering some of the tablespace
Feb 04 2010
Unexpected paging space growth using DB2 version 9.1 or higher on AIX
Paging space growth may occur unexpectedly on DB2®/AIX® systems with 64K (medium) pages enabled.
Feb 03 2010
IC66011: CLASS.GETCLASSLOADER() MAY RETURN NULL IN SOME SITUATIONS
JCC is attempting to load a class using the ClassLoader that loaded JCC. JCC gets a handle to this classloader via
Feb 03 2010
IC66012: THE ESTIMATED SIZE OF TABLESPACE LEVEL BACKUP IS CALCULATED FOR THE ENTIRE DATABASE INSTEAD OF THE GIVEN TABLESPACES
2010-01-14-22.01.09.802126-360 E36720A435 LEVEL: Info PID : 2343156 TID : 1 PROC :
Feb 03 2010
IC66013: THE ESTIMATED SIZE OF TABLESPACE LEVEL BACKUP IS CALCULATED FOR THE ENTIRE DATABASE INSTEAD OF THE GIVEN TABLESPACES
2010-01-14-22.01.09.802126-360 E36720A435 LEVEL: Info PID : 2343156 TID : 1 PROC :
Feb 02 2010
PM06366: ABEND 04E RC00E20016 DSNSLD1 DSNSVSTK +0634 LOOP IN DSNSVBK AROUND OFFSET X’1126′
ABEND 04E RC00E20016 DSNSLD1 DSNSVSTK +0634 LOOP IN DSNSVBK around offset x’1126′
Feb 02 2010
PM02957: MULTIPLE FIXES FOR EXPLAIN FOR DSN_QUERY_TABLE AND DSN_PREDICAT_TABLE
Multiple fixes for Explain for DSN_QUERY_TABLE and DSN_PREDICAT_TABLE.
Feb 02 2010
PM03397: INCORRECT OUTPUT NRF WITH KANJI PERCENT % OR UNDERSCORE _ IN LIKE SQLLIKE PREDICATE PATTERN-EXPRESSION, WHEN INDEX PRESENT
DBCS percent sign ‘%’ (x’426C’) or underscore ‘_’ (x’426D’) doesn’t work expectedly when it was put at the end of LIKE