D_DATE is not populated
3 answers
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
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.
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.