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.
| APAR (Authorized Program Analysis Report) |
Abstract
OSP-DB-OTHER-F/#CCEXCEPX/010C-T/QQQVALIDX/33794-MSGMCH5003 A
SELECT STMT FAILS WITH MSGMCH5003 F/#CCEXCEP T/QQQVALID X/33794.
Error Description
After DB Fixpack #10 is applied, the following steps fail with
MSGMCH5003 f/#ccexcep x/010C t/QQQVALID x/33794.
1. CRTLIB libname
2. Create or Use an user profile with user class *USER and no
*ALLOBJ
CRTUSRPRF USRPRF(USER)
3. Change the authority on the library created at step 1
CHGAUT OBJ('/qsys.lib/libname') USER(USER) DTAAUT(*RX)
OBJAUT(*NONE)
EDTOBJAUT OBJ(QSYS/libname) OBJTYPE(*LIB) and remove the cross
at
OPR on Object authorities
Object ----------Object-----------
User Group Authority Opr Mgt Exist Alter Ref
*PUBLIC *CHANGE X
BAEUSER USER DEF
4. Use Run SQL Scripts or STRSQL to run the following SQL
statements
SET PATH "libname"
SELECT CURRENT_PATH FROM QSYS2.QSQPTABL
5. This will fail with MCH5003, CPF4204, MCH3601 and SQL0901.
Problem Summary
After DB Fixpack #10 is applied, the following steps fail with
MSGMCH5003 f/#ccexcep x/010C t/QQQVALID x/33794. 1. CRTLIB
libname 2. Create or Use an user profile with user class *USER
and no *ALLOBJ CRTUSRPRF USRPRF(USER) 3. Change the authority on
the library created at step 1 CHGAUT OBJ('/qsys.lib/libname')
USER(USER) DTAAUT(*RX) OBJAUT(*NONE) EDTOBJAUT OBJ(QSYS/libname)
OBJTYPE(*LIB) and remove the cross at OPR on Object authorities
Object ----------Object----------- User Group Authority Opr Mgt
Exist Alter Ref *PUBLIC *CHANGE X BAEUSER USER DEF 4. Use Run
SQL Scripts or STRSQL to run the following SQL statements SET
PATH "libname" SELECT CURRENT_PATH FROM QSYS2.QSQPTABL 5. This
will fail with MCH5003, CPF4204, MCH3601 and SQL0901.
Problem Conclusion
The handling of SET PATH has been corrected to not change the
path if the user is not authorized to any libraries specified on
the statement.
Temporary Fix
Comments
Circumvention
PTFs Available
R710 SI44243 
2115
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
Document Information
Modified date:
18 May 2012