IC69704: DBSCHEMA PRINTS OUT EXTRA INFORMATION WHILE USER WANTED TO PRINTINFORMATION FOR SPECIFIC TABLE.

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 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