Raible's Wiki: AppFuseOnDB2

-       Raible's Wiki




    Raible Designs

Wiki Home

News

Recent Changes

AppFuse
Homepage

  -  Korean

  -  Chinese

  -  Italian

  -  Japanese

QuickStart Guide

  - Chinese
 
  - French

  - German

  - Italian

  - Korean

  - Portuguese

  - Spanish

  - Japanese


User Guide

  - Korean

  - Chinese
 

Tutorials

  -  Chinese

  -  German

  -  Italian

  -  Korean

  -  Portuguese

  -  Spanish


FAQ

  -  Korean


Latest Downloads

Other Applications
Struts Resume

Security Example

Struts Menu



    




    

    
         
        Set your name in

        UserPreferences
            
    





       
       
       
       




    

Referenced by

AppFuseOnPostgreSQL
AppFuseSupport
Articles
Articles_cn
Articles_de
Articles_pt
Articles_zh
CreateDAO
CreateDAO_de
CreateDAO_es
...and 4 more



    




   



   
   JSPWiki v2.2.33 
   



       
           

           

           
           
           


           Hide Menu
+            AppFuseOnDB2
            



  
    Search Wiki:
    
    
  



         
         
            Your trail: 
         
      

      


      

      
         



      
          Difference between 
          version 7 
          and 
          version 6:
          

          
At line 11 added 1 line.
* [6] Sample CREATE DATABASE script
At line 200 added 30 lines.

!!Sample CREATE DATABASE script [#6]
After encountering the page size problems above, I spent some time creating a database creation script that sets suitable page sizes for table spaces.  I also modified AppFuse so that the "defaultAutoCommit" is "true" out of the box.  I tested this on Windows and nothing was case sensitive (all databases and tablespaces names got created in uppercase).

{{{
-- Create the APPFUSE database
create database appfuse 

-- Connect to database
connect to appfuse user db2admin using 'db2admin'

-- Create the APPFUSE 8K Buffer Pool
-- The IBMDEFAULTBP buffer pool cannot be dropped (SQLSTATE 42832)
-- https://aurora.vcu.edu/db2help/db2s0/sqls0629.htm#HDRDROPP 
create bufferpool APPFUSE_BP size 250 pagesize 8 k

-- Create the APPFUSE 8K User Tablespace
drop tablespace userspace1
create tablespace userspace1 pagesize 8 k managed by system using 
    ('C:\DB2\NODE0000\SQL00001\SQLT0002.0') bufferpool APPFUSE_BP

-- Create the APPFUSE 8K Temp Tablespace
create temporary tablespace APPTRACK_TEMP pagesize 8 k 
    managed by system 
    using ('C:\DB2\NODE0000\SQL00001\SQLT0003.0') 
    bufferpool APPFUSE_BP
       
-- DB2 Users are mapped to OS Users, so we can't create them in SQL
-- Do this mapping (or New User Creation) manually using the Control Center
}}}


          

      

      

      
      Back to AppFuseOnDB2,
       or to the Page History.
       

      

      

      

      

      

      

      

      Show Menu
-AppFuseOnDB2
+    Search Wiki:
 At line 11 added 1 line.
+* [6] Sample CREATE DATABASE script
 At line 200 added 30 lines.
+!!Sample CREATE DATABASE script [#6]
+After encountering the page size problems above, I spent some time creating a database creation script that sets suitable page sizes for table spaces.  I also modified AppFuse so that the "defaultAutoCommit" is "true" out of the box.  I tested this on Windows and nothing was case sensitive (all databases and tablespaces names got created in uppercase).
+{{{
+-- Create the APPFUSE database
+create database appfuse
+-- Connect to database
+connect to appfuse user db2admin using 'db2admin'
+-- Create the APPFUSE 8K Buffer Pool
+-- The IBMDEFAULTBP buffer pool cannot be dropped (SQLSTATE 42832)
+-- https://aurora.vcu.edu/db2help/db2s0/sqls0629.htm#HDRDROPP
+create bufferpool APPFUSE_BP size 250 pagesize 8 k
+-- Create the APPFUSE 8K User Tablespace
+drop tablespace userspace1
+create tablespace userspace1 pagesize 8 k managed by system using
+    ('C:\DB2\NODE0000\SQL00001\SQLT0002.0') bufferpool APPFUSE_BP
+-- Create the APPFUSE 8K Temp Tablespace
+create temporary tablespace APPTRACK_TEMP pagesize 8 k
+    managed by system
+    using ('C:\DB2\NODE0000\SQL00001\SQLT0003.0')
+    bufferpool APPFUSE_BP
+-- DB2 Users are mapped to OS Users, so we can't create them in SQL
+-- Do this mapping (or New User Creation) manually using the Control Center
+}}}