Comments (7)
  • Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

1 scrump commented Permalink

I received this same issue when transferring my database from Derby to DB2 yesterday. I used the create-database configengin command but as you mention it seems to fail in creating some of the JCR elements.

 
Using the DB2CMD line I ran the manual commands to update the dB2 JCR tables, many of them failed but a few were successful, and subsequently my database-tranfer completed OK.
 
I'm going to raise this as a potential bug via the PMR system.
 
Stuart

2 CodyBurleson commented Permalink

Thanks for this, guys. I got the same problem and your notes help me get past it fast.

3 JohnnyTeoh commented Permalink

Great pointer for people using the Config Engine to Transfer DB...maybe they should factor step 6 as part of the automatic script...

4 VitoMorales commented Permalink

I'm having the same problem using Portal 7 using ConfigWizard on AIX, anybody knows whether is a ifx available?

5 VitoMorales commented Permalink

Here's the solution:
Must run as DB2 instance manager:

 
db2 "CONNECT TO jcrdb USER jcr USING dbpassword"
db2 "CREATE BUFFERPOOL ICMLSFREQBP4 SIZE 1000 PAGESIZE 4 K"
db2 "CREATE BUFFERPOOL ICMLSVOLATILEBP4 SIZE 16000 PAGESIZE 4 K"
db2 "CREATE BUFFERPOOL ICMLSMAINBP32 SIZE 16000 PAGESIZE 32 K"
db2 "CREATE BUFFERPOOL CMBMAIN4 SIZE 1000 PAGESIZE 4 K"
db2 "CREATE REGULAR TABLESPACE ICMLFQ32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLFQ32') BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE REGULAR TABLESPACE ICMLNF32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLNF32') BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE REGULAR TABLESPACE ICMVFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMVFQ04') BUFFERPOOL ICMLSVOLATILEBP4"
db2 "CREATE REGULAR TABLESPACE ICMSFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMSFQ04') BUFFERPOOL ICMLSFREQBP4"
db2 "CREATE REGULAR TABLESPACE CMBINV04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('CMBINV04') BUFFERPOOL CMBMAIN4"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('icmlssystspace32') BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlssystspace4') BUFFERPOOL ICMLSVOLATILEBP4"
db2 "CREATE USER TEMPORARY TABLESPACE ICMLSUSRTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlsusrtspace4') BUFFERPOOL ICMLSVOLATILEBP4"
db2 "UPDATE DB CFG FOR jcrdb USING DFT_QUERYOPT 2"
db2 "UPDATE DB CFG FOR jcrdb USING PCKCACHESZ 16384"
db2 "DISCONNECT jcrdb"
db2 "TERMINATE"

6 JoeBreal commented Permalink

Isn't the process broken? Shouldn't this be an APAR?

7 molivas commented Permalink

There is an easier way. Since the properties files have already been updated you can just go to
<wp profile="profile">/ConfigEngine and run
ConfigEngine.bat(sh) setup-database
Default for Linux:/opt/IBM/WebSphere/wp_profile/ConfigEngine

 
That should take care updating the JCR database with the correct settings before transferring over the data.
Then go back to using the ConfigWizard.
I agree that this is a bug and should be fixed in the ConfigWizard.
 
</wp>