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