cancel
Showing results for 
Search instead for 
Did you mean: 

IdM RDS

Former Member
0 Kudos

Hello Gurus,

Could you pls help me out on how to use the RDS stored procedure script for Oracle on DB2 ? I am on IDM 7.2 SP 9 With DB2 database and there is no script for DB2 in RDS package.

Regards

Samer

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member2987
Active Contributor
0 Kudos

Samer,

Not sure what you are asking here... What stored procedure? Did you import the RDS?

Matt

Former Member
0 Kudos

Hello Matt,

I want to import the RDS but my database is DB2 and I couldn't find the db2 scripts in the RDS package.

Is it possible to use the oracle scripts for db2 ? If yes could you pls let me know the procedure...

former_member2987
Active Contributor
0 Kudos

Samer,

It's been a while but aside from remembering that in scripts you need to remember that when checking databases DB2 is 5, as mentioned in this blog

so go ahead and try the oracle version

Former Member
0 Kudos

Hello Matt,

I did not understand this, Could u pls let me know where to set this DB2=5. Is it in scripts ?

Regards

Samer

former_member2987
Active Contributor
0 Kudos

You need to import the RDS first.  Then take a look at the blog post.  You should only need to update the scripts per the blog when the script is checking for a database type.

Matt

Former Member
0 Kudos

Hello Matt,

I have imported the RDS, But how to use the RDS_NEWSTOREDPROCEDURE_ORACLE.sql  for DB2... As per the config guide we need to import the stored procedure to the database..

former_member2987
Active Contributor
0 Kudos

Samer,

After reviewing the documentation, I would suggest engaging your DBAs on this to review to stored procedure.  I believe I ran it straight via DB2.  I don't recall if I executed the SP as we had no need for it.  I'd suggest reviewing the documentation on Page 11 of the D04-Identity Management 7.20 - Setup and Processioning document that comes with the RDS.

If you are still uncertain, I'd suggest opening a Support Note.

Matt