Archive for February 2nd, 2010

Feb 02 2010

PM06366: ABEND 04E RC00E20016 DSNSLD1 DSNSVSTK +0634 LOOP IN DSNSVBK AROUND OFFSET X’1126′

Published by db2dba under Z/OS Support

ABEND 04E RC00E20016 DSNSLD1 DSNSVSTK +0634 LOOP IN DSNSVBK around offset x’1126′

No responses yet

Feb 02 2010

PM02957: MULTIPLE FIXES FOR EXPLAIN FOR DSN_QUERY_TABLE AND DSN_PREDICAT_TABLE

Published by db2dba under Z/OS Support

Multiple fixes for Explain for DSN_QUERY_TABLE and DSN_PREDICAT_TABLE.

No responses yet

Feb 02 2010

PM03397: INCORRECT OUTPUT NRF WITH KANJI PERCENT % OR UNDERSCORE _ IN LIKE SQLLIKE PREDICATE PATTERN-EXPRESSION, WHEN INDEX PRESENT

Published by db2dba under Z/OS Support

DBCS percent sign ‘%’ (x’426C’) or underscore ‘_’ (x’426D’) doesn’t work expectedly when it was put at the end of LIKE

No responses yet

Feb 02 2010

PM02674: ABEND04E RC00C90101 IN DSNKINSL ERQUAL5004

Published by db2dba under Z/OS Support

ABEND 04E 00C90101 can occur in DSNKINSL ERQUAL 5004 with LOCKSIZE PAGE and the table has a UNIQUE WHERE NOT NULL index.

No responses yet

Feb 02 2010

PM02966: COBOL STORED PROCEDURE ABEND0C4-4 IN DSNX9WLJ

Published by db2dba under Z/OS Support

COBOL SP abend0C4-04 in DSNX9WLJ because local variable in DSNX9WLS was not initialized.

No responses yet

Feb 02 2010

IZ54868: XML EXTENDER ERROR: "STORED PROCEDURE RETURNED SQLCODE: -57, DXXG006E INTERNAL ERROR … CLI0112E ERROR IN ASSIGNMENT"

Published by db2dba under IBM DB2 Linux

Using the XML Extender, you get error CLI0112E when you decompose into a column of data type CHAR FOR BIT DATA.

No responses yet

Feb 02 2010

IC65839: DB2 CAN TRAP IN SQLRIGETNEXTINPUTDATAVALUE() WITH EVENT MONITORS ACTIVE

Published by db2dba under IBM DB2 Linux

With activated event monitors DB2 might trap with following stack:

No responses yet

Feb 02 2010

IC65677: DB2 CONTROL CENTER IS HANG ON ‘SELECT SCHEMA’ OF ‘ADD TABLE’ TO A USER IN ‘USER AND GROUP OBJECTS’ VIEW.

Published by db2dba under IBM DB2 Linux

ERROR DESCRIPTION: In 61558,101,616, When trying to add a table to a user, the Add

No responses yet