APAR status
Closed as program error.
Error description
create procedure "tstdba".test1 () end procedure; grant execute on procedure "tstdba".test1 () to "davidb" as "tstdba"; revoke execute on procedure "tstdba".test1 () from public as "tstdba"; revoke execute on procedure "tstdba".test2 () from public as "tstdba"; revoke usage on language SPL from public ; grant usage on language SPL to public ; ptang@bia 224: dbschema -d david -f test1 -p all -ss DBSCHEMA Schema Utility INFORMIX-SQL Version 11.50.UC8 grant dba to "ptang"; create procedure "tstdba".test1 () end procedure; grant execute on procedure "tstdba".test1 () to "davidb" as "tstdba"; revoke execute on procedure "tstdba".test1 () from public as "tstdba"; revoke execute on procedure "tstdba".test2 () from public as "tstdba"; <======== revoke was printed for test2 as well. revoke usage on language SPL from public ; grant usage on language SPL to public ;
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All platforms * **************************************************************** * PROBLEM DESCRIPTION: * * dbschema print out extra information while user wanted to * * print information for specific table. * **************************************************************** * RECOMMENDATION: * * upgrade to 11.50.xC8 * ****************************************************************
Problem conclusion
Fix was checked into 11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC69704
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-07-06
Closed date
2011-01-20
Last modified date
2011-01-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 January 2011