DB2 - Problem description
| Problem IC96837 | Status: Closed |
DB2UPDV10 RETURN ERROR: SYSDEBUGPRIVATE, -204 | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
When execute db2updv10 on DB2 10.1 FP3 on a v101GA database it
fails with error -204.
db2updv10 -d SAMPLE
________________________________________________________
_____ DB2 Service Tools _____
I B M
db2updv10
This tool is a service utility designed to update a DB2
Version 10.1
database to the current fix pack level.
_______________________________________________________________
DB2 Universal Database Version 10.1, 5622-044 (c) Copyright IBM
Corp.
2011
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool
MESSAGE: SYSCAT.ROUTINEAUTH had 0 rows successfully updated.
MESSAGE: SYSCAT.MODULEAUTH had 0 rows successfully updated.
MESSAGE: Error granting execute on SYSPROC.
ADMIN_REVALIDATE_DB_OBJECTS_NEW to role SYSDEBUGPRIVATE, -204
MESSAGE: Rolling back work due to sqlcode: -204 on line 833.
db2updv10 processing failed for database 'SAMPLE'.
Additionally, debugging a stored procedure from Data Studio may
also see a message stating that a SQLException occurred:
"SYSDEBUGPRIVATE" is an undefined name, SQLCODE=-204,
SQLSTATE=42704 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 10.1 FP3 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.1 Fix Pack 4 * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
| Solution | |
DB2 10.1 FP4 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.10.2013 18.04.2014 18.04.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.4 |
|