Tag: db2

  • 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…