SE26727 - OSP-DB-WAIT HANG ON SQL COMMIT IN A UDF

 APAR (Authorized Program Analysis Report)

Abstract

OSP-DB-WAIT HANG ON SQL COMMIT IN A UDF

Error Description

SEE PROBLEM SUMMARY.                                            

Problem Summary

The SQL COMMIT in a UDF hangs.  No error is indicated.          

Problem Conclusion

SQL cursors are closed on a COMMIT without                      
HOLD.  SQL cursors are also closed on a                        
ROLLBACK.                                                      
The COMMIT is not allowed in a UDF since the UDF                
is invoked from an SQL cursor.                                  
The SQL processing has been changed to detect                  
that the COMMIT or ROLLBACK has been requested                  
for the same activation group that the cursor                  
that invoked the UDF was running in.                            
A MSGCPF83D0 Commitment operation not allowed                  
error will be issued.  A MSGSQL0751 SQL statement              
not allowed will be issued.                                    

Temporary Fix

Comments

Circumvention


Do not allow the COMMIT or ROLLBACK to occur in                

the UDF.                                                        
Perform the COMMIT or ROLLBACK in the primary thread            
once the UDF has completed.                                    

PTFs Available

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... No
Component.................................. 5722SS1DB
Failing Module.......................... RCHMGR
Reported Release................... R530
Duplicate Of..............................




System i Support

    IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

i family

Software version:

V5R3M0, V5R4M0

Operating system(s):

OS/400

Reference #:

SE26727

Modified date:

2007-06-08

Translate my page

Machine Translation

Content navigation