JR54853: WHEN ENABLING DATA MOVEMENT SERVICES, GRANT STATEMENTS FOR ORACLE ARE GENERATED INCORRECTLY

IBM Business Monitor V8.5 Refresh Pack 7 (V8.5.7)

APAR status

• Closed as fixed if next.

Error description

• When you export a database script to enable data movement
  services, grant statements for Oracle are generated incorrectly.
   As a result, the grant statements fail, likely because of
  extraneous characters after a stored procedure name and before
  the "TO <user>" clause, similar to the following example:
  
  --GRANT STMT-- GRANT EXECUTE ON
  MMSCHEMA.SI_MCNAME_20151201114825AS PROCEDURE_PARAMETERS TO
  <user>;
  
  PRODUCT AFFECTED:
  IBM Business Monitor
  

Local fix

• Before running the database script, edit the grant statement to
  remove the extraneous characters after the date and time stamp
  and before the "TO <user>" clause. The grant statement is
  correct in the following example:
  
  --GRANT STMT-- GRANT EXECUTE ON
  MMSCHEMA.SI_MCNAME_20151201114825 TO <user>;
  

Problem summary

• The logic to generate data movement services grant statements
  for Oracle did not parse procedure names correctly.
  

Problem conclusion

• A fix will be incorporated into a later release that generates
  correct syntax for data movement services grant statements for
  Oracle.
  

Temporary fix

• Not applicable
  

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

Applicable component levels

• R855 PSN

     UP

• R856 PSN

     UP