-
Updating a database option in DB2
Sometimes after a database has been created, you may want to move where the default log path is. Or you may want to change DB2 places the log path in the home directory, and you may want to have the logs stored on another storage device. Login as the DB2 adminstrative user, then type the…
-
Updating the log path in DB2
Sometimes after a database has been created, you may want to move where the default log path is. DB2 places the log path in the home directory, and you may want to have the logs stored on another storage device. Login as the DB2 adminstrative user, then type the following command to change your log…
-
Dropping a DB2 database
Normally, to drop a database in DB2, you run the following command: >db2 drop db YourDb If you run into errors trying to drop the database, you may need to recatalog the database. You can run the following series of commands: >db2 uncatalog db YourDb >db2 catalog database Restart DB2. Then run: >db2 drop db…
-
Changing a DB2 server name
If you find DB2 not being able to start because of a server name problem, it most likely is caused by moving a virtual machine and not renaming the DB2 database. To update DB2 to the proper name: Stop DB2 as administrator (db2inst user). >su – db2inst >db2stop If there are open database connections, then…