SE44672 - OSP-DB FILES DELETED AFTER INSTALLING PTF'S

 APAR (Authorized Program Analysis Report)

Abstract

OSP-DB FILES DELETED AFTER INSTALLING PTF'S

Error Description

QSYS2 files deleted after installing PTF's. The following files
are deleted from system: SQLPRIKEYS SQLFORKEYS REF_CST2 REF_CST1
CHECK_CSTS TABLE_CSTS TABLE_CSTS SYSCST SYSCSTCOL SYSCHKCST    
SYSCSTDEP SYSREFCST Job nnnnnn/QSYS/QDBSRVXR2 shows: msgCPF1124
Job 130465/QSYS/QDBSRVXR2 started msgCPC2191 Object SQLPRIKEYS  
in SYSIBM type *FILE deleted F/QLIDLOBJ T/QSQXRLF2 X/0602 X/0012
msgCPC2191 Object SQLFORKEYS in SYSIBM type *FILE deleted      
msgCPC2191 Object REF_CST2 in SYSIBM type *FILE deleted        
msgCPC2191 Object REF_CST1 in SYSIBM type *FILE deleted        
msgCPC2191 Object CHECK_CSTS in SYSIBM type *FILE deleted      
msgCPC2191 Object TABLE_CSTS in SYSIBM type *FILE deleted      
msgCPC2191 Object TABLE_CSTS in QSYS2 type *FILE deleted        
msgCPC2191 Object SYSCST in QSYS2 type *FILE deleted msgCPC2191
Object SYSCSTCOL in QSYS2 type *FILE deleted msgCPC2191 Object  
SYSCHKCST in QSYS2 type *FILE deleted msgCPC2191 Object        
SYSCSTDEP in QSYS2 type *FILE deleted msgCPC2191 Object        
SYSREFCST in QSYS2 type *FILE deleted F/QLIDLOBJ T/QSQXRLF2    
X/0602 X/003E msgCPF3202 File SYSRTNDEP in library QSYS2 in use
F/QDBGRTFI T/QSQCCATV X/1503 X/0E8F msgCPF22BE Function not done
for user profile *PUBLIC F/QSYRVAUT T/QSQCCATV X/1503 X/0E8F    
msgCPF2227 One or more errors occurred during processing of    
command F/QSYRVAUT T/QSQCCATV X/0F0E X/0E8F msgCPF9999 Function
check for QSQCCATV at instruction X'0E8F' msgCPF2499 Message    
identifier ?B - not valid F/QMHSNDPM T/QSQCCATV X/0D65 X/1034  
msgCPA0701 CPF9999 received by QSQXRLF2 at . (C D I R) D        
msgSQL7909 Routine SQLGETAUTH created, but cannot be            
saved/restored msgSQL7909 Routine SQLGETVIEW created, but cannot
be saved/restored ... ...More routine created messages..        
msgSQL0204 SYSCST in QSYS2 type *FILE not found. msgSQL0204    
SQLPRIMARYKEYS in SYSIBM type *FILE not found. msgSQL0204      
SQLPRIMARYKEYS in SYSIBM type *FILE not found. msgSQL0204 Object
SQLPRIKEYS in library SYSIBM type *FILE not found msgSQL0443    
Trigger program or external routine detected an error ...      
...Normal file change operations, etc...                        

Problem Summary

QSYS2 files deleted after installing PTF's. The following files
are deleted from system: SQLPRIKEYS SQLFORKEYS REF_CST2 REF_CST1
CHECK_CSTS TABLE_CSTS TABLE_CSTS SYSCST SYSCSTCOL SYSCHKCST    
SYSCSTDEP SYSREFCST Job nnnnnn/QSYS/QDBSRVXR2 shows: msgCPF1124
Job 130465/QSYS/QDBSRVXR2 started msgCPC2191 Object SQLPRIKEYS  
in SYSIBM type *FILE deleted F/QLIDLOBJ T/QSQXRLF2 X/0602 X/0012
msgCPC2191 Object SQLFORKEYS in SYSIBM type *FILE deleted      
msgCPC2191 Object REF_CST2 in SYSIBM type *FILE deleted        
msgCPC2191 Object REF_CST1 in SYSIBM type *FILE deleted        
msgCPC2191 Object CHECK_CSTS in SYSIBM type *FILE deleted      
msgCPC2191 Object TABLE_CSTS in SYSIBM type *FILE deleted      
msgCPC2191 Object TABLE_CSTS in QSYS2 type *FILE deleted        
msgCPC2191 Object SYSCST in QSYS2 type *FILE deleted msgCPC2191
Object SYSCSTCOL in QSYS2 type *FILE deleted msgCPC2191 Object  
SYSCHKCST in QSYS2 type *FILE deleted msgCPC2191 Object        
SYSCSTDEP in QSYS2 type *FILE deleted msgCPC2191 Object        
SYSREFCST in QSYS2 type *FILE deleted F/QLIDLOBJ T/QSQXRLF2    
X/0602 X/003E msgCPF3202 File SYSRTNDEP in library QSYS2 in use
F/QDBGRTFI T/QSQCCATV X/1503 X/0E8F msgCPF22BE Function not done
for user profile *PUBLIC F/QSYRVAUT T/QSQCCATV X/1503 X/0E8F    
msgCPF2227 One or more errors occurred during processing of    
command F/QSYRVAUT T/QSQCCATV X/0F0E X/0E8F msgCPF9999 Function
check for QSQCCATV at instruction X'0E8F' msgCPF2499 Message    
identifier ?B - not valid F/QMHSNDPM T/QSQCCATV X/0D65 X/1034  
msgCPA0701 CPF9999 received by QSQXRLF2 at . (C D I R) D        
msgSQL7909 Routine SQLGETAUTH created, but cannot be            
saved/restored msgSQL7909 Routine SQLGETVIEW created, but cannot
be saved/restored ... ...More routine created messages..        
msgSQL0204 SYSCST in QSYS2 type *FILE not found. msgSQL0204    
SQLPRIMARYKEYS in SYSIBM type *FILE not found. msgSQL0204      
SQLPRIMARYKEYS in SYSIBM type *FILE not found. msgSQL0204 Object
SQLPRIKEYS in library SYSIBM type *FILE not found msgSQL0443    
Trigger program or external routine detected an error ...      
...Normal file change operations, etc...                        

Problem Conclusion

Exit program processing for SQL catalog management has been    
modified to detect when objects are 'in use' to avoid exit      
program processing failures do to lock contention.              

Temporary Fix

Comments

Circumvention


PTFs Available

R710 SI42586 PTF Cover Letter   1116

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... No
Component.................................. 5770SS1DBSI4
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 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:

V7R1M0

Operating system(s):

OS/400

Reference #:

SE44672

Modified date:

2011-08-11

Translate my page

Machine Translation

Content navigation