198 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
System Info Report
Thu, Jan 19th 2017 9
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 7
What do you think of when you hear IBM?
Tue, Apr 19th 2016 8
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 4
Documentação em Português do IBM Sametime 9
Wed, Sep 30th 2015 3
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 7
Top 10
System Info Report
Thu, Jan 19th 2017 9
What do you think of when you hear IBM?
Tue, Apr 19th 2016 8
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 7
Ubuntu 14.04.1 LTS Post Install Tasks
Sat, Dec 6th 2014 7
CWWIM4551E Change handler was not defined for repository type 'DOMINO'
Wed, Aug 27th 2014 7
Recommendations for Network FIle System (NFS) Shared Area in Connections / Message Stores in Websphere
Wed, Jul 30th 2014 7
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 7
IBM Connections 5.0 Cumulative Refresh 1 (CR1) Released!
Thu, Oct 16th 2014 6
How to Recover a Lost IKeyman Key Password
Thu, Nov 27th 2014 5
Sametime VMCU Capacity
Thu, Oct 8th 2015 4


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
4 hits



Recent Blog Posts
9
System Info Report
Thu, Jan 19th 2017 8:23p   Dan Silva




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