Howto configure Report Builder to store the report definitions in a DB2 database instead of the JENA TDB database?
when you install and configure Report Builder (part of JRS), the database used to store all the Report Builder (RB) configurations and report definitions is stored in a derby DB below /server/conf/rs/db directory.
I do not like to have databases somewhere stored in a program folder version depending. I also do like to have all production DB on DB2. And the fact, the derby DB is already 2GB large, tells me it is not just for fun.
I have not found any documentation about this derby database of Report Builder so I ask here some questions.
Questions:
- Is there a way to change the database from JENA TDB to DB2?
- Is there a possibility to migrate existing RB database into DB2?
- Can I at least configure the location of the JENA TDB database?
- How does a JENA TDB database be backup-ed regularly? Just by copy the files around?
- Same for restore (hopefully never)?
Many thanks for clarification
Guido
Accepted answer
Comments
I changed my question so others are not confused by my wrong statement about the DB type.
Hello Steve,
I do not know exactly how many reports we have. I think more than 100 but less than 500. Is there a way to get a listing of all report in the DB?
the content of the DB directory looks like in next Answer (to large to post as comment):
If you see an irregularity, please tell me. I would then involve support.
thanks
Guido
One other answer
Directory of F:\Backup_DB2_DBs\daily_backups\Jazz_config\Backup-2015-11-12-61684\IBM\JazzTeamServer_RS_600\server\conf\rs\db
11/12/2015 08:22 AM <DIR> .
11/12/2015 08:22 AM <DIR> ..
11/05/2015 11:15 AM 251,658,240 GOSP.dat
10/19/2015 09:11 AM 33,554,432 GOSP.idn
11/05/2015 11:15 AM 260,046,848 GPOS.dat
10/19/2015 09:08 AM 33,554,432 GPOS.idn
11/05/2015 11:15 AM 251,658,240 GSPO.dat
10/19/2015 09:11 AM 33,554,432 GSPO.idn
01/14/2015 06:44 PM 0 journal.jrnl
11/09/2015 11:41 AM 226,492,416 node2id.dat
01/14/2015 06:44 PM 8,388,608 node2id.idn
11/11/2015 09:13 AM 15,333,227 nodes.dat
01/14/2015 06:44 PM 8,388,608 OSP.dat
01/14/2015 06:44 PM 8,388,608 OSP.idn
11/05/2015 11:15 AM 243,269,632 OSPG.dat
10/11/2015 01:54 PM 25,165,824 OSPG.idn
01/14/2015 06:44 PM 8,388,608 POS.dat
01/14/2015 06:44 PM 8,388,608 POS.idn
11/05/2015 11:15 AM 251,658,240 POSG.dat
11/10/2015 04:17 PM 25,165,824 POSG.idn
01/14/2015 06:44 PM 8,388,608 prefix2id.dat
01/14/2015 06:44 PM 8,388,608 prefix2id.idn
01/14/2015 06:44 PM 0 prefixes.dat
01/14/2015 06:44 PM 8,388,608 prefixIdx.dat
01/14/2015 06:44 PM 8,388,608 prefixIdx.idn
01/14/2015 06:44 PM 8,388,608 SPO.dat
01/14/2015 06:44 PM 8,388,608 SPO.idn
11/05/2015 11:15 AM 251,658,240 SPOG.dat
10/19/2015 09:08 AM 33,554,432 SPOG.idn
27 File(s) 2,028,599,147 bytes
