APAR status
Closed as program error.
Error description
The SQL error "-272 No SELECT permission for table/column." should be returned by the "dbschema -d database_name -hd table_name" command when the user does not have select permission for the table specified in the command, but does not do so. The command appears to run without error and yet does not return distribution information or indicate an error has occurred.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * dbschema users * **************************************************************** * PROBLEM DESCRIPTION: * * The "dbschema -hd" does not return distributions information * * but runs without error on the table without select * * privileges. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC6 and above. * ****************************************************************
Problem conclusion
Problem first fixed in IDS 11.50.xC6. dbexport will now show "-272 - No SELECT permission for tab1." on all platforms.
Temporary fix
Comments
APAR Information
APAR number
IC63281
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
2009-09-21
Closed date
2009-10-30
Last modified date
2009-10-30
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:
30 October 2009