IBM Support

SE73961 - OSP-DB-OTHER-UNPRED DB2M RCL CHGOBJOWN SQL VARIABLE

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-UNPRED DB2M RCL CHGOBJOWN SQL VARIABLE

Error Description

When creating an SQL variable with user A and then transferring
ownership to user B, the system catalogs show the wrong        
ownership for the variable on the secondary host, once that    
schema is added to the DB2 Mirror RCL.                          
Catalogs show the correct ownership if variable creation and    
ownership transfer happens while the schema is already mirrored.

Problem Summary

When creating an SQL variable with user A and then transferring
ownership to user B, the system catalogs show the wrong        
ownership for the variable on the secondary host, once that    
schema is added to the DB2 Mirror RCL.                          
Catalogs show the correct ownership if variable creation and    
ownership transfer happens while the schema is already mirrored.

Problem Conclusion

  Some variable information, including the OWNER is stored      
internally in the *SRVPGM object.  This information was not    
being updated when a CHGOBJOWN is done against the variable.    
This information is used to populate the catalog entry when a  
RSTOBJ is done for a variable.                                  
  The internal information will now be updated during a        
CHGOBJOWN operation.                                            
  The CHGOBJOWN operation will need to be done again after the  
PTF for this APAR is applied in order to correct the internally
stored information.                                            

Temporary Fix

Comments

Circumvention


PTFs Available

R720 SI73770  1084

R730 SI73769  0310

R740 SI73768  0303

Affected Modules


         
         

Affected Publications

Summary Information

Status............................................CLOSED PER
HIPER...........................................No
Component..................................5770SS1DB
Failing Module..........................RCHMGR
Reported Release...................R740
Duplicate Of..............................




IBM 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, 2018, 2019, 2020, 2021 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.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2; 7.3; 7.4","Product":{"code":"SG15Q","label":"APARs - OS\/400 General"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
16 April 2021