Hello all,

 

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

00.png

 

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

02.png

 

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

 

08.png

09.png

Back to the Administration Explorer at the left and make sure the new database is loaded under the instance

010.png

Right click our new created database > Setup and Configure > Configure

 

The database Configuration window will open

 

011.png

 

 

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

012.png

2- In the filter box type "lock"

Under the Application node

Set the Pending value of LOCkTIMEOUT to "180" and MAXLOCKS to "20"

 

 

013.png

3 -in the filter box type "log"

Under LOGGING node  Change the pending value of LOGFILSIZ to "10000"

 

 

022.png

 

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

023.png

Click the Run Button on the top pf the page and notice the deployment status for current command at the bottom window

024.png

025.png

NOW

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

016.png

 

 

017.png

 

 

018.png

 

Type the following Code

db2set DB2_EVALUNCOMMITTED=OFF

db2set DB2_SKIPINSERTED=OFF

db2set DB2_SKIPDELETED=OFF

 

019.png

Click Run Button in the Command Page and notice the notice the deployment status for current command at the bottom window

 

020.png

 

021.png

 

 

 

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

026.png

 

The repository creator utility  wizard will start and we have 8 steps to complete

1- in the first step click next button

027.png

 

2- Choose  "Create repository" and under it choose "System load and product load" and Click Next

028.png

 

 

3- in the Database Type Select "IBM DB2"

 

029.png

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

Click next

 

030.png

 

The RCu will check the prerequisites

Click OK after  finishing

031.png

 

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

D_STB

D_OPSS

D_IAU

D_IAU_A

D_IAU_V

D_MDS

D_WLS

D_BFORM

 

032.png

 

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

 

2017-03-12_012009.png

 

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:

D_STB

D_OPSS

D_IAU

D_IAU_A

D_IAU_V

D_MDS

D_WLS

D_BFORM

and give them the same password ( you can use another password rather than we used for db creation)

034.png

 

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

035.png

 

In the map table spaces :click next

 

036.png

 

 

A confirmation dialogue box will appear , click OK to confirm the creation of the table spaces

037.png

 

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

Click Create

 

039.png

The Completion Summery is the last screen, indicates a successful Repository Creation  Click Close

040.png

And That's all

 

Thank you for reading

Hammam Samir