203 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
System Info Report
Thu, Jan 19th 2017 8
Cumulative Hotfix 9001-ST-Proxy-FP-WLIN-A8ZJ5B for Sametime Proxy 9.0.0.1 [April 2016]
Wed, Apr 27th 2016 4
What do you think of when you hear IBM?
Tue, Apr 19th 2016 5
Your ACTION Required for Sametime 9 iOS Customers before May 5, 2016 - Updated security certificate for Push Notifications (iOS)
Mon, Apr 18th 2016 2
Sametime VMCU Capacity
Thu, Oct 8th 2015 4
Documentação em Português do IBM Sametime 9
Wed, Sep 30th 2015 2
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 5
Top 10
IBM Notes Traveler 9.0.1 IF5 released.
Wed, Jul 30th 2014 10
Sametime 9 Video Manager install fails - solidDB tables are not created at install
Tue, Sep 16th 2014 8
System Info Report
Thu, Jan 19th 2017 8
How to Recover a Lost IKeyman Key Password
Thu, Nov 27th 2014 6
Sametime Meeting Server - Changing Meeting Room URLs to Hide Owner E-mail Addresses
Fri, Nov 14th 2014 6
CWWIM4551E Change handler was not defined for repository type 'DOMINO'
Wed, Aug 27th 2014 6
Changing the Default Directory Path for a DB2 Instance
Fri, Jul 25th 2014 6
Configuring LDAP for Domino on the Sametime Meeting Recording / Renderer Server on WAS 8.5.5.5
Tue, Sep 29th 2015 5
Ubuntu 14.04.1 LTS Post Install Tasks
Sat, Dec 6th 2014 5
What do you think of when you hear IBM?
Tue, Apr 19th 2016 5


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



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




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