It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,230

question asked: Jan 17 '11, 3:33 p.m.
question was seen: 6,815 times
last updated: Jan 17 '11, 3:33 p.m.

Related questions

D_DATE is not populated

0
Nataliya Kisina (86●21●15) | asked Jan 17 '11, 3:33 p.m.
Hello All,

I had installed Insight 101 with Oracle. Installation went successfully and there were no errors creating RIDW. However, now I see that my D_DATE is not populated. Does anyone know how to populate this table manually?

Thank you,

Nataliya

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Lawrence Mandel (511●2●1) | answered Jan 19 '11, 9:23 a.m.
FORUM MODERATOR
Hi Nataliya,

Take a look at the following link in the Rational Insight 1.0.1 documentation

http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.help.doc/topics/t_extend_d_date.html
0
permanent link
James Kim (6) | answered Feb 14 '11, 12:34 p.m.
Hi Nataliya,

Take a look at the following link in the Rational Insight 1.0.1 documentation

http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.help.doc/topics/t_extend_d_date.html


Can anyone help me in getting the ExtendD_DATE.class to work?

I am following the instructions and trying to run the class by typing

java cp .;%CLASSPATH% -Duser="DB2 user" -Dpasswd="DB2 user password " -Ddbms="DB2" -Dalias="Insight database alias" -Dschema="Data mart schema" -Dstart="earliest year" -Dend="latest year" com.ibm.rational.rcpr.dw.procedures. ExtendD_DATE

into a command prompt. (replacing the argument values to match my settings)

I get a class not found error.

Am I suppose to navigate to a certain directory in the command prompt before attempting to run the class? Currently I am in the C:\Program Files\IBM\SQLLIB\java\jdk\bin\java directory using the java that came with db2, which is 1.6.

My CLASSPATH is set with:
.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar
0
permanent link
Nataliya Kisina (86●21●15) | answered Feb 15 '11, 2:18 p.m.
The way I solved my issue was to go to the
install_path\datawarehouse\dw diractory and run the command in this format:
java -Duser=DB2DBA -Dpasswd=db2dba -Ddbms="Oracle" -Dalias=RIDW -Dschema=RIDW -Dstart=2010 -Dend=2020 com.ibm.rational.rcpr.dw.procedures.PopulateD_DATE

Notice that I was using PopulateD_Date class. I was not able to use the ExtendD_Date. I had the same issue you had - class not found.

after that a file should be created: initD_Date.sql - in the work_spc folder under the dw folder. This script just contains a bunch of insert commands.
you will want to connect to the database using SQL plus and run the intD_Date.sql script.

This is how I solved my problem. Hope it helps.

Your answer

Register or to post 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.