Today I will share my experience in Creating ,Configuring IBM DB2 database and create Oracle BI Repository using Repository creation Utility which will be used to Configure Oracle BI 12C
The data base I'm using is IBM DB2 v 10.5 S( note that V11.1 is not supported by OBI 12c and you will get an error message that the database version is more recent the the supported versions by OBI 12c So Currently use version 10.5 )
Before starting Make sure that you enable the Operating System Security During the Installation of DB2 and have at least one operating system user
in my case i used the default user name "db2admin" which created during the installation
Open the IBM Data Studio and make sure your localhost server is connected and the DB2 instance is running,
also make sure the Secure Shell Server and DB2DAS Server are running i not you can Start them manually from windows local services
Now the time to start
Now in IBM Data Studio in the Administration Explorer Click the little icon on the top to create new database
IN the Dialogue box
1- in the Host name Type : localhost ( or the server name which you are using)
2- in the user name : Type ; db2admin ( or the operating system user name you created through the installation of the data base )
3 -in the password : type the password for the instance user you specified during the instance creation)
4-in the Instance name : Type the instance name or click the refresh button on the right to load the currently installed instances and choose the instance you want
5-in the Port Number : type the Port number on which the instance is running on in my case i used the default 50000
6- Click Finish
The database creation Window will open
IN the DB Creation window do the following
in the details Tape
1 -Tape the Database name
2 -Specify the database Location
3- Specify the alias
4 - in the default buffer pool and Table Space Page Size Choose the 32K ( Very important )
5 - Click Run button to create the database and note the deployment status for current command at the bottom window
Back to the Administration Explorer at the left and make sure the new database is loaded under the instance
Right click our new created database > Setup and Configure > Configure
The database Configuration window will open
In the database Configuration window we have tapes Instance and database
Click modify the Database Configuration parameters
1- In the filter box type "Cur_Commit"
under the environment node
Make sure that CUR_COMMIT is set to on , if not Change it's value to ON in the pending value column
2- In the filter box type "lock"
Under the Application node
Set the Pending value of LOCkTIMEOUT to "180" and MAXLOCKS to "20"
3 -in the filter box type "log"
Under LOGGING node Change the pending value of LOGFILSIZ to "10000"
4- in the filter box type"Logprimary"
under LOGGING node Change the Panding Value of LOGPRIMARY to "50"
I used the filter box for fast search
Click the Run Button on the top pf the page and notice the deployment status for current command at the bottom window
Click the Command Tape in the Configuration page and Click The Edit button and click OK
in the Dialogue Box to open the Configuration Parameters admin Command Window
Type the following Code
Click Run Button in the Command Page and notice the notice the deployment status for current command at the bottom window
Creating the Repository for OBI 12c
Now that our IBM DB2 is well configured to Work with Oracle Fusion middle ware , and before configuring the OBI 12c we need to create the repository, so let's create it
Assume that Oracle FMW and Oracle BI 12c Are properly installed
in the windows explorer navigate to Oracle_Home Directory > oracle_common>bin
for example "C:\Oracle\Middleware\Oracle_Home\oracle_common\bin"
and locate the file "rcu.bat"
Right click it and Choose Run As Administrator
The repository creator utility wizard will start and we have 8 steps to complete
1- in the first step click next button
2- Choose "Create repository" and under it choose "System load and product load" and Click Next
3- in the Database Type Select "IBM DB2"
For the connection details type the following :
1- Server Name : localhost
2- Port : 50000
3- Database name : Type the Database name that we have just configured in IBM data studio
4- Username : Type the Operating system user name of the database
5- Password : type the password of the database we have just configured
The RCu will check the prerequisites
Click OK after finishing
In the select component step:
1 -The maximum user length is only 8 characters so we will use only one letter "D" as a prefix for the users
2 - select all components in the components list
3- Reduce the default users names as follows
and here is the trick i did
when creating a repository using oracle database the wizard will go through the steps without any problem, but for IBM DB2 with operating system security enabled ( During the Installation) The wizard was unable to Access and create OS users with administrators privileges on windows and i got this error
So, I went out of the wizard for a while to create the above users manually on my OS
On windows 8 in PC settings>Accounts >other Accounts
Add the following 8 users that we specified:
and give them the same password ( you can use another password rather than we used for db creation)
Now back again to the wizard and specify the same password that we have just used in he previous step and type it one more time to confirm it and click next
In the map table spaces :click next
A confirmation dialogue box will appear , click OK to confirm the creation of the table spaces
The RCU will Create the table Spaces for us
Now we reached the last step ( a summery page with the Schema Details, Components,Schema USers /Onwers , TableSpaces,....etc
The Completion Summery is the last screen, indicates a successful Repository Creation Click Close
And That's all
Thank you for reading