nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Creating repository Using RCU with IBM DB2 Database

Hammam Samir

Hello All,

I'm trying to create anew repository using the RCU in Oracle ( BI 12c )

The Connection To IBM DB2 ( V 10.5 "Since version 11.1 is not supported by oracle" ) was successful

When specifying the Prefix for all schema users (Step 4/8),

I used the default ("DEV") and i got a message that the user max length should be 8 Chars only while it suppose to be 12

So i used the letter ("D") only

when Defining the new users passwords ( I used same Password For all Schema ) (Step 5/8)

I got the following Error

While i created 2 operating system Users with all privileges granted

still get the same error

While I'm new to IBM DB2 Database, IS there any Way to complete the repository?

Thanks a lot

Hammam Samir

Find more posts tagged with

Accepted answers

All comments

Madasamy -Oracle

Hello,

If you still have that error,

a. D_BIPLATFORM and D_MDS , sounds fine for a username . am not sure what you gave for password. You can provide us a snippet of error from rcu.log

b. You can generate RCU Scripts from RCU utility, give it to your DBA and ask them to run it accordingly ( another work-around for 12c BI)

-M

Hammam Samir

Hello,

Thanks for reply

I think IBM DB2 Has another special configuration more than what specified in the Oracle Documentations for BI

To solve this problem i had to create 8 new operating system users With same password then

Configured the DB2 as the instructions in Oracle Documentation for BI and i created the repository

the users was as follows

D_STB

D-OPSS

D_BTFORM

D_IAU

D_IAU_A

D_IAU_V

D_MDS

D_WLS

Suppose I provide only one operating system users then this user will create the other 8

It succeeded,See the complete process here

Thanks

Madasamy -Oracle

Hello,

I am not sure about DB2 DBA. But when it comes to Oracle DB, the same set of users will be created as DB Users during schema creation. If it is in a way that DB2 require OS users, then this looks fine to proceed. But these users (DB or OS) are part of RCU creation

Hammam Samir

Yes, that is Right in Oracle DB and Suppose to be for DB2 also, but BD2 requires creation of at least one OS user to be set as admin which is enabled during the DB installation,

and during the creation of Repository the RCU wizard was unable to create the other 8 users and therefore it couldn't access them so i had create them manually

Thanks again

Madasamy -Oracle

Cool. So the issue is resolved

-M

Hammam Samir

Yes, thanks