IBM Support

SE64014 - OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 APAR (Authorized Program Analysis Report)

Abstract

OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT

Error Description

  Customer asked for an enhancement for some cases where a      
SQL0913 is issued so that they know which job held the lock on  
the object. They asked for this in the ALTER TABLE path where a
CPF4270, CPF3202 OR cpf3203 precedes the SQL0913.              
  They also asked for the support for a failure during a FAST  
DELETE operation.                                              

Problem Summary

  Customer asked for an enhancement for some cases where a      
SQL0913 is issued so that they know which job held the lock on  
the object. They asked for this in the ALTER TABLE path where a
CPF4270, CPF3202 OR cpf3203 precedes the SQL0913.              
  They also asked for the support for a failure during a FAST  
DELETE operation.                                              

Problem Conclusion

  For some ALTER TABLE operations and for any operation where an
open of a cursor is done and a SQL0913 is issued the SQL0913    
will be preceded by a CPD6DEF diagnostic message.              
  The format of the first level text is:                        
                                                               
<qualified-job-name> HOLDS <lock-state> LOCK FOR                
<library-name>/<file-name>                                      

Temporary Fix

Comments

Circumvention


PTFs Available

R710 SI59577 PTF Cover Letter   6320
R720 SI59578 PTF Cover Letter   6306
R730 SI59579 PTF Cover Letter   6085

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... No
Component.................................. 5770SS1DB
Failing Module.......................... RCHMGR
Reported Release................... R710
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, 2014, 2015, 2016, 2017 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

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15Q","label":"APARs - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0;V7R2M0;V7R3M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 December 2016