Deploying Rational CE/CLM on Amazon Web Services with their Relational Database Service
I am deploying the Rational CE solution on Amazon Web Services. They have a service called RDS, Relational Database Service. The official word from IBM support is that they don't support RDS. Does anyone have any experience using it successfully with Rational CE/CLM?
"RDS automates administration tasks such as hardware provisioning, database setup, patching and backups. Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server."
|
Accepted answer
I have no idea why IBM would say it's not supported, as it's just a hosted instance of MS SQL Server. I've done it with several clients and it works perfectly. The only thing I needed to do was make it single instance and not clustered.
Bob 3 selected this answer as the correct answer
Comments Davyd, as I go to actually create the databases in Amazon RDS, I have come upon a road block. The next step in my workflow is to establish a folder on the DB server for the data warehouse. How is this possible with Amazon RDS? I'm not aware of a way to gain access to the file system.
Quote from the IBM interactive installation guide:
1
Davyd Norris
commented Oct 23 '18, 5:48 p.m.
Hi Bob,
If you look at the settings in the RDS you can see where the database has been deployed and can use a folder in that location.
I ended up using D:\RDSDBDATA\BACKUP, which was one of the folders available to end users that did not get automatically deleted.
Bob 3
commented Oct 25 '18, 6:49 p.m.
I see that same path in my RDS database configuration, as well. How did you reference the path D:\RDSDBDATA\BACKUP from the JTS data warehouse setup?
Davyd Norris
commented Oct 25 '18, 7:04 p.m.
You literally put it in like that - it needs to be a DB server local reference that is passed direct to the DB when it first creates the warehouse tablespaces
|
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.