199 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
System Info Report
Thu, Jan 19th 2017 6
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 3
What do you think of when you hear IBM?
Tue, Apr 19th 2016 6
Your ACTION Required for Sametime 9 iOS Customers before May 5, 2016 - Updated security certificate for Push Notifications (iOS)
Mon, Apr 18th 2016 4
Sametime VMCU Capacity
Thu, Oct 8th 2015 5
Documentação em Português do IBM Sametime 9
Wed, Sep 30th 2015 6
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 6
Top 10
Sametime Meeting Server - Changing Meeting Room URLs to Hide Owner E-mail Addresses
Fri, Nov 14th 2014 10
Ubuntu 14.04.1 LTS Post Install Tasks
Sat, Dec 6th 2014 8
Sametime 9 Video Manager install fails - solidDB tables are not created at install
Tue, Sep 16th 2014 8
New on devWorks: "IBM Lotus Domino with BlackBerry Enterprise Server: Performance best practices"
Tue, Oct 7th 2008 7
Domino Server Performance Open Mic conference call - June 25, 2008
Fri, Jun 20th 2008 7
Documentação em Português do IBM Sametime 9
Wed, Sep 30th 2015 6
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 6
IBM Sametime Proxy Server - add tokenDomain to your stproxyconfig.xml to fix SSO issues
Tue, Mar 31st 2015 6
IBM Connections 5.0 Cumulative Refresh 1 (CR1) Released!
Thu, Oct 16th 2014 6
Recommendations for Network FIle System (NFS) Shared Area in Connections / Message Stores in Websphere
Wed, Jul 30th 2014 6


Changing the Default Directory Path for a DB2 Instance
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

Implementing Connections at a customer site, the databases were getting created in /home/db2inst1 instead of the dedicated filesystem set aside for it.
This is how to change the default database directory for an instance.  

1. Find out what the default database path is:
db2inst1@db2p143:~> db2 "get dbm cfg" | grep -i dftdbpath
 Default database path                       (DFTDBPATH) = /home/db2inst1

 
2. Change the default database path to what you'd like it to be:
db2inst1@db2p143:~> db2 "update dbm cfg using dftdbpath /db2/db2inst1/connections/data1 immediate"
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.

3. Confirm the change was made:
db2inst1@db2p143:~> db2 "get dbm cfg" | grep -i dftdbpath
 Default database path                       (DFTDBPATH) = /db2/db2inst1/connections/data1

 
4. Stop the db2 instance:
 db2inst1@db2p143:~> db2stop
0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
5. Restart the db2 instance:
db2inst1@db2p143:~> db2start
0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

Done! After that, you can re-run your database creation scripts and they will be created in the correct directory.


---------------------
http://dansilva.blogspot.com/2014/07/changing-default-directory-path-for-db2.html
Jul 25, 2014
5 hits



Recent Blog Posts
6
System Info Report
Thu, Jan 19th 2017 8:23p   Dan Silva
3
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 2:19p   Dan Silva
IBM has released a new Cumulative Hotfix for Sametime Proxy 9.0.0.1 9001-ST-Proxy-FP-WLIN-A8ZJ5B (April 2016)http://www-01.ibm.com/support/docview.wss?rs=899&uid=swg21981666 Change list for this hotfix: - server log cleanup - performance improvements for iNotes integration when scrolling the inbox - fix for unclickable links in chat transcript when URLs include default ports (e.g. :80 for HTTP, :443 for HTTPS) - support for integration with iNotes standards mode - fix for incorrect status m




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition