Insight 1.1.1 data warehouse setup scripts missed
I think we are missing 2 files for creating the data warehouse databases when we setup Insight 1.1.1.
I have saved the script when I am doing rrdi/setup but in the readme.txt file shows 2 commands to run those are grantETLUSERPrivileges.sql and grantRIDWDataMartPrivileges.sql I can see only below sql files in RRDIDWFiles.zip folder initRISCHK.sql initRIODS.sql initRIDW_D_DATE.sql initRIDW.sql initRIASSET.sql initCONFIG.sql createRISCHK.ddl createRIODS.ddl createRIDWViews.ddl createRIDW.ddl createRIASSET.ddl createCONFIG.ddl README.txt createTBS.sql README.txt says to run below commands but those scripts are available to grant the permissions db2 -tvsf grantRIDWDataMartPrivileges.sql -z grantRIDWDataMartPrivileges.log db2 -tvsf grantETLUSERPrivileges.sql -z grantETLUSERPrivileges.log Does any one see the same behavior? If so we may need to report to Rational support to add them to fix it. Thanks, Om. |
One answer
Benjamin Silverman (4.1k●6●10)
| answered Sep 24 '12, 12:37 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Om,
This is discussed in Readme and SQL files are inconsistent of RRDIDWFiles (69622). The scripts mentioned in the readme are referencing a design that was not implemented, hence the scripts are not needed. I've re-opened the work item so that the readme.txt can be corrected in a future release. Hope it helps, |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.