Database Scripts for creating custom user repository in DB2

0 comments



Apart from the scripts that are required to setup the mandatory Portal databases, you might also want to setup user own user repository in DB2 database. The following script will create a database in DB2 for storing user credentials. This database can be used to create a custom user repository in DB2 and use the same to authenticate the portal users.

db2 "CREATE DB wimDb ON 'C:\', 'C:\IBM\wimDb' DBPATH ON 'C:\' using codeset UTF-8 territory us PAGESIZE 8192"
db2 "UPDATE DB CFG FOR wimDb USING applheapsz 4096"
db2 "UPDATE DB CFG FOR wimDb USING app_ctl_heap_sz 1024"
db2 "UPDATE DB CFG FOR wimDb USING stmtheap 32768"
db2 "UPDATE DB CFG FOR wimDb USING dbheap 2400"
db2 "UPDATE DB CFG FOR wimDb USING locklist 1000"
db2 "UPDATE DB CFG FOR wimDb USING logfilsiz 4000"
db2 "UPDATE DB CFG FOR wimDb USING logprimary 12"
db2 "UPDATE DB CFG FOR wimDb USING logsecond 20"
db2 "UPDATE DB CFG FOR wimDb USING logbufsz 32"
db2 "UPDATE DB CFG FOR wimDb USING avg_appls 5"
db2 "UPDATE DB CFG FOR wimDb USING locktimeout 30"
db2 "UPDATE DB CFG FOR wimDb using AUTO_MAINT off"

Replace the 'C:\', 'C:\IBM\wimDb' DBPATH ON 'C:\' with your own settings. C:\IBM\wimDb is the directory where DB data files will be stored. C:\ is the path under which DB2 directory will be created which will store DB configuration files.

No comments:

Post a Comment

Recent Posts

Popular Posts

© 2011-2019 Web Portal Club